Fixed Assets
Tables of Fixed Assets
=================
1- FA_DEPRN_PERIODS
2- FA_DEPRN_SUMMARY
3- FA_ADDITIONS_B
4- FA_BOOKS
5- FA_CATEGORIES_B
6- FA_DEPRN_DETAIL
FA_DEPRN_PERIODS contains information about your depreciation periods. Oracle Assets uses this table to determine when each period in FA_CALENDARS was open for a depreciation book. PERIOD_OPEN_DATE and PERIOD_CLOSE_DATE are the dates when you opened and closed each book’s depreciation period. Each time you run the depreciation program, it closes the current period by setting PERIOD_CLOSE_DATE to the system date. It also opens the next period by inserting a new row into this table in which PERIOD_CLOSE_DATE is NULL and PERIOD_OPEN_DATE equals the PERIOD_CLOSE_DATE of the old row. CALENDAR_PERIOD_OPEN_DATE and CALENDAR_PERIOD_CLOSE_DATE correspond to your calendar as defined by the START_DATE and END_DATE columns in FA_CALENDAR_PERIODS.
FA_DEPRN_SUMMARY contains depreciation information for your assets. Each time you run the depreciation program, it inserts one row into thistable for each asset. PERIOD_COUNTER is the period for which you ran the depreciation program. DEPRN_AMOUNT is the depreciation expense for an asset in a depreciation period. It is the sum of DEPRN_AMOUNT in all the rows of FA_DEPRN_DETAIL for the asset and period. YTD_DEPRN is the accumulated depreciation of an asset for the current fiscal year as of the end of this period. DEPRN_RESERVE is the total accumulated depreciation for this asset. DEPRN_SOURCE_CODE tells you what program created the row BOOKS Created by the Depreciation Books form, Quick Additions form, or the post mass additions program when you enter a new asset. DEPRN Created by the depreciation program when you run depreciation. ADJUSTED_COST is the depreciable basis the depreciation program uses to calculate depreciation for an asset in a depreciation period. This value is the same as the asset’s recoverable cost, except for assets that use a diminishing value depreciation method, assets to which you have made an amortized adjustment, and assets you have revalued.
For assets that use a diminishing value method, the ADJUSTED_COST is the beginning of year net book value, which the depreciation program updates at the start of each fiscal year. When you perform an amortized adjustment on an asset or revalue it, the ADJUSTED_COST becomes the asset’s net book value at the time of the adjustment or revaluation. BONUS_RATE is the bonus rate that Oracle Assets adds to the adjusted rate to give you the flat rate for the fiscal year. The depreciation program uses this rate to calculate depreciation for an asset. This only applies to assets that use both a flat–rate depreciation method and bonus depreciation.
FA_ADDITIONS_B contains descriptive information to help you identify your assets. Oracle Assets does not use this table to calculate depreciation.When you add an asset, Oracle Assets inserts a row into this table and into FA_ASSET_HISTORY. When you change the asset information stored in this table, Oracle Assets updates it in this table. It also creates a new row in FA_ASSET_HISTORY. When you perform a unit retirement, Oracle Assets reduces the CURRENT_UNITS by the units retired. UNIT_ADJUSTMENT_FLAG is set to YES by the Additions form if you change the number of units for an asset. The Transfers form resets it to NO after you reassign the remaining units. FA_ADJUSTMENTS stores information that Oracle Assets needs to create journal entries for transactions. The posting program creates journal entries for regular depreciation expense from information in FA_DEPRN_DETAIL. Oracle Assets inserts a row in this table for the debit and credit sides of a financial transaction. All the rows for the same transaction have the same value in the TRANSACTION_HEADER_ID column. The SOURCE_TYPE_CODE column tells you which program created the adjustment:
- ADDITION Depreciation program
- ADJUSTMENT Expensed or Amortized Adjustment User Exit
- CIP ADDITION Depreciation program
- CIP ADJUSTMENT Expensed or Amortized Adjustment User Exit
- CIP RETIREMENT Gain/loss program
- DEPRECIATION Depreciation program (Retroactive transactions andexpensed depreciation adjustments)
- RETIREMENT Gain/loss program
- RECLASS Reclassification user exit
- TRANSFER Transfers form
- TAX Reserve Adjustments form
- REVALUATION Mass revaluation program
The ADJUSTMENT_TYPE column tells you which type of account Oracle Assets adjusts. DEBIT_CREDIT_FLAG is DR if the amount is a debit and CR if the amount is a credit. ADJUSTMENT_AMOUNT is the amount debited or credited to the account. ANNUALIZED_ADJUSTMENT is the adjustment amount for a period times the number of periods in a fiscal year. The depreciation program uses it to calculate the depreciation adjustment for an asset when you perform multiple retroactive transactions on the asset. Oracle Assets calculates ADJUSTMENT_PER_PERIOD by dividing the ADJUSTMENT_AMOUNT for a retroactive transaction by the numberof periods between the period you entered the transaction and the period that it was effective. For current period transactions, this columnis zero. PERIOD_COUNTER_CREATED IS the period that you entered the adjustment into Oracle Assets. PERIOD_COUNTER_ADJUSTED is the period to which the adjustment applies. It is the same as PERIOD_COUNTER_CREATED, unless you enter a reserve adjustment, in which case PERIOD_COUNTER_ADJUSTED is the last period of the fiscal year to which the adjustment applies. CODE_COMBINATION_ID indicates the Accounting Flexfield combination Oracle Assets debits or credits for all transactions except reclassifications and intercompany transfers. This CODE_COMBINATION_ID is generated using the Account Generator, and the posting program does not perform any further processing.
FA_BOOKS contains the information that Oracle Assets needs to calculate depreciation. When you initially add an asset, Oracle Assets inserts one row into the table. This becomes the ”active” row for the asset. Whenever you use the Depreciation Books form to change the asset’s depreciation information, or if you retire or reinstate it, Oracle Assets inserts another row into the table, which then becomes the new ”active” row, and marks the previous row as obsolete.
At any point in time, there is only one ”active” row in the table for an asset in any given depreciation book. Generally, Oracle Assets uses the active row, but if you run a report for a prior accounting period, Oracle Assets selects the row that was active during that period. You can identify the active row for anasset in a book because it is the only one whose DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_OUT are NULL. When Oracle Assets terminates a row, the DATE_INEFFECTIVE and TRANSACTION_HEADER_OUT are set to the DATE_EFFECTIVE and TRANSACTION_HEADER_IN of the new row, respectively. This means that you can easily identify rows affected by the same transaction because they have the same DATE_EFFECTIVE / DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_IN / TRANSACTION_HEADER_ID_OUT pairs.When Oracle Assets creates the new row, the value used for the TRANSACTION_HEADER_ID_IN column is the same as the TRANSACTION_HEADER_ID in the row inserted into FA_TRANSACTION_HEADERS, and the DATE_EFFECTIVE is the system date. When you retire an asset, Oracle Assets inserts a new row to reduce the COST by the amount retired. When you reinstate an asset, Oracle Assets inserts a new row to increase the COST by the COST_RETIRED in the corresponding row in FA_RETIREMENTS.RATE_ADJUSTMENT_FACTOR is originally 1. It is used to spread depreciation over the remaining life of an asset after an amortization or revaluation. If you perform a revaluation or an amortized adjustment, Oracle Assets resets the Rate Adjustment Factor to prorate the remaining recoverable net book value over the remaining life. This fraction is calculated as [Recoverable Cost – what Depreciation Reserve would be]/Recoverable Cost. The depreciation program uses this value to adjust the depreciation rate for an asset.
FA_CATEGORIES_B stores information about your asset categories. This table provides default information when you add an asset. The depreciation program does not use this information to calculate depreciation.The Asset Categories form inserts one row in this table for each asset category you define. The Application Object Library table
FND_ID_FLEX_SEGMENTS stores information about which column in this table is used for each segment.
FA_DEPRN_DETAIL contains the depreciation amounts that the depreciation program charges to the depreciation expense account in each distribution line.
Oracle Assets uses this information to create depreciation expense journal entries for your general ledger.The depreciation program inserts one row per distribution line for an asset each time you run depreciation.
For example, if you assign an asset to two different cost centers, the depreciation program inserts two rows in this table for the asset. DEPRN_AMOUNT is the amount of depreciation expense calculated forthis distribution line.YTD_DEPRN is the year–to–date depreciation allocated to thisdistribution line.When you add an asset, Oracle Assets inserts a row into this table for the period before the current period. This row has the asset cost in the ADDITION_COST_TO_CLEAR column and a DEPRN_SOURCE_CODE of ’B’. This column is used for reporting on new assets. When you run depreciation, Oracle Assets transfers the cost to the COST column in the current period row, this row has a DEPRN_SOURCE_CODE of ’D’.
=================
1- FA_DEPRN_PERIODS
2- FA_DEPRN_SUMMARY
3- FA_ADDITIONS_B
4- FA_BOOKS
5- FA_CATEGORIES_B
6- FA_DEPRN_DETAIL
FA_DEPRN_PERIODS contains information about your depreciation periods. Oracle Assets uses this table to determine when each period in FA_CALENDARS was open for a depreciation book. PERIOD_OPEN_DATE and PERIOD_CLOSE_DATE are the dates when you opened and closed each book’s depreciation period. Each time you run the depreciation program, it closes the current period by setting PERIOD_CLOSE_DATE to the system date. It also opens the next period by inserting a new row into this table in which PERIOD_CLOSE_DATE is NULL and PERIOD_OPEN_DATE equals the PERIOD_CLOSE_DATE of the old row. CALENDAR_PERIOD_OPEN_DATE and CALENDAR_PERIOD_CLOSE_DATE correspond to your calendar as defined by the START_DATE and END_DATE columns in FA_CALENDAR_PERIODS.
FA_DEPRN_SUMMARY contains depreciation information for your assets. Each time you run the depreciation program, it inserts one row into thistable for each asset. PERIOD_COUNTER is the period for which you ran the depreciation program. DEPRN_AMOUNT is the depreciation expense for an asset in a depreciation period. It is the sum of DEPRN_AMOUNT in all the rows of FA_DEPRN_DETAIL for the asset and period. YTD_DEPRN is the accumulated depreciation of an asset for the current fiscal year as of the end of this period. DEPRN_RESERVE is the total accumulated depreciation for this asset. DEPRN_SOURCE_CODE tells you what program created the row BOOKS Created by the Depreciation Books form, Quick Additions form, or the post mass additions program when you enter a new asset. DEPRN Created by the depreciation program when you run depreciation. ADJUSTED_COST is the depreciable basis the depreciation program uses to calculate depreciation for an asset in a depreciation period. This value is the same as the asset’s recoverable cost, except for assets that use a diminishing value depreciation method, assets to which you have made an amortized adjustment, and assets you have revalued.
For assets that use a diminishing value method, the ADJUSTED_COST is the beginning of year net book value, which the depreciation program updates at the start of each fiscal year. When you perform an amortized adjustment on an asset or revalue it, the ADJUSTED_COST becomes the asset’s net book value at the time of the adjustment or revaluation. BONUS_RATE is the bonus rate that Oracle Assets adds to the adjusted rate to give you the flat rate for the fiscal year. The depreciation program uses this rate to calculate depreciation for an asset. This only applies to assets that use both a flat–rate depreciation method and bonus depreciation.
FA_ADDITIONS_B contains descriptive information to help you identify your assets. Oracle Assets does not use this table to calculate depreciation.When you add an asset, Oracle Assets inserts a row into this table and into FA_ASSET_HISTORY. When you change the asset information stored in this table, Oracle Assets updates it in this table. It also creates a new row in FA_ASSET_HISTORY. When you perform a unit retirement, Oracle Assets reduces the CURRENT_UNITS by the units retired. UNIT_ADJUSTMENT_FLAG is set to YES by the Additions form if you change the number of units for an asset. The Transfers form resets it to NO after you reassign the remaining units. FA_ADJUSTMENTS stores information that Oracle Assets needs to create journal entries for transactions. The posting program creates journal entries for regular depreciation expense from information in FA_DEPRN_DETAIL. Oracle Assets inserts a row in this table for the debit and credit sides of a financial transaction. All the rows for the same transaction have the same value in the TRANSACTION_HEADER_ID column. The SOURCE_TYPE_CODE column tells you which program created the adjustment:
- ADDITION Depreciation program
- ADJUSTMENT Expensed or Amortized Adjustment User Exit
- CIP ADDITION Depreciation program
- CIP ADJUSTMENT Expensed or Amortized Adjustment User Exit
- CIP RETIREMENT Gain/loss program
- DEPRECIATION Depreciation program (Retroactive transactions andexpensed depreciation adjustments)
- RETIREMENT Gain/loss program
- RECLASS Reclassification user exit
- TRANSFER Transfers form
- TAX Reserve Adjustments form
- REVALUATION Mass revaluation program
The ADJUSTMENT_TYPE column tells you which type of account Oracle Assets adjusts. DEBIT_CREDIT_FLAG is DR if the amount is a debit and CR if the amount is a credit. ADJUSTMENT_AMOUNT is the amount debited or credited to the account. ANNUALIZED_ADJUSTMENT is the adjustment amount for a period times the number of periods in a fiscal year. The depreciation program uses it to calculate the depreciation adjustment for an asset when you perform multiple retroactive transactions on the asset. Oracle Assets calculates ADJUSTMENT_PER_PERIOD by dividing the ADJUSTMENT_AMOUNT for a retroactive transaction by the numberof periods between the period you entered the transaction and the period that it was effective. For current period transactions, this columnis zero. PERIOD_COUNTER_CREATED IS the period that you entered the adjustment into Oracle Assets. PERIOD_COUNTER_ADJUSTED is the period to which the adjustment applies. It is the same as PERIOD_COUNTER_CREATED, unless you enter a reserve adjustment, in which case PERIOD_COUNTER_ADJUSTED is the last period of the fiscal year to which the adjustment applies. CODE_COMBINATION_ID indicates the Accounting Flexfield combination Oracle Assets debits or credits for all transactions except reclassifications and intercompany transfers. This CODE_COMBINATION_ID is generated using the Account Generator, and the posting program does not perform any further processing.
FA_BOOKS contains the information that Oracle Assets needs to calculate depreciation. When you initially add an asset, Oracle Assets inserts one row into the table. This becomes the ”active” row for the asset. Whenever you use the Depreciation Books form to change the asset’s depreciation information, or if you retire or reinstate it, Oracle Assets inserts another row into the table, which then becomes the new ”active” row, and marks the previous row as obsolete.
At any point in time, there is only one ”active” row in the table for an asset in any given depreciation book. Generally, Oracle Assets uses the active row, but if you run a report for a prior accounting period, Oracle Assets selects the row that was active during that period. You can identify the active row for anasset in a book because it is the only one whose DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_OUT are NULL. When Oracle Assets terminates a row, the DATE_INEFFECTIVE and TRANSACTION_HEADER_OUT are set to the DATE_EFFECTIVE and TRANSACTION_HEADER_IN of the new row, respectively. This means that you can easily identify rows affected by the same transaction because they have the same DATE_EFFECTIVE / DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_IN / TRANSACTION_HEADER_ID_OUT pairs.When Oracle Assets creates the new row, the value used for the TRANSACTION_HEADER_ID_IN column is the same as the TRANSACTION_HEADER_ID in the row inserted into FA_TRANSACTION_HEADERS, and the DATE_EFFECTIVE is the system date. When you retire an asset, Oracle Assets inserts a new row to reduce the COST by the amount retired. When you reinstate an asset, Oracle Assets inserts a new row to increase the COST by the COST_RETIRED in the corresponding row in FA_RETIREMENTS.RATE_ADJUSTMENT_FACTOR is originally 1. It is used to spread depreciation over the remaining life of an asset after an amortization or revaluation. If you perform a revaluation or an amortized adjustment, Oracle Assets resets the Rate Adjustment Factor to prorate the remaining recoverable net book value over the remaining life. This fraction is calculated as [Recoverable Cost – what Depreciation Reserve would be]/Recoverable Cost. The depreciation program uses this value to adjust the depreciation rate for an asset.
FA_CATEGORIES_B stores information about your asset categories. This table provides default information when you add an asset. The depreciation program does not use this information to calculate depreciation.The Asset Categories form inserts one row in this table for each asset category you define. The Application Object Library table
FND_ID_FLEX_SEGMENTS stores information about which column in this table is used for each segment.
FA_DEPRN_DETAIL contains the depreciation amounts that the depreciation program charges to the depreciation expense account in each distribution line.
Oracle Assets uses this information to create depreciation expense journal entries for your general ledger.The depreciation program inserts one row per distribution line for an asset each time you run depreciation.
For example, if you assign an asset to two different cost centers, the depreciation program inserts two rows in this table for the asset. DEPRN_AMOUNT is the amount of depreciation expense calculated forthis distribution line.YTD_DEPRN is the year–to–date depreciation allocated to thisdistribution line.When you add an asset, Oracle Assets inserts a row into this table for the period before the current period. This row has the asset cost in the ADDITION_COST_TO_CLEAR column and a DEPRN_SOURCE_CODE of ’B’. This column is used for reporting on new assets. When you run depreciation, Oracle Assets transfers the cost to the COST column in the current period row, this row has a DEPRN_SOURCE_CODE of ’D’.
ASSET CATEGORIES
SELECT DISTINCT a.segment1||'.'||a.segment2 CATEGORY,a.segment1 MAJOR_CATEGORY
, a.segment2 MINOR_CATEGORY
, gl1.segment1||'.'||gl1.SEGMENT2||'.'||gl1.SEGMENT3||'.'||gl1.SEGMENT4||'.'||gl1.SEGMENT5 ASSET_COST
, gl2.segment1||'.'||gl2.SEGMENT2||'.'||gl2.SEGMENT3||'.'||gl2.SEGMENT4||'.'||gl2.SEGMENT5 ASSET_COST_CLEARING
, c.DEPRN_EXPENSE_ACCT
, gl3.segment1||'.'||gl3.SEGMENT2||'.'||gl3.SEGMENT3||'.'||gl3.SEGMENT4||'.'||gl3.SEGMENT5 DEPRN_RESERVE_ACCOUNT
, deprn_method
, life_in_months
, (life_in_months/12) lIFE
, prorate_convention_code
FROM fa_categories a
, FA_CATEGORY_BOOK_DEFAULTS b
, fa_category_books c
, gl_code_combinations gl1
, gl_code_combinations gl2
, gl_code_combinations gl3
WHERE a.category_id = b.category_id
AND c.category_id = b.category_id
AND c.category_id = a.category_id
AND a.ENABLED_FLAG = 'Y'
AND c.ASSET_COST_ACCOUNT_CCID = gl1.CODE_COMBINATION_ID
AND c.ASSET_CLEARING_ACCOUNT_CCID = gl2.CODE_COMBINATION_ID
AND c.RESERVE_ACCOUNT_CCID = gl3.CODE_COMBINATION_ID
--AND c.WIP_COST_ACCOUNT_CCID = gl4.CODE_COMBINATION_ID
--AND c.WIP_CLEARING_ACCOUNT_CCID = gl5.CODE_COMBINATION_ID
AND b.book_type_code = c.book_type_code
AND c.book_type_code = 'CORP BOOK'
FA YTD Depreciation
FA For getting YTD Depreciation..etc...
--CREATE OR REPLACE VIEW MVL_FA_LISTING_V
(BOOK_TYPE_CODE, ASSET_NUMBER, ASSET_ID, TAG_NUMBER, DATE_PLACED_IN_SERVICE,
DESCRIPTION, ASSET_CATEGORY, ASSET_CATEGORY1, ASSET_COST, ORIGINAL_ASSET_COST,
ASSET_LIFE, ACCUM_DEPRECIATION, YTD_DEPRECIATION, DEP_THIS_RUN, DEPARTMENT_NO,
CUSTODIAN, EMPLOYEE_NUMBER, PO_NUMBER, INVOICE_NUMBER, VENDOR_NUMBER,
VENDOR_NAME, SERIAL_NUMBER, LOCATION_FLEXFIELD, TAX_MAJOR_CATEGORY, TAX_MINOR_CATEGORY,
RETIREMENT_TYPE, ASSET_KEY, PERIOD_NAME, ACQUISITION_DATE, MANUFACTURER_NAME,
RETIREMENT_PENDING_FLAG)
AS
SELECT fbv.book_type_code
,fab.asset_number,fab.asset_id
,fab.tag_number
,fbv.date_placed_in_service
,fab.description
,fcb.segment1||'.'||fcb.segment2 asset_category
,fcb.segment1||'.'||fcb.segment2 asset_category1
,fbv.cost asset_cost
,fbv.original_cost original_asset_cost
,fbv.life_in_months asset_life
,mvl_discoverer_fin_support.get_depreciation_dtls(fab.asset_id
,fbv.book_type_code
,fdh.distribution_id
,fdp.period_counter
,'ACCUM') accum_depreciation
,mvl_discoverer_fin_support.get_depreciation_dtls(fab.asset_id
,fbv.book_type_code
,fdh.distribution_id
,fdp.period_counter
,'YTD') ytd_depreciation
,mvl_discoverer_fin_support.get_depreciation_dtls(fab.asset_id
,fbv.book_type_code
,fdh.distribution_id
,fdp.period_counter
,'RUN') dep_this_run
,gcc.segment2 department_no
,(SELECT ppx.full_name FROM per_people_x ppx WHERE ppx.person_id = fdh.assigned_to AND ROWNUM = 1) custodian
,(SELECT ppx.employee_number FROM per_people_x ppx WHERE ppx.person_id = fdh.assigned_to AND ROWNUM = 1) employee_number
,(SELECT po_number FROM fa_invoice_details_v WHERE asset_id = fbv.asset_id AND ROWNUM = 1) po_number
,(SELECT invoice_number FROM fa_invoice_details_v WHERE asset_id = fbv.asset_id AND ROWNUM = 1) invoice_number
,(SELECT vendor_number FROM fa_invoice_details_v WHERE asset_id = fbv.asset_id AND ROWNUM = 1) vendor_number
,(SELECT vendor_name FROM fa_invoice_details_v WHERE asset_id = fbv.asset_id AND ROWNUM = 1) vendor_name
,fab.serial_number
,fl.segment3||'.'||fl.segment4 location_flexfield
,fab.attribute1 tax_major_category
,fab.attribute2 tax_minor_category
,(SELECT retirement_type_code FROM fa_retirements WHERE retirement_id = fdh.retirement_id AND ROWNUM = 1) retirement_type
,(SELECT segment1||'.'||segment2 FROM fa_asset_keywords WHERE code_combination_id = fab.asset_key_ccid AND ROWNUM = 1) asset_key
,fdp.period_name
,fab.attribute3 acquisition_date
,fab.manufacturer_name
,fbv.retirement_pending_flag
FROM apps.fa_additions_v fab
,apps.fa_books_v fbv
,apps.fa_categories_b fcb
,apps.fa_deprn_periods fdp
,apps.fa_distribution_history fdh
,apps.gl_code_combinations gcc
,apps.fa_locations fl
WHERE 1=1
AND fab.asset_id = fbv.asset_id
AND fcb.category_id = fab.asset_category_id
AND fbv.transaction_header_id_out IS NULL
AND fdp.book_type_code = fbv.book_type_code
AND fdh.asset_id = fbv.asset_id
AND fdh.code_combination_id = gcc.code_combination_id
AND fdh.location_id=fl.location_id
AND fbv.transaction_header_id_out IS NULL
AND fdh.transaction_header_id_out IS NULL
/
SELECT fnd_id_flex_segments.application_column_name,
fnd_id_flex_segments.segment_name, fnd_id_flex_segments.segment_num,
fnd_flex_values.flex_value_set_id,
fnd_flex_values.flex_value AS SEGMENT,
fnd_flex_values_tl.description, fnd_id_flex_segments.application_id, fnd_flex_values.PARENT_FLEX_VALUE_LOW as parent
FROM applsys.fnd_flex_values fnd_flex_values,
applsys.fnd_flex_values_tl fnd_flex_values_tl,
applsys.fnd_id_flex_segments fnd_id_flex_segments
WHERE fnd_flex_values.flex_value_id = fnd_flex_values_tl.flex_value_id
AND fnd_flex_values.flex_value_set_id =
fnd_id_flex_segments.flex_value_set_id
AND fnd_id_flex_segments.flex_value_set_id = 1008035
-- AND fnd_flex_values.flex_value <> 'T'
AND fnd_id_flex_segments.application_id = '140'
AND fnd_id_flex_segments.segment_num = 3
/
SELECT fa_additions.asset_id, disc_gl_set_of_books.set_of_books_id,
disc_gl_set_of_books.description AS set_of_books,
disc_gl_set_of_books.set_of_book_currency,
fa_additions.asset_number, fa_additions.tag_number,
fa_additions.description, fa_additions.manufacturer_name,
fa_additions.serial_number, fa_additions.model_number,
fa_categories_b.segment1, fa_categories_b.segment2,
fa_categories_b.segment3, fa_books.book_type_code,
ROUND ( fa_books.COST
* fa_distribution_history.units_assigned
/ fa_additions.current_units,
0
) COST,
fa_books.date_effective, fa_books.date_ineffective,
fa_books.date_placed_in_service, fa_books.deprn_start_date,
fa_books.original_cost, fa_additions.current_units,
fa_distribution_history.units_assigned, fa_books.life_in_months,
fa_employees.employee_number, fa_employees.NAME employee_name,
fa_locations.segment1 "STATE", fa_locations.segment2 "CITY",
fa_locations.segment3 "SITE", fa_locations.segment4 "LOCATOR",
fa_category_books.asset_cost_acct "ASSET_ACCOUNT_ID",
segment2.description AS "ASSET_ACCOUNT",
fa_book_controls.book_class, disc_ccid_dsc_mv.account_type,
disc_ccid_dsc_mv.code_combination_id, disc_ccid_dsc_mv.gl_seg1,
disc_ccid_dsc_mv.gl_seg2, disc_ccid_dsc_mv.gl_seg3,
disc_ccid_dsc_mv.gl_seg4, disc_ccid_dsc_mv.gl_seg5,
disc_ccid_dsc_mv.gl_seg6, disc_ccid_dsc_mv.gl_seg7,
disc_ccid_dsc_mv.gl_seg8, disc_ccid_dsc_mv.gl_seg9,
disc_ccid_dsc_mv.gl_seg10, disc_ccid_dsc_mv.gl_seg11,
disc_ccid_dsc_mv.gl_name_seg1, disc_ccid_dsc_mv.gl_name_seg2,
disc_ccid_dsc_mv.gl_name_seg3, disc_ccid_dsc_mv.gl_name_seg4,
disc_ccid_dsc_mv.gl_name_seg5, disc_ccid_dsc_mv.gl_name_seg6,
disc_ccid_dsc_mv.gl_name_seg7, disc_ccid_dsc_mv.gl_name_seg8,
disc_ccid_dsc_mv.gl_name_seg9, disc_ccid_dsc_mv.gl_name_seg10,
disc_ccid_dsc_mv.gl_name_seg11,
fa_books.date_placed_in_service "DATE_IN",
--TO_DATE(FA_DISTRIBUTION_HISTORY.DATE_INEFFECTIVE,'DD-MON-RRRR') "DATE_INEFFECTIVE",
--FA_BOOKS.DATE_INEFFECTIVE
NULL "DATE_IN_MONTH", fa_deprn_summary.deprn_amount,
fa_deprn_summary.ytd_deprn, fa_deprn_summary.deprn_reserve,
fa_deprn_summary.deprn_source_code,
fa_deprn_summary.addition_cost_to_clear adjusted_cost,
fa_deprn_periods.period_name
-- disc_fa_invoice_details.vendor_name,
-- disc_fa_invoice_details.invoice_number,
-- disc_fa_invoice_details.invoice_date,
-- disc_fa_invoice_details.fixed_assets_cost AS fa_cost_by_invoice
FROM apps.fa_additions fa_additions,
fa.fa_book_controls fa_book_controls,
fa.fa_books fa_books,
fa.fa_categories_b fa_categories_b,
fa.fa_category_books fa_category_books,
fa.fa_distribution_history fa_distribution_history,
gl.gl_code_combinations gl_code_combinations,
apps.fa_employees fa_employees,
fa.fa_locations fa_locations,
apps.disc_ccid_dsc_mv disc_ccid_dsc_mv,
apps.disc_segment2 segment2,
apps.disc_gl_set_of_books disc_gl_set_of_books,
-- disc_gl_month in_month,
fa.fa_deprn_detail fa_deprn_summary,
fa.fa_deprn_periods fa_deprn_periods
-- disc_fa_invoice_details disc_fa_invoice_details
WHERE fa_books.book_type_code = fa_book_controls.book_type_code
AND fa_books.asset_id = fa_additions.asset_id
AND fa_books.date_ineffective IS NULL
AND fa_distribution_history.book_type_code = fa_books.book_type_code
AND fa_distribution_history.asset_id = fa_additions.asset_id
AND fa_distribution_history.date_ineffective IS NULL
AND fa_categories_b.category_id = fa_additions.asset_category_id
AND fa_category_books.book_type_code =
fa_distribution_history.book_type_code
AND fa_category_books.category_id = fa_additions.asset_category_id
AND gl_code_combinations.code_combination_id =
fa_distribution_history.code_combination_id
AND fa_employees.employee_id(+) = fa_distribution_history.assigned_to
AND fa_locations.location_id = fa_distribution_history.location_id
AND gl_code_combinations.code_combination_id =
disc_ccid_dsc_mv.code_combination_id
AND segment2.SEGMENT = fa_category_books.asset_cost_acct
AND disc_gl_set_of_books.set_of_books_id =
fa_book_controls.set_of_books_id
-- AND fa_books.date_placed_in_service BETWEEN in_month.start_date AND in_month.end_date
AND fa_deprn_summary.asset_id = fa_distribution_history.asset_id
AND ( fa_deprn_periods.period_counter =
fa_deprn_summary.period_counter
AND fa_deprn_periods.book_type_code =
fa_deprn_summary.book_type_code
)
AND fa_deprn_summary.distribution_id =
fa_distribution_history.distribution_id
-- AND fa_books.asset_id = disc_fa_invoice_details.asset_id(+)
-- AND fa_deprn_summary.deprn_source_code = 'D'
--and fa_additions.asset_id = '10000767';
/
SELECT DISTINCT a.segment1||'.'||a.segment2 CATEGORY,a.segment1 MAJOR_CATEGORY
, a.segment2 MINOR_CATEGORY
, gl1.segment1||'.'||gl1.SEGMENT2||'.'||gl1.SEGMENT3||'.'||gl1.SEGMENT4||'.'||gl1.SEGMENT5 ASSET_COST
, gl2.segment1||'.'||gl2.SEGMENT2||'.'||gl2.SEGMENT3||'.'||gl2.SEGMENT4||'.'||gl2.SEGMENT5 ASSET_COST_CLEARING
, c.DEPRN_EXPENSE_ACCT
, gl3.segment1||'.'||gl3.SEGMENT2||'.'||gl3.SEGMENT3||'.'||gl3.SEGMENT4||'.'||gl3.SEGMENT5 DEPRN_RESERVE_ACCOUNT
, deprn_method
, life_in_months
, (life_in_months/12) lIFE
, prorate_convention_code
FROM fa_categories a
, FA_CATEGORY_BOOK_DEFAULTS b
, fa_category_books c
, gl_code_combinations gl1
, gl_code_combinations gl2
, gl_code_combinations gl3
WHERE a.category_id = b.category_id
AND c.category_id = b.category_id
AND c.category_id = a.category_id
AND a.ENABLED_FLAG = 'Y'
AND c.ASSET_COST_ACCOUNT_CCID = gl1.CODE_COMBINATION_ID
AND c.ASSET_CLEARING_ACCOUNT_CCID = gl2.CODE_COMBINATION_ID
AND c.RESERVE_ACCOUNT_CCID = gl3.CODE_COMBINATION_ID
--AND c.WIP_COST_ACCOUNT_CCID = gl4.CODE_COMBINATION_ID
--AND c.WIP_CLEARING_ACCOUNT_CCID = gl5.CODE_COMBINATION_ID
AND b.book_type_code = c.book_type_code
AND c.book_type_code = 'CORP BOOK'
FA YTD Depreciation
FA For getting YTD Depreciation..etc...
--CREATE OR REPLACE VIEW MVL_FA_LISTING_V
(BOOK_TYPE_CODE, ASSET_NUMBER, ASSET_ID, TAG_NUMBER, DATE_PLACED_IN_SERVICE,
DESCRIPTION, ASSET_CATEGORY, ASSET_CATEGORY1, ASSET_COST, ORIGINAL_ASSET_COST,
ASSET_LIFE, ACCUM_DEPRECIATION, YTD_DEPRECIATION, DEP_THIS_RUN, DEPARTMENT_NO,
CUSTODIAN, EMPLOYEE_NUMBER, PO_NUMBER, INVOICE_NUMBER, VENDOR_NUMBER,
VENDOR_NAME, SERIAL_NUMBER, LOCATION_FLEXFIELD, TAX_MAJOR_CATEGORY, TAX_MINOR_CATEGORY,
RETIREMENT_TYPE, ASSET_KEY, PERIOD_NAME, ACQUISITION_DATE, MANUFACTURER_NAME,
RETIREMENT_PENDING_FLAG)
AS
SELECT fbv.book_type_code
,fab.asset_number,fab.asset_id
,fab.tag_number
,fbv.date_placed_in_service
,fab.description
,fcb.segment1||'.'||fcb.segment2 asset_category
,fcb.segment1||'.'||fcb.segment2 asset_category1
,fbv.cost asset_cost
,fbv.original_cost original_asset_cost
,fbv.life_in_months asset_life
,mvl_discoverer_fin_support.get_depreciation_dtls(fab.asset_id
,fbv.book_type_code
,fdh.distribution_id
,fdp.period_counter
,'ACCUM') accum_depreciation
,mvl_discoverer_fin_support.get_depreciation_dtls(fab.asset_id
,fbv.book_type_code
,fdh.distribution_id
,fdp.period_counter
,'YTD') ytd_depreciation
,mvl_discoverer_fin_support.get_depreciation_dtls(fab.asset_id
,fbv.book_type_code
,fdh.distribution_id
,fdp.period_counter
,'RUN') dep_this_run
,gcc.segment2 department_no
,(SELECT ppx.full_name FROM per_people_x ppx WHERE ppx.person_id = fdh.assigned_to AND ROWNUM = 1) custodian
,(SELECT ppx.employee_number FROM per_people_x ppx WHERE ppx.person_id = fdh.assigned_to AND ROWNUM = 1) employee_number
,(SELECT po_number FROM fa_invoice_details_v WHERE asset_id = fbv.asset_id AND ROWNUM = 1) po_number
,(SELECT invoice_number FROM fa_invoice_details_v WHERE asset_id = fbv.asset_id AND ROWNUM = 1) invoice_number
,(SELECT vendor_number FROM fa_invoice_details_v WHERE asset_id = fbv.asset_id AND ROWNUM = 1) vendor_number
,(SELECT vendor_name FROM fa_invoice_details_v WHERE asset_id = fbv.asset_id AND ROWNUM = 1) vendor_name
,fab.serial_number
,fl.segment3||'.'||fl.segment4 location_flexfield
,fab.attribute1 tax_major_category
,fab.attribute2 tax_minor_category
,(SELECT retirement_type_code FROM fa_retirements WHERE retirement_id = fdh.retirement_id AND ROWNUM = 1) retirement_type
,(SELECT segment1||'.'||segment2 FROM fa_asset_keywords WHERE code_combination_id = fab.asset_key_ccid AND ROWNUM = 1) asset_key
,fdp.period_name
,fab.attribute3 acquisition_date
,fab.manufacturer_name
,fbv.retirement_pending_flag
FROM apps.fa_additions_v fab
,apps.fa_books_v fbv
,apps.fa_categories_b fcb
,apps.fa_deprn_periods fdp
,apps.fa_distribution_history fdh
,apps.gl_code_combinations gcc
,apps.fa_locations fl
WHERE 1=1
AND fab.asset_id = fbv.asset_id
AND fcb.category_id = fab.asset_category_id
AND fbv.transaction_header_id_out IS NULL
AND fdp.book_type_code = fbv.book_type_code
AND fdh.asset_id = fbv.asset_id
AND fdh.code_combination_id = gcc.code_combination_id
AND fdh.location_id=fl.location_id
AND fbv.transaction_header_id_out IS NULL
AND fdh.transaction_header_id_out IS NULL
/
SELECT fnd_id_flex_segments.application_column_name,
fnd_id_flex_segments.segment_name, fnd_id_flex_segments.segment_num,
fnd_flex_values.flex_value_set_id,
fnd_flex_values.flex_value AS SEGMENT,
fnd_flex_values_tl.description, fnd_id_flex_segments.application_id, fnd_flex_values.PARENT_FLEX_VALUE_LOW as parent
FROM applsys.fnd_flex_values fnd_flex_values,
applsys.fnd_flex_values_tl fnd_flex_values_tl,
applsys.fnd_id_flex_segments fnd_id_flex_segments
WHERE fnd_flex_values.flex_value_id = fnd_flex_values_tl.flex_value_id
AND fnd_flex_values.flex_value_set_id =
fnd_id_flex_segments.flex_value_set_id
AND fnd_id_flex_segments.flex_value_set_id = 1008035
-- AND fnd_flex_values.flex_value <> 'T'
AND fnd_id_flex_segments.application_id = '140'
AND fnd_id_flex_segments.segment_num = 3
/
SELECT fa_additions.asset_id, disc_gl_set_of_books.set_of_books_id,
disc_gl_set_of_books.description AS set_of_books,
disc_gl_set_of_books.set_of_book_currency,
fa_additions.asset_number, fa_additions.tag_number,
fa_additions.description, fa_additions.manufacturer_name,
fa_additions.serial_number, fa_additions.model_number,
fa_categories_b.segment1, fa_categories_b.segment2,
fa_categories_b.segment3, fa_books.book_type_code,
ROUND ( fa_books.COST
* fa_distribution_history.units_assigned
/ fa_additions.current_units,
0
) COST,
fa_books.date_effective, fa_books.date_ineffective,
fa_books.date_placed_in_service, fa_books.deprn_start_date,
fa_books.original_cost, fa_additions.current_units,
fa_distribution_history.units_assigned, fa_books.life_in_months,
fa_employees.employee_number, fa_employees.NAME employee_name,
fa_locations.segment1 "STATE", fa_locations.segment2 "CITY",
fa_locations.segment3 "SITE", fa_locations.segment4 "LOCATOR",
fa_category_books.asset_cost_acct "ASSET_ACCOUNT_ID",
segment2.description AS "ASSET_ACCOUNT",
fa_book_controls.book_class, disc_ccid_dsc_mv.account_type,
disc_ccid_dsc_mv.code_combination_id, disc_ccid_dsc_mv.gl_seg1,
disc_ccid_dsc_mv.gl_seg2, disc_ccid_dsc_mv.gl_seg3,
disc_ccid_dsc_mv.gl_seg4, disc_ccid_dsc_mv.gl_seg5,
disc_ccid_dsc_mv.gl_seg6, disc_ccid_dsc_mv.gl_seg7,
disc_ccid_dsc_mv.gl_seg8, disc_ccid_dsc_mv.gl_seg9,
disc_ccid_dsc_mv.gl_seg10, disc_ccid_dsc_mv.gl_seg11,
disc_ccid_dsc_mv.gl_name_seg1, disc_ccid_dsc_mv.gl_name_seg2,
disc_ccid_dsc_mv.gl_name_seg3, disc_ccid_dsc_mv.gl_name_seg4,
disc_ccid_dsc_mv.gl_name_seg5, disc_ccid_dsc_mv.gl_name_seg6,
disc_ccid_dsc_mv.gl_name_seg7, disc_ccid_dsc_mv.gl_name_seg8,
disc_ccid_dsc_mv.gl_name_seg9, disc_ccid_dsc_mv.gl_name_seg10,
disc_ccid_dsc_mv.gl_name_seg11,
fa_books.date_placed_in_service "DATE_IN",
--TO_DATE(FA_DISTRIBUTION_HISTORY.DATE_INEFFECTIVE,'DD-MON-RRRR') "DATE_INEFFECTIVE",
--FA_BOOKS.DATE_INEFFECTIVE
NULL "DATE_IN_MONTH", fa_deprn_summary.deprn_amount,
fa_deprn_summary.ytd_deprn, fa_deprn_summary.deprn_reserve,
fa_deprn_summary.deprn_source_code,
fa_deprn_summary.addition_cost_to_clear adjusted_cost,
fa_deprn_periods.period_name
-- disc_fa_invoice_details.vendor_name,
-- disc_fa_invoice_details.invoice_number,
-- disc_fa_invoice_details.invoice_date,
-- disc_fa_invoice_details.fixed_assets_cost AS fa_cost_by_invoice
FROM apps.fa_additions fa_additions,
fa.fa_book_controls fa_book_controls,
fa.fa_books fa_books,
fa.fa_categories_b fa_categories_b,
fa.fa_category_books fa_category_books,
fa.fa_distribution_history fa_distribution_history,
gl.gl_code_combinations gl_code_combinations,
apps.fa_employees fa_employees,
fa.fa_locations fa_locations,
apps.disc_ccid_dsc_mv disc_ccid_dsc_mv,
apps.disc_segment2 segment2,
apps.disc_gl_set_of_books disc_gl_set_of_books,
-- disc_gl_month in_month,
fa.fa_deprn_detail fa_deprn_summary,
fa.fa_deprn_periods fa_deprn_periods
-- disc_fa_invoice_details disc_fa_invoice_details
WHERE fa_books.book_type_code = fa_book_controls.book_type_code
AND fa_books.asset_id = fa_additions.asset_id
AND fa_books.date_ineffective IS NULL
AND fa_distribution_history.book_type_code = fa_books.book_type_code
AND fa_distribution_history.asset_id = fa_additions.asset_id
AND fa_distribution_history.date_ineffective IS NULL
AND fa_categories_b.category_id = fa_additions.asset_category_id
AND fa_category_books.book_type_code =
fa_distribution_history.book_type_code
AND fa_category_books.category_id = fa_additions.asset_category_id
AND gl_code_combinations.code_combination_id =
fa_distribution_history.code_combination_id
AND fa_employees.employee_id(+) = fa_distribution_history.assigned_to
AND fa_locations.location_id = fa_distribution_history.location_id
AND gl_code_combinations.code_combination_id =
disc_ccid_dsc_mv.code_combination_id
AND segment2.SEGMENT = fa_category_books.asset_cost_acct
AND disc_gl_set_of_books.set_of_books_id =
fa_book_controls.set_of_books_id
-- AND fa_books.date_placed_in_service BETWEEN in_month.start_date AND in_month.end_date
AND fa_deprn_summary.asset_id = fa_distribution_history.asset_id
AND ( fa_deprn_periods.period_counter =
fa_deprn_summary.period_counter
AND fa_deprn_periods.book_type_code =
fa_deprn_summary.book_type_code
)
AND fa_deprn_summary.distribution_id =
fa_distribution_history.distribution_id
-- AND fa_books.asset_id = disc_fa_invoice_details.asset_id(+)
-- AND fa_deprn_summary.deprn_source_code = 'D'
--and fa_additions.asset_id = '10000767';
/
98 comments:
IN above query what is "mvl_discoverer_fin_support.get_depreciation_dtls" do ???
This is cool.. Is there any script that pulls out a report for “the months of depreciation left”?
Please give me steps to migrate Asset Master and category. Is there any API or interface program available? Iam new to Fixed Assets.
Thanks.
Today many diseases can be treated by a very fine, hair thin, disposable
acupuncture needles which are made up of either stainless steel or silver or gold or copper.
Remember that you are usually limited to a number of sessions
so you might want to consider paying out of your own pocket.
Also, be sure to have both the training and experience, which
are needed before you even think of applying.
Also visit my weblog bloghi.com
After getting more than 10000 visitors/day to my website I thought your prasanthapps.blogspot.com website also need unstoppable flow of traffic...
Use this BRAND NEW software and get all the traffic for your website you will ever need ...
= = > > http://get-massive-autopilot-traffic.com
In testing phase it generated 867,981 visitors and $540,340.
Then another $86,299.13 in 90 days to be exact. That's $958.88 a
day!!
And all it took was 10 minutes to set up and run.
But how does it work??
You just configure the system, click the mouse button a few
times, activate the software, copy and paste a few links and
you're done!!
Click the link BELOW as you're about to witness a software that
could be a MAJOR turning point to your success.
= = > > http://get-massive-autopilot-traffic.com
If you would like to get a great deal from this
paragraph then you have to apply these methods to your won web
site.
Look at my web blog click here to visit them
My site :: online instant payday loans
another affair that you want to do is to dating sites is that In that location are no restrictions. based on the feedback that I received you'll potential fine-tune some of these decisions. You mightiness be and low calibre Online Dating sites simply by look at them. So they are easy influenced by media stereotypes who scene your profile and block off other profiles who try to ship you distrait messages.
Singles choose the On-line dating tips to discover as we all want see what person looks care, in front messaging them. The medical prognosis of this check is identical honorable -- attracted to guys who are extroverts, and So try to suck their characteristics merely to pull the girls. Many Online dating guides notify their readers to watch out charwoman something to respond to you approximately - a talk stage. xpress dating Now I don't urge anyone see a person On-line Dating Advice for MenWith every exit day, things alteration in the dating existence.
http://go.appcope.com/1h If you're looking for comfort and protective cover, but not the least, the cost of wayfarer sunglasses is militant. For exemplar, wayfarer sunglasses sun specs have got go popular world Accession video prove interested in exploring the jobs crisis, immigration issues, and the function of Florida in the upcoming election.
http://tf3.info/10434 Says O Donnell: more... flier sunglasses 21musique Apr 27, 10:47 AMI've Never secondhand it, wear thin fashionable sunglasses in blockbusters or in some activities. furore comes in a all-inclusive variety of frames and lens of the eye, and they few models sitting with the Galaxy musical note 8.0 for Samsung's lensman. wayfarer sunglasses Hence, the controversy that the surveyor applied easy to benefit more from the fashionable feelings that the neon sunglasses talented them.
Highly energetic article, I liked that bit. There has to
be a part Two?
my web page :: fitness tips of the day
Bring your favorite magazines to the i - Phone with an i - Phone app.
But unlike their blank counterparts, custom lanyards also can proclaim a marketing or motivational message to customers and
employees. He covers gossip on celebrities, actors and musicians.
Also visit my web blog - articlesfind.com
They do not insert secret or additional advertising
in our material. For example, we often do some driving trains to encourage the
students to speak a few numbers in turn. If you cannot get over something that went wrong in your
life, remember this quote, 'Do not blame yourself for past errors.
Also visit my blog; click the following web page
It improves blood and oxygen flow to the muscles that are
recovering from the prior hard workout. Men can follow
these health and fitness tips to lose weight and get healthy
and fit. Get your heart rate up with a quick burst of fast movement.
Here is my webpage ... www.oresco.org/oxwall/link/9786
The value of grants and scholarships in other words, we're always decalsing. These wall Stickerss, these are being widely used as a rifle. This will decals encourage them to read without help. Types of decals PrintingScreen printing: The oldest and still most common method for decalsing newspapers and books was steel engraving. S stickers run of the house and out.
stickers Copyright c 2011 Joe MaldonadoFoil stickers can be made into a removable wall decals which suit perfectly what your child wants.
First off I want to say wonderful blog! I had a quick question that I'd like to ask if you do not mind. I was interested to know how you center yourself and clear your mind prior to writing. I have had a tough time clearing my thoughts in getting my thoughts out there. I do take pleasure in writing however it just seems like the first 10 to 15 minutes are generally lost just trying to figure out how to begin. Any suggestions or tips? Cheers!
Visit my blog: Best Weight Loss PRoducts
Howdy very nice blog!! Man .. Excellent .. Wonderful .. I'll bookmark your site and take the feeds additionally? I am satisfied to seek out numerous useful information here in the post, we need work out extra techniques on this regard, thank you for sharing. . . . . .
Feel free to surf to my page terrific black labrador golden retriever content
Do you have any video of that? I'd like to find out more details.
Here is my blog post - golden retriever yellow lab mix
But with Nexus Radio the only settings you have to worry about are where you want to save your files and what file type you want
to save it as. Next, build a list of prospects and develop a relationship
with those prospects on your list. Another radio commercial production tip to
chew on is to make sure the audio quality is excellent
on any spot your produce.
My blog radio shack plug n power wireless home security system
Nice post. I learn something new and challenging on blogs
I stumbleupon everyday. It's always useful to read through content from other writers and use a little something from their web sites.
Here is my weblog - monster beats
I have learn a few just right stuff here. Certainly price bookmarking for revisiting.
I wonder how a lot effort you set to make this type of wonderful informative web site.
Feel free to surf to my webpage: den6v4yoeh.inube.com
Greate pieces. Keep writing such kind of info on your blog.
Im really impressed by it.
Hi there, You have performed a great job.
I will certainly digg it and in my opinion recommend to my friends.
I am confident they'll be benefited from this site.
Look at my weblog; Lift serum pro
I do not even understand how I ended up right here, however I assumed this submit was once good.
I don't realize who you're but definitely you're going to a well-known blogger in case you aren't already.
Cheers!
Also visit my homepage http://testforcextremereview.net
Let's think of words that sound dirty but really aren't.
While having a passion for playing games
is important, getting a rewarding career in game design will require
students to be a cut above the competition. It is recommended that the golfers select those putters with which the
golfers feel good and works well with their gaming pattern.
my web blog: 2013 年 January 14日 於 7:23 pm
Hi there, just became aware of your blog through Google, and
found that it's truly informative. I am gonna watch out for brussels. I'll
be grateful if you continue this in future. Many people will be benefited from your writing.
Cheers!
Also visit my webpage - Xength X1
Hellο, i thіnk that i saw you visited my weblog thuѕ
i cаme to геturn the chooѕе?
.I'm trying to to find things to improve my website!I guess its adequate to make use of some of your concepts!!
Also visit my blog Disque Ssd
May I simply just say what a relief to discover someone
who genuinely knows what they're talking about on the internet. You actually realize how to bring a problem to light and make it important. More and more people have to look at this and understand this side of the story. I can't believe you aren't more popular since you surely have the gift.
Here is my page ... las vegas golf lessons
Good information. Lucky me I ran across your site by accident (stumbleupon).
I have book-marked it for later!
My page - read full report
It really is developed in this type of way that it makes the driver comfortable and in charge as if they are driving an actual
car. I am one of those night owl gamers that plays in the evening, and don't like too much lighting around me. Click it and look inside for the folder regarding keyboards.
Look into my blog post: Logitech - G110
Similar to the cue ball that is shot in pools; this game involves
coins and strikers that are essential to play carrom game.
The only downside of it in a lot of people's eyes is the fact that there is no multiplayer content. Harry Potter Hogwarts is one more entry into this new series of LEGO board games.
my blog post; ironman trailer
Hello just wanted to give you a brief heads up and let you know a few of the pictures aren't loading correctly. I'm not sure why but I think its a linking
issue. I've tried it in two different internet browsers and both show the same results.
Here is my website ... クリスチャンルブタンシューズ
Wow, fantastic blog layout! How long have you been blogging for?
you make blogging look easy. The overall look of your site is fantastic, as well as
the content!
Visit my web site Muscle Factor X REview
We stumbled over here from a different web
address and thought I should check things out. I like what I see
so now i'm following you. Look forward to exploring your web page repeatedly.
Here is my page; Mito slim
After I initially commented I appear to have clicked on the -Notify
me when new comments are added- checkbox and now whenever a comment is
added I receive 4 emails with the same comment.
Perhaps there is an easy method you are able to remove me from that service?
Cheers!
My blog post :: polo ralph lauren wholesale
After I originally left a comment I appear to have clicked the -Notify me when new comments are added- checkbox and from now on every time a comment is
added I get 4 emails with the same comment. Perhaps there
is a means you are able to remove me from that service?
Kudos!
Also visit my web page - wheelhousebikes.com
Wow, wonderful weblog structure! How lengthy have you ever been running a blog for?
you made running a blog glance easy. The entire look of
your site is great, as well as the content!
Also visit my web-site ... Gucci Ufficiale
You have to give a tube radio at least 20 to 30 minutes just to warm up and then you decide what frequency you want to be
on and load the plate and tune them up. Hardware mechanisms used in the manufacturing of a Wi - Fi
internet radio system is less complicated and the point
of ergonomics is kept in mind by the manufactures.
But mostly BBC Radios 4 and 5 because, being speech orientated,
they're more like what I do, so I can learn lots from them.
Look at my blog radio transmisores
Like any game, when we stay within the rules, we score, and when we play
outside the rules there of course is a penalty. The only downside
of it in a lot of people's eyes is the fact that there is no multiplayer content. Harry Potter Hogwarts is one more entry into this new series of LEGO board games.
My page 괌 여행의 질문 및 답변 - 괌 닛산 렌트카 예약 취소해주세요!
Great article! That is the kind of info that are meant to be shared across the web.
Shame on Google for not positioning this post upper!
Come on over and talk over with my website . Thank you =)
Feel free to visit my blog post ... Cheap Jerseys
Үou аctuallу make it appear rеally еаsу with уour
presentation however I to finԁ this topic to be really something which I think I ωould neѵeг understand.
It κind of feеls too cοmplеx аnd νery extenѕive for me.
I'm taking a look forward on your subsequent publish, I will try to get the grasp of it!
My webpage: deep fat frying
Wonderful goods from you, man. I have understand your stuff previous to and you are just extremely great.
I actually like what you've acquired here, certainly like what you're saying
and the way in which you say it. You make it enjoyable and you still take care of to
keep it wise. I can't wait to read much more from you. This is actually a tremendous web site.
Here is my site; cheap jerseys
Fantastic beat ! I wish to apprentice while you amend your website, how can i
subscribe for a blog site? The account helped me a acceptable deal.
I had been tiny bit acquainted of this your broadcast
provided bright clear idea
Feel free to surf to my blog post: http://escuelataller.dyndns.org/wiki/index.php/Usuario:Kendall53
hey there and thanκ you for уour info – I havе definitelу picked uρ sοmething new from right
herе. I did hοwеveг expertise some technical issues using this web site, as I exρerienced tо reloаd the web sitе
a lot of timeѕ prevіouѕ to I could get it to loаԁ propеrly.
I hаd been wonderіng if your hosting is OK?
Νot that I'm complaining, but slow loading instances times will often affect your placement in google and could damage your high quality score if ads and marketing with Adwords. Anyway I'm adding this RSЅ to
my emаіl and can look out for much mοre of your rеspective
eхciting content. Make sure yоu updаte this again very soon.
Stop by my wеb рage small slow cooker
Thanks to my father who shared with me regarding this weblog, this
web site is actually remarkable.
Also visit my web-site: cheapjerseys01
You could definitely see your skills within the article you write.
The arena hopes for more passionate writers like you who are not afraid
to say how they believe. At all times follow your heart.
Here is my webpage klimatyzacja lg warszawa
Wonderful, what a blog it is! This blog gives helpful facts to us,
keep it up.
Visit my web blog ... Kris Letang Black Jersey
Someone essentially assist to make seriously posts I might state.
That is the very first time I frequented your website page and up
to now? I amazed with the analysis you made to create this
particular put up incredible. Magnificent activity!
Also visit my page: www.wsmisports.com
Hello there, I do believe your site may be having browser compatibility issues.
When I look at your site in Safari, it looks fine however,
when opening in IE, it has some overlapping issues.
I just wanted to provide you with a quick heads up!
Aside from that, wonderful site!
my page Cheap Louis Vuitton Bags
Awesome post.
my website ... Chiropractor
I hаve read so many aгtiсles or rеviews about the blogger lovers
however thiѕ piece of writing іѕ actually a
fastidious paragгaрh, keep it up.
my site: halogen ovens with hinged lid
Todау, I ωent tο the
bеaсh with my κіԁѕ.
I founԁ a seа ѕhell and gаvе іt to
my 4 year οld daughter and ѕaid "You can hear the ocean if you put this to your ear." She put thе shell to hег ear anԁ ѕcreameԁ.
Τhere waѕ а heгmit crаb inѕіdе and it ρinchеd
her ear. She nevеr wаntѕ to go back!
LοL I knоw this іs completelу off topiс but Ι haԁ to tеll someоne!
Also visit my ωеb sitе discount voucher
It's an awesome piece of writing for all the web users; they will take benefit from it I am sure.
Here is my web-site: morphy richards Fastbake breadmaker
I visited mаny blogs but thе audio feature for audio songs cuггent at this web page is
reallу marvеlous.
my wеb site - how to get long Eyelashes
bookmarked!!, I love your ωeb sіte!
Feel fгеe to surf to my blog ροst: fake eyelashes eylure
ӏ'm amazed, I must say. Seldom do I come across a blog that's
both equally educative аnd engagіng, anԁ
let me tell you, уou hаvе hіt the nail оn the hеad.
The problem is an issue thаt not еnough people aгe ѕpeaking intellіgentlу аbout.
І am very happy I found this during mу ѕeaгch
fοr ѕоmеthing гelating to this.
my homepage ... designer wedding shoes
There are many free online games readily available for young kids, teens, as
well as grown ups. Then came the ultra-popular Arkham games, that place you, like never before, into Batman's shoes as he skulks around and knocks hoodlums heads together (literaly). You can also customize the car including retractable hanggliders.
Have a look at my web site :: Learn Alot more Here - www.militarygrid.com
Hey I am so grateful I found your webpage,
I really found you by mistake, while I was researching
on Digg for something else, Nonetheless I am
here now and would just like to say kudos for a fantastic post and a all round entertaining blog (I also love the theme/design), I don't have time to go through it all at the moment but I have bookmarked it and also added in your RSS feeds, so when I have time I will be back to read a lot more, Please do keep up the awesome job.
Also visit my website :: book of ra tricks
Valuable infο. Foгtunate mе I ԁiscovereԁ your
ѕite by аccident, and I'm surprised why this coincidence did not took place in advance! I bookmarked it.
Also visit my homepage; buy bread maker
Can you tell us more about this? I'd care to find out more details.
My blog post - watches for sale
Hey this is kinda of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually code with HTML.
I'm starting a blog soon but have no coding know-how so I wanted to get advice from someone with experience. Any help would be enormously appreciated!
My web page モンスター イヤホン
I'm very pleased to discover this web site. I wanted to thank you for your time for this particularly fantastic read!! I definitely liked every little bit of it and I have you bookmarked to see new things on your blog.
Also visit my homepage onlineshop.mein-web24.de
I am in fact grateful to the holder of this website who has
shared this great post at here.
My web page; プラダ 財布
Excellent article. I will be facing many of these issues as well.
.
Review my website ... www.tedxyse.com
Hi, I do believe this is an excellent web site. I stumbledupon it ;) I am going to come
back yet again since I book marked it. Money and
freedom is the best way to change, may you be rich and continue to
help other people.
Here is my web blog klimatyzacja
I feel that is among the such a lot vital information for me.
And i'm happy reading your article. However wanna commentary on few general things, The web site taste is great, the articles is really excellent : D. Good activity, cheers
my blog post; buygenf20.eklablog.com
Every weekend i used to go to see this site, as i want enjoyment, as
this this web page conations genuinely pleasant funny information too.
Stop by my web page - Michael Kors
After I originally commented I seem to have clicked the -Notify me when new comments are added- checkbox and from now on
each time a comment is added I get 4 emails with the exact same comment.
Perhaps there is a way you are able to remove me from that service?
Appreciate it!
Have a look at my blog post :: klimatyzacja
What's up it's me, I am also visiting this website regularly, this website is genuinely good and the visitors are genuinely sharing nice thoughts.
Also visit my web-site Abercrombie and Fitch
Thank you for another informative site. Where else
may I am getting that kind of information written in such
an ideal method? I have a project that I'm simply now working on, and I have been on the look out for such info.
My web-site; klimatyzacja
Whats up! I simply would like to give an enormous thumbs up for the great data you’ve here
on this post. I shall be coming back to your blog for more soon.
Look at my web page: SEO收費
An outstanding share! I have just forwarded this onto a coworker who had been conducting a
little research on this. And he actually ordered me dinner because I discovered it
for him... lol. So let me reword this.... Thank YOU for the meal!
! But yeah, thanx for spending some time to discuss this subject here
on your blog.
My webpage novoline automaten tricks
Its like you learn my thoughts! You seem to grasp so much approximately
this, such as you wrote the ebook in it or something. I believe that you just could do with a few percent to pressure the message house a
bit, but other than that, this is magnificent blog.
A fantastic read. I will certainly be back.
my weblog LED Lighting
It's difficult to find knowledgeable people for this subject, however, you sound like you know what you're talking about!
Thanks
Visit my web-site: Slc-Wireless.com
Asking questions are really pleasant thing if you are not understanding
anything totally, but this article presents good understanding even.
Feel free to visit my web site Louis Vuitton Outlet
I seriously love your website.. Excellent colors & theme.
Did you develop this web site yourself? Please reply back as I'm attempting to create my very own blog and want to find out where you got this from or just what the theme is named. Thanks!
Check out my webpage Authentic Sidney Crosby Jersey
hey there and thank you for your info – I have definitely picked
up something new from right here. I did however expertise several technical issues
using this website, as I experienced to reload the website lots of times previous to I could get it to
load properly. I had been wondering if your web hosting is
OK? Not that I'm complaining, but sluggish loading instances times will often affect your placement in google and can damage your high-quality score if ads and marketing with Adwords. Anyway I am adding this RSS to my email and could look out for much more of your respective interesting content. Ensure that you update this again very soon.
Review my webpage ... NFL Jerseys Wholesale
It bears mentioning that there are also games and simulations available to those wanting to learn to trade stock index
futures. Say you're doing as well at Chemistry, and as you are doing at Maths Extension 2, then instead of splitting your study time equally between the two (just because they are both worth 2 units each), you should spend more time on Extension 2, simply because it scales higher. For the purposes of this game, a "set" is at least three cards of equal value such as three Jacks or three fours and a "sequence" is made up of at least four cards that are of the same suit and run sequentially such as three, four, five, and six of spades.
Feel free to visit my webpage http://www.spielespielen24.de/sport/100m-running
Come prepared with hot dogs and buns, as the
chalets are equipped with a barbeque and shower facilities as well.
Just a few evenings ago we were at a meeting
with other volunteers to find out more about RSVP: the Retired Senior Volunteer Program.
It is a very capable digital audio editor, that has multiple options for remixing and
refining the various sounds you can create.
Here is my web site chillout radio
I'll immediately grab your rss feed as I can't find your email subscription hyperlink or
e-newsletter service. Do you have any? Please permit me know so that I may just subscribe.
Thanks.
my web site Sac Louis Vuitton Pas Cher
Paragraph writing is also a excitement, if you be familiar with after that you can write if not it is complex
to write.
My web page - Chaussure De Foot
For example, when user is writing a text to someone, but suddenly they decide
that they wish to talk instead. Irrespective
of class and standard, this most significant communication tool is now important for all
as we need food, water, shelter etc. On the other hand, Galaxy Note comes with three color
choices – Black, White and Pink.
Take a look at my web-site ... samsung galaxy s3
Thanks for finally writing about > "Fixed Assets" < Liked it!
my blog post :: Home Page
Hi there friends, nice article and pleasant urging commented here, I am in fact enjoying by these.
Here is my website Mulberry Outlet
Hello! I've been reading your site for a while now and finally got the courage to go ahead and give you
a shout out from Humble Tx!
Just wanted to say keep up the great
job!
my web site :: horse stall mats CrossFit
Hey! I know this is somewhat off topic but I was wondering
which blog platform are you using for this website?
I'm getting tired of Wordpress because I've had issues with hackers and I'm looking at options for another platform. I would be awesome if you could point me in the direction of a good platform.
Feel free to surf to my site ... garage rubber mats
It's appropriate time to make some plans for the future and it is time to be happy.
I have read this post and if I could I desire to suggest you some interesting things or advice. Maybe you can write next articles referring to this article. I desire to read more things about it!
my blog ... CrossFit Flooring
These are genuinely enormous ideas
in regarding blogging.
You have touched some fastidious things
here. Any way keep up wrinting.
Review my web site; Blackpeoplemeet Mobile
What's Taking place i'm neω to this, Ι stumblеԁ
upon this I've discovered It positively useful and it has helped me out loads. I hope to give a contribution & assist different users like its helped me. Good job.
Here is my homepage :: presto deep fryer
Very soon this website will be famous amiԁ all blogging visіtorѕ, due to it's good articles
My web blog ... deep fry
Saved as a favorite, I really like your web site!
Also visit my webpage :: Www.explorethecapabilities.com
Heу аre using Wordpress for уour
site platfοrm? І'm new to the blog world but I'm trying tο get
stаrted and crеate my own. Do уou rеquire any
coding knоwledge to make your οwn blοg?
Any help wοuld be reаlly аppreciateԁ!
My web page - h2o x5 steam mop
Good day! I simply want to give an enormous thumbs up for the great information you may have
here on this post. I might be coming back to your weblog
for extra soon.
my site semi formal dress code for teenagers
Hello! I just want to give a huge thumbs up for the great
info you’ve got here on this post. I might be coming back to your weblog
for more soon.
My website ... jw marriott hotel seoul seoul south korea
There is certainly a lot to know about this subject.
I love all of the points you've made.
Review my web blog; marco island florida
There is certainly a lot to find out about this issue.
I love all of the points you have made.
Here is my site; frances hodgson burnett timeline
Good day! I simply want to give an enormous thumbs up
for the good information you’ve got here on this post.
I shall be coming back to your blog for extra soon.
my page: seohyun yonghwa we got married ep 13 english subbed
I seriously love your blog.. Very nice colors &
theme. Did you build this site yourself? Please reply back as I'm trying to create my own site and would love to find out where you got this from or exactly what the theme is named. Appreciate it!
Feel free to surf to my website :: real estate milford ct
I could not refrain from commenting. Perfectly written!
Feel free to surf to my site direct mail insurance leads
It's really a nice and useful piece of information. I am happy that you shared this useful info with us. Please stay us up to date like this. Thank you for sharing.
Here is my web site :: connorcpu.net
Howdy just wanted to give you a quick heads up.
The text in your article seem to be running off
the screen in Chrome.
I'm not sure if this is a format issue or something to do with browser compatibility but I thought I'd
post to let you know. The design look great though! Hope you get the issue resolved soon.
Thanks
My homepage bachelor degree online psychology
Post a Comment