View: FA_BOOKS_BOOK_CONTROLS_V

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

View Text

SELECT BC.BOOK_CLASS
, B.TRANSACTION_HEADER_ID_IN
, B.TRANSACTION_HEADER_ID_OUT
, B.BOOK_TYPE_CODE
, B.ASSET_ID
, B.DATE_INEFFECTIVE
, B.COST
, B.ORIGINAL_COST
, B.CEILING_NAME
, B.SALVAGE_VALUE
, B.REVAL_CEILING
, B.ITC_BASIS
, B.ITC_AMOUNT_ID
, B.DATE_PLACED_IN_SERVICE
, B.DEPRECIATE_FLAG
, B.PRORATE_CONVENTION_CODE
, B.PRORATE_DATE
, B.DEPRN_METHOD_CODE
, B.LIFE_IN_MONTHS
, B.BASIC_RATE
, B.ADJUSTED_RATE
, B.BONUS_RULE
, B.UNIT_OF_MEASURE
, B.PRODUCTION_CAPACITY
, B.DISABLED_FLAG
, B.CASH_GENERATING_UNIT_ID
FROM FA_BOOKS B
, FA_BOOK_CONTROLS BC
WHERE B.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE

Columns