VIEW: APPS.FA_BOOKS_BOOK_CONTROLS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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