View: FA_TRANS_HIST_BOOKS_WEB_V

Product:	OFA - Assets
Description:	Asset transaction history in a given book
Implementation/DBA Data:	APPS.FA_TRANS_HIST_BOOKS_WEB_V

View Text

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

Columns