VIEW: APPS.FA_BOOKS_BK_CNTRL_WEB_V

Source

View Text - Preformatted

SELECT BC.BOOK_CLASS, BK.TRANSACTION_HEADER_ID_IN , BK.TRANSACTION_HEADER_ID_OUT, BK.BOOK_TYPE_CODE , BK.ASSET_ID, BK.DATE_INEFFECTIVE , TO_CHAR(BK.COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GB.CURRENCY_CODE,30)) COST, TO_CHAR(BK.ORIGINAL_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GB.CURRENCY_CODE,30)) ORIGINAL_COST, BK.CEILING_NAME , TO_CHAR(BK.SALVAGE_VALUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GB.CURRENCY_CODE,30)) SALVAGE_VALUE, TO_CHAR(BK.REVAL_CEILING, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GB.CURRENCY_CODE,30)) REVAL_CEILING, TO_CHAR(BK.ITC_BASIS, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GB.CURRENCY_CODE,30)) ITC_BASIS, BK.ITC_AMOUNT_ID, BK.DATE_PLACED_IN_SERVICE, BK.DEPRECIATE_FLAG, BK.PRORATE_CONVENTION_CODE, BK.PRORATE_DATE, BK.DEPRN_METHOD_CODE, BK.LIFE_IN_MONTHS, BK.BASIC_RATE, BK.ADJUSTED_RATE, BK.BONUS_RULE, BK.UNIT_OF_MEASURE, BK.PRODUCTION_CAPACITY, TO_CHAR(BK.RECOVERABLE_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GB.CURRENCY_CODE,30)) RECOVERABLE_COST, AD.ASSET_NUMBER, CB.DEPRN_METHOD, CB.ITC_ELIGIBLE_FLAG, GB.CURRENCY_CODE FROM FA_ADDITIONS_B AD, FA_CATEGORY_BOOK_DEFAULTS CB, GL_SETS_OF_BOOKS GB, FA_BOOKS BK, FA_BOOK_CONTROLS BC WHERE BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND BK.ASSET_ID = AD.ASSET_ID AND BC.SET_OF_BOOKS_ID = GB.SET_OF_BOOKS_ID AND CB.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE AND AD.ASSET_CATEGORY_ID = CB.CATEGORY_ID and BK.date_placed_in_service between CB.start_dpis and nvl(CB.end_dpis, BK.date_placed_in_service) AND BK.DATE_INEFFECTIVE IS NULL

View Text - HTML Formatted

SELECT BC.BOOK_CLASS
, BK.TRANSACTION_HEADER_ID_IN
, BK.TRANSACTION_HEADER_ID_OUT
, BK.BOOK_TYPE_CODE
, BK.ASSET_ID
, BK.DATE_INEFFECTIVE
, TO_CHAR(BK.COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GB.CURRENCY_CODE
, 30)) COST
, TO_CHAR(BK.ORIGINAL_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GB.CURRENCY_CODE
, 30)) ORIGINAL_COST
, BK.CEILING_NAME
, TO_CHAR(BK.SALVAGE_VALUE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GB.CURRENCY_CODE
, 30)) SALVAGE_VALUE
, TO_CHAR(BK.REVAL_CEILING
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GB.CURRENCY_CODE
, 30)) REVAL_CEILING
, TO_CHAR(BK.ITC_BASIS
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GB.CURRENCY_CODE
, 30)) ITC_BASIS
, BK.ITC_AMOUNT_ID
, BK.DATE_PLACED_IN_SERVICE
, BK.DEPRECIATE_FLAG
, BK.PRORATE_CONVENTION_CODE
, BK.PRORATE_DATE
, BK.DEPRN_METHOD_CODE
, BK.LIFE_IN_MONTHS
, BK.BASIC_RATE
, BK.ADJUSTED_RATE
, BK.BONUS_RULE
, BK.UNIT_OF_MEASURE
, BK.PRODUCTION_CAPACITY
, TO_CHAR(BK.RECOVERABLE_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GB.CURRENCY_CODE
, 30)) RECOVERABLE_COST
, AD.ASSET_NUMBER
, CB.DEPRN_METHOD
, CB.ITC_ELIGIBLE_FLAG
, GB.CURRENCY_CODE
FROM FA_ADDITIONS_B AD
, FA_CATEGORY_BOOK_DEFAULTS CB
, GL_SETS_OF_BOOKS GB
, FA_BOOKS BK
, FA_BOOK_CONTROLS BC
WHERE BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BK.ASSET_ID = AD.ASSET_ID
AND BC.SET_OF_BOOKS_ID = GB.SET_OF_BOOKS_ID
AND CB.BOOK_TYPE_CODE = BK.BOOK_TYPE_CODE
AND AD.ASSET_CATEGORY_ID = CB.CATEGORY_ID
AND BK.DATE_PLACED_IN_SERVICE BETWEEN CB.START_DPIS
AND NVL(CB.END_DPIS
, BK.DATE_PLACED_IN_SERVICE)
AND BK.DATE_INEFFECTIVE IS NULL