View: FABV_ASSET_BKS

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

View Text

SELECT TRANSACTION_HEADER_ID_IN
, DATE_PLACED_IN_SERVICE
, DEPRN_START_DATE
, DEPRN_METHOD_CODE
, LIFE_IN_MONTHS
, COST
, ORIGINAL_COST
, SALVAGE_VALUE
, PRORATE_CONVENTION_CODE
, PRORATE_DATE
, DEPRECIATE_FLAG
, ITC_AMOUNT_ID
, ITC_AMOUNT
, ITC_BASIS
, BASIC_RATE
, ADJUSTED_RATE
, BONUS_RULE
, CEILING_NAME
, RECOVERABLE_COST
, PRODUCTION_CAPACITY
, REVAL_CEILING
, UNIT_OF_MEASURE
, UNREVALUED_COST
, PERCENT_SALVAGE_VALUE
, ALLOWED_DEPRN_LIMIT_AMOUNT
, BOOK_TYPE_CODE
, ASSET_ID
, FULLY_RSVD_REVALS_COUNTER
, PERIOD_COUNTER_CAPITALIZED
, PERIOD_COUNTER_FULLY_RESERVED
, PERIOD_COUNTER_FULLY_RETIRED
, PERIOD_COUNTER_LIFE_COMPLETE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM FA_BOOKS
WHERE TRANSACTION_HEADER_ID_OUT IS NULL
AND DATE_INEFFECTIVE IS NULL WITH READ ONLY

Columns