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, BC.set_of_books_id sob_id, name ledger_name, currency_code, 'Primary' type FROM FA_BOOKS B, FA_BOOK_CONTROLS BC, GL_LEDGERS GLL WHERE B.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE and gll.ledger_id = bc.set_of_books_id UNION ALL 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, B.set_of_books_id, name ledger_name, currency_code, 'Reporting' type FROM FA_MC_BOOKS B, FA_BOOK_CONTROLS BC,gl_ledgers gll WHERE B.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE and gll.ledger_id = b.set_of_books_id

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
, BC.SET_OF_BOOKS_ID SOB_ID
, NAME LEDGER_NAME
, CURRENCY_CODE
, 'PRIMARY' TYPE
FROM FA_BOOKS B
, FA_BOOK_CONTROLS BC
, GL_LEDGERS GLL
WHERE B.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND GLL.LEDGER_ID = BC.SET_OF_BOOKS_ID UNION ALL 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
, B.SET_OF_BOOKS_ID
, NAME LEDGER_NAME
, CURRENCY_CODE
, 'REPORTING' TYPE
FROM FA_MC_BOOKS B
, FA_BOOK_CONTROLS BC
, GL_LEDGERS GLL
WHERE B.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND GLL.LEDGER_ID = B.SET_OF_BOOKS_ID