VIEW: APPS.FA_TRANSACTION_HISTORY_BOOKS_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 , ADB.ASSET_NUMBER||' - '||ADTL.DESCRIPTION ASSET_NUMBER , BK.BOOK_TYPE_CODE , LOTL.MEANING TRANSACTION_TYPE , BK.COST CURRENT_COST , BK.ORIGINAL_COST ORIGINAL_COST , BK.SALVAGE_VALUE , BK.RECOVERABLE_COST , BK.DEPRN_METHOD_CODE DEPRN_METHOD_CODE , FND_NUMBER.CANONICAL_TO_NUMBER ( NVL(TRUNC(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 , BK.DEPRECIATE_FLAG , BK.BONUS_RULE BONUS_RULE , BK.CEILING_NAME CEILING_NAME , BK.REVAL_CEILING REVALUATION_CEILING , TH.TRANSACTION_NAME COMMENTS , BK.ADJUSTED_RECOVERABLE_COST , GADB.ASSET_NUMBER || ' - ' || GADTL.DESCRIPTION GROUP_ASSET_NUMBER FROM FA_ADDITIONS_B ADB, FA_ADDITIONS_TL ADTL, FA_LOOKUPS_tl LOTL, FA_LOOKUPS_B LOB, FA_BOOKS BK, FA_TRANSACTION_HEADERS TH, FA_ADDITIONS_B GADB, FA_ADDITIONS_TL GADTL WHERE TH.TRANSACTION_HEADER_ID = BK.TRANSACTION_HEADER_ID_IN AND ADB.ASSET_ID = BK.ASSET_ID AND ADB.ASSET_ID = ADTL.ASSET_ID AND ADTL.LANGUAGE = USERENV('LANG') AND LOB.LOOKUP_TYPE = 'FAXOLTRX' AND LOB.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE AND LOB.LOOKUP_TYPE = LOTL.LOOKUP_TYPE AND LOB.LOOKUP_CODE = LOTL.LOOKUP_CODE AND LOTL.LANGUAGE = USERENV('LANG') AND BK.GROUP_ASSET_ID = GADB.ASSET_ID (+) AND BK.GROUP_ASSET_ID = GADTL.ASSET_ID(+) AND USERENV('LANG') = GADTL.LANGUAGE (+) 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, ADB.ASSET_NUMBER||' - '||ADTL.DESCRIPTION ASSET_NUMBER, BK.BOOK_TYPE_CODE, LOTL.MEANING TRANSACTION_TYPE, BK.COST CURRENT_COST, BK.ORIGINAL_COST ORIGINAL_COST, BK.SALVAGE_VALUE, BK.RECOVERABLE_COST, BK.DEPRN_METHOD_CODE DEPRN_METHOD_CODE, FND_NUMBER.CANONICAL_TO_NUMBER (NVL(TRUNC(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, BK.DEPRECIATE_FLAG, BK.BONUS_RULE BONUS_RULE, BK.CEILING_NAME CEILING_NAME, BK.REVAL_CEILING REVALUATION_CEILING, TH.TRANSACTION_NAME COMMENTS, BK.ADJUSTED_RECOVERABLE_COST, GADB.ASSET_NUMBER || ' - ' || GADTL.DESCRIPTION GROUP_ASSET_NUMBER FROM FA_ADDITIONS_B ADB, FA_ADDITIONS_TL ADTL, FA_LOOKUPS_B LOB, FA_LOOKUPS_TL LOTL, FA_BOOKS BK, FA_TRANSACTION_HEADERS TH, FA_ADDITIONS_B GADB, FA_ADDITIONS_TL GADTL WHERE TH.TRANSACTION_HEADER_ID = BK.TRANSACTION_HEADER_ID_IN AND ADB.ASSET_ID = BK.ASSET_ID AND ADB.ASSET_ID = ADTL.ASSET_ID AND ADTL.LANGUAGE = USERENV('LANG') AND LOB.LOOKUP_TYPE = 'FAXOLTRX' AND LOB.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE AND LOB.LOOKUP_TYPE = LOTL.LOOKUP_TYPE AND LOB.LOOKUP_CODE = LOTL.LOOKUP_CODE AND LOTL.LANGUAGE = USERENV('LANG') AND BK.TRANSACTION_HEADER_ID_OUT IS NOT NULL AND BK.GROUP_ASSET_ID = GADB.ASSET_ID (+) AND BK.GROUP_ASSET_ID = GADTL.ASSET_ID(+) AND USERENV('LANG') = GADTL.LANGUAGE (+)

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
, ADB.ASSET_NUMBER||' - '||ADTL.DESCRIPTION ASSET_NUMBER
, BK.BOOK_TYPE_CODE
, LOTL.MEANING TRANSACTION_TYPE
, BK.COST CURRENT_COST
, BK.ORIGINAL_COST ORIGINAL_COST
, BK.SALVAGE_VALUE
, BK.RECOVERABLE_COST
, BK.DEPRN_METHOD_CODE DEPRN_METHOD_CODE
, FND_NUMBER.CANONICAL_TO_NUMBER ( NVL(TRUNC(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
, BK.DEPRECIATE_FLAG
, BK.BONUS_RULE BONUS_RULE
, BK.CEILING_NAME CEILING_NAME
, BK.REVAL_CEILING REVALUATION_CEILING
, TH.TRANSACTION_NAME COMMENTS
, BK.ADJUSTED_RECOVERABLE_COST
, GADB.ASSET_NUMBER || ' - ' || GADTL.DESCRIPTION GROUP_ASSET_NUMBER
FROM FA_ADDITIONS_B ADB
, FA_ADDITIONS_TL ADTL
, FA_LOOKUPS_TL LOTL
, FA_LOOKUPS_B LOB
, FA_BOOKS BK
, FA_TRANSACTION_HEADERS TH
, FA_ADDITIONS_B GADB
, FA_ADDITIONS_TL GADTL
WHERE TH.TRANSACTION_HEADER_ID = BK.TRANSACTION_HEADER_ID_IN
AND ADB.ASSET_ID = BK.ASSET_ID
AND ADB.ASSET_ID = ADTL.ASSET_ID
AND ADTL.LANGUAGE = USERENV('LANG')
AND LOB.LOOKUP_TYPE = 'FAXOLTRX'
AND LOB.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE
AND LOB.LOOKUP_TYPE = LOTL.LOOKUP_TYPE
AND LOB.LOOKUP_CODE = LOTL.LOOKUP_CODE
AND LOTL.LANGUAGE = USERENV('LANG')
AND BK.GROUP_ASSET_ID = GADB.ASSET_ID (+)
AND BK.GROUP_ASSET_ID = GADTL.ASSET_ID(+)
AND USERENV('LANG') = GADTL.LANGUAGE (+) 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
, ADB.ASSET_NUMBER||' - '||ADTL.DESCRIPTION ASSET_NUMBER
, BK.BOOK_TYPE_CODE
, LOTL.MEANING TRANSACTION_TYPE
, BK.COST CURRENT_COST
, BK.ORIGINAL_COST ORIGINAL_COST
, BK.SALVAGE_VALUE
, BK.RECOVERABLE_COST
, BK.DEPRN_METHOD_CODE DEPRN_METHOD_CODE
, FND_NUMBER.CANONICAL_TO_NUMBER (NVL(TRUNC(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
, BK.DEPRECIATE_FLAG
, BK.BONUS_RULE BONUS_RULE
, BK.CEILING_NAME CEILING_NAME
, BK.REVAL_CEILING REVALUATION_CEILING
, TH.TRANSACTION_NAME COMMENTS
, BK.ADJUSTED_RECOVERABLE_COST
, GADB.ASSET_NUMBER || ' - ' || GADTL.DESCRIPTION GROUP_ASSET_NUMBER
FROM FA_ADDITIONS_B ADB
, FA_ADDITIONS_TL ADTL
, FA_LOOKUPS_B LOB
, FA_LOOKUPS_TL LOTL
, FA_BOOKS BK
, FA_TRANSACTION_HEADERS TH
, FA_ADDITIONS_B GADB
, FA_ADDITIONS_TL GADTL
WHERE TH.TRANSACTION_HEADER_ID = BK.TRANSACTION_HEADER_ID_IN
AND ADB.ASSET_ID = BK.ASSET_ID
AND ADB.ASSET_ID = ADTL.ASSET_ID
AND ADTL.LANGUAGE = USERENV('LANG')
AND LOB.LOOKUP_TYPE = 'FAXOLTRX'
AND LOB.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE
AND LOB.LOOKUP_TYPE = LOTL.LOOKUP_TYPE
AND LOB.LOOKUP_CODE = LOTL.LOOKUP_CODE
AND LOTL.LANGUAGE = USERENV('LANG')
AND BK.TRANSACTION_HEADER_ID_OUT IS NOT NULL
AND BK.GROUP_ASSET_ID = GADB.ASSET_ID (+)
AND BK.GROUP_ASSET_ID = GADTL.ASSET_ID(+)
AND USERENV('LANG') = GADTL.LANGUAGE (+)