VIEW: APPS.FABV_ASSET_BKS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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