View: FAFV_ASSET_BKS

Product:	OFA - Assets
Description:	- Retrofitted
Implementation/DBA Data:	APPS.FAFV_ASSET_BKS

View Text

SELECT BK.TRANSACTION_HEADER_ID_IN
, BK.DATE_PLACED_IN_SERVICE
, BK.DEPRN_START_DATE
, BK.DEPRN_METHOD_CODE
, BK.LIFE_IN_MONTHS
, BK.COST
, BK.ORIGINAL_COST
, BK.SALVAGE_VALUE
, BK.PRORATE_CONVENTION_CODE
, BK.PRORATE_DATE
, BK.DEPRECIATE_FLAG
, BK.ITC_AMOUNT_ID
, BK.ITC_AMOUNT
, BK.ITC_BASIS
, BK.BASIC_RATE
, BK.ADJUSTED_RATE
, BK.BONUS_RULE
, BK.CEILING_NAME
, BK.RECOVERABLE_COST
, BK.PRODUCTION_CAPACITY
, BK.REVAL_CEILING
, BK.UNIT_OF_MEASURE
, BK.UNREVALUED_COST
, BK.PERCENT_SALVAGE_VALUE
, BK.ALLOWED_DEPRN_LIMIT_AMOUNT
, BK.BOOK_TYPE_CODE
, BK.ASSET_ID
, AD.ASSET_NUMBER
, BK.FULLY_RSVD_REVALS_COUNTER
, BK.PERIOD_COUNTER_CAPITALIZED
, DP1.PERIOD_NAME
, BK.PERIOD_COUNTER_FULLY_RESERVED
, DP2.PERIOD_NAME
, BK.PERIOD_COUNTER_FULLY_RETIRED
, DP3.PERIOD_NAME
, BK.PERIOD_COUNTER_LIFE_COMPLETE
, DP4.PERIOD_NAME
, BK.LAST_UPDATE_DATE
, BK.LAST_UPDATED_BY
FROM FA_BOOKS BK
, FA_ADDITIONS AD
, FA_DEPRN_PERIODS DP1
, FA_DEPRN_PERIODS DP2
, FA_DEPRN_PERIODS DP3
, FA_DEPRN_PERIODS DP4
WHERE BK.TRANSACTION_HEADER_ID_OUT IS NULL
AND BK.DATE_INEFFECTIVE IS NULL
AND BK.ASSET_ID = AD.ASSET_ID
AND BK.BOOK_TYPE_CODE = DP1.BOOK_TYPE_CODE (+)
AND BK.BOOK_TYPE_CODE = DP2.BOOK_TYPE_CODE (+)
AND BK.BOOK_TYPE_CODE = DP3.BOOK_TYPE_CODE (+)
AND BK.BOOK_TYPE_CODE = DP4.BOOK_TYPE_CODE (+)
AND BK.PERIOD_COUNTER_CAPITALIZED = DP1.PERIOD_COUNTER (+)
AND BK.PERIOD_COUNTER_FULLY_RESERVED = DP2.PERIOD_COUNTER (+)
AND BK.PERIOD_COUNTER_FULLY_RETIRED = DP3.PERIOD_COUNTER (+)
AND BK.PERIOD_COUNTER_LIFE_COMPLETE = DP4.PERIOD_COUNTER (+) WITH READ ONLY

Columns