VIEW: APPS.FA_TRANS_HIST_BOOKS_WEB_V

Source

View Text - Preformatted

SELECT BK.TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN , BK.TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT , BK.TRANSACTION_HEADER_ID_IN KEY , BK.ASSET_ID , BK.BOOK_TYPE_CODE , LO.MEANING TRANSACTION_TYPE , TO_CHAR(BK.COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) CURRENT_COST , TO_CHAR(BK.ORIGINAL_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) ORIGINAL_COST , TO_CHAR(BK.SALVAGE_VALUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) SALVAGE_VALUE , TO_CHAR(BK.RECOVERABLE_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) RECOVERABLE_COST , BK.DEPRN_METHOD_CODE DEPRN_METHOD_CODE , FND_NUMBER.CANONICAL_TO_NUMBER( NVL(ROUND( BK.LIFE_IN_MONTHS/12),0) || '.' || NVL(MOD(BK.LIFE_IN_MONTHS,12),0)) LIFE , BK.ADJUSTED_RATE ADJUSTED_RATE , BK.PRODUCTION_CAPACITY , BK.UNIT_OF_MEASURE , BK.PRORATE_CONVENTION_CODE , BK.PRORATE_DATE , BK.DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE , LU.MEANING DEPRECIATE_FLAG , BK.BONUS_RULE BONUS_RULE , BK.CEILING_NAME CEILING_NAME , BK.REVAL_CEILING REVALUATION_CEILING , TH.TRANSACTION_NAME COMMENTS , TO_CHAR(BK.ADJUSTED_RECOVERABLE_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) ADJUSTED_RECOVERABLE_COST FROM FA_BOOK_CONTROLS BC, GL_SETS_OF_BOOKS GLSB, FA_LOOKUPS LO, FA_LOOKUPS LU, FA_BOOKS BK, FA_TRANSACTION_HEADERS TH WHERE TH.TRANSACTION_HEADER_ID = BK.TRANSACTION_HEADER_ID_IN AND TH.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID AND (LO.LOOKUP_TYPE = 'FAXOLTRX' AND LO.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE) AND (LU.LOOKUP_TYPE = 'YESNO' AND LU.LOOKUP_CODE = BK.DEPRECIATE_FLAG) UNION SELECT BK.TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN, BK.TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT, BK.TRANSACTION_HEADER_ID_OUT KEY, BK.ASSET_ID, BK.BOOK_TYPE_CODE, LO.MEANING TRANSACTION_TYPE, TO_CHAR(BK.COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) CURRENT_COST, TO_CHAR(BK.ORIGINAL_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) ORIGINAL_COST, TO_CHAR(BK.SALVAGE_VALUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) SALVAGE_VALUE, TO_CHAR(BK.RECOVERABLE_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) RECOVERABLE_COST, BK.DEPRN_METHOD_CODE DEPRN_METHOD_CODE, FND_NUMBER.CANONICAL_TO_NUMBER (NVL(ROUND(BK.LIFE_IN_MONTHS/12),0)||'.' ||NVL(MOD(BK.LIFE_IN_MONTHS,12),0)) LIFE, BK.ADJUSTED_RATE ADJUSTED_RATE, BK.PRODUCTION_CAPACITY, BK.UNIT_OF_MEASURE, BK.PRORATE_CONVENTION_CODE, BK.PRORATE_DATE, BK.DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, LU.MEANING DEPRECIATE_FLAG, BK.BONUS_RULE BONUS_RULE, BK.CEILING_NAME CEILING_NAME, BK.REVAL_CEILING REVALUATION_CEILING, TH.TRANSACTION_NAME COMMENTS, TO_CHAR(BK.ADJUSTED_RECOVERABLE_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) ADJUSTED_RECOVERABLE_COST FROM FA_BOOK_CONTROLS BC, GL_SETS_OF_BOOKS GLSB, FA_LOOKUPS LO, FA_LOOKUPS LU, FA_BOOKS BK, FA_TRANSACTION_HEADERS TH WHERE TH.TRANSACTION_HEADER_ID = BK.TRANSACTION_HEADER_ID_IN AND TH.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID AND (LO.LOOKUP_TYPE = 'FAXOLTRX' AND LO.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE) AND (LU.LOOKUP_TYPE = 'YESNO' AND LU.LOOKUP_CODE = BK.DEPRECIATE_FLAG) AND BK.TRANSACTION_HEADER_ID_OUT IS NOT NULL

View Text - HTML Formatted

SELECT BK.TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN
, BK.TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT
, BK.TRANSACTION_HEADER_ID_IN KEY
, BK.ASSET_ID
, BK.BOOK_TYPE_CODE
, LO.MEANING TRANSACTION_TYPE
, TO_CHAR(BK.COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) CURRENT_COST
, TO_CHAR(BK.ORIGINAL_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ORIGINAL_COST
, TO_CHAR(BK.SALVAGE_VALUE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) SALVAGE_VALUE
, TO_CHAR(BK.RECOVERABLE_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) RECOVERABLE_COST
, BK.DEPRN_METHOD_CODE DEPRN_METHOD_CODE
, FND_NUMBER.CANONICAL_TO_NUMBER( NVL(ROUND( BK.LIFE_IN_MONTHS/12)
, 0) || '.' || NVL(MOD(BK.LIFE_IN_MONTHS
, 12)
, 0)) LIFE
, BK.ADJUSTED_RATE ADJUSTED_RATE
, BK.PRODUCTION_CAPACITY
, BK.UNIT_OF_MEASURE
, BK.PRORATE_CONVENTION_CODE
, BK.PRORATE_DATE
, BK.DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, LU.MEANING DEPRECIATE_FLAG
, BK.BONUS_RULE BONUS_RULE
, BK.CEILING_NAME CEILING_NAME
, BK.REVAL_CEILING REVALUATION_CEILING
, TH.TRANSACTION_NAME COMMENTS
, TO_CHAR(BK.ADJUSTED_RECOVERABLE_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ADJUSTED_RECOVERABLE_COST
FROM FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GLSB
, FA_LOOKUPS LO
, FA_LOOKUPS LU
, FA_BOOKS BK
, FA_TRANSACTION_HEADERS TH
WHERE TH.TRANSACTION_HEADER_ID = BK.TRANSACTION_HEADER_ID_IN
AND TH.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND (LO.LOOKUP_TYPE = 'FAXOLTRX'
AND LO.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE)
AND (LU.LOOKUP_TYPE = 'YESNO'
AND LU.LOOKUP_CODE = BK.DEPRECIATE_FLAG) UNION SELECT BK.TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN
, BK.TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT
, BK.TRANSACTION_HEADER_ID_OUT KEY
, BK.ASSET_ID
, BK.BOOK_TYPE_CODE
, LO.MEANING TRANSACTION_TYPE
, TO_CHAR(BK.COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) CURRENT_COST
, TO_CHAR(BK.ORIGINAL_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ORIGINAL_COST
, TO_CHAR(BK.SALVAGE_VALUE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) SALVAGE_VALUE
, TO_CHAR(BK.RECOVERABLE_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) RECOVERABLE_COST
, BK.DEPRN_METHOD_CODE DEPRN_METHOD_CODE
, FND_NUMBER.CANONICAL_TO_NUMBER (NVL(ROUND(BK.LIFE_IN_MONTHS/12)
, 0)||'.' ||NVL(MOD(BK.LIFE_IN_MONTHS
, 12)
, 0)) LIFE
, BK.ADJUSTED_RATE ADJUSTED_RATE
, BK.PRODUCTION_CAPACITY
, BK.UNIT_OF_MEASURE
, BK.PRORATE_CONVENTION_CODE
, BK.PRORATE_DATE
, BK.DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, LU.MEANING DEPRECIATE_FLAG
, BK.BONUS_RULE BONUS_RULE
, BK.CEILING_NAME CEILING_NAME
, BK.REVAL_CEILING REVALUATION_CEILING
, TH.TRANSACTION_NAME COMMENTS
, TO_CHAR(BK.ADJUSTED_RECOVERABLE_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) ADJUSTED_RECOVERABLE_COST
FROM FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GLSB
, FA_LOOKUPS LO
, FA_LOOKUPS LU
, FA_BOOKS BK
, FA_TRANSACTION_HEADERS TH
WHERE TH.TRANSACTION_HEADER_ID = BK.TRANSACTION_HEADER_ID_IN
AND TH.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND (LO.LOOKUP_TYPE = 'FAXOLTRX'
AND LO.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE)
AND (LU.LOOKUP_TYPE = 'YESNO'
AND LU.LOOKUP_CODE = BK.DEPRECIATE_FLAG)
AND BK.TRANSACTION_HEADER_ID_OUT IS NOT NULL