FND Design Data [Home] [Help]

View: FA_TRANSACTION_HISTORY_BOOKS_V

Product: OFA - Assets
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.FA_TRANSACTION_HISTORY_BOOKS_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
, 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) || '.' || LPAD(NVL(MOD(BK.LIFE_IN_MONTHS
, 12)
, 0)
, 2
, 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
, FABC.SET_OF_BOOKS_ID SOB_ID
, 'PRIMARY' TYPE
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
, FA_BOOK_CONTROLS FABC
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 (+)
AND BK.BOOK_TYPE_CODE = FABC.BOOK_TYPE_CODE 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) || '.' || LPAD(NVL(MOD(BK.LIFE_IN_MONTHS
, 12)
, 0)
, 2
, 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
, FABC.SET_OF_BOOKS_ID SOB_ID
, 'PRIMARY' TYPE
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
, FA_BOOK_CONTROLS FABC
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 (+)
AND BK.BOOK_TYPE_CODE = FABC.BOOK_TYPE_CODE UNION ALL 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
, BK.SET_OF_BOOKS_ID
, 'REPORTING' TYPE
FROM FA_ADDITIONS_B ADB
, FA_ADDITIONS_TL ADTL
, FA_LOOKUPS_TL LOTL
, FA_LOOKUPS_B LOB
, FA_MC_BOOKS BK
, FA_TRANSACTION_HEADERS TH
, FA_ADDITIONS_B GADB
, FA_ADDITIONS_TL GADTL
, FA_BOOK_CONTROLS FABC
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
, BK.SET_OF_BOOKS_ID
, 'REPORTING' TYPE
FROM FA_ADDITIONS_B ADB
, FA_ADDITIONS_TL ADTL
, FA_LOOKUPS_B LOB
, FA_LOOKUPS_TL LOTL
, FA_MC_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(+)

Columns

Name
TRANSACTION_HEADER_ID_IN
TRANSACTION_HEADER_ID_OUT
KEY
ASSET_ID
ASSET_NUMBER
BOOK_TYPE_CODE
TRANSACTION_TYPE
CURRENT_COST
ORIGINAL_COST
SALVAGE_VALUE
RECOVERABLE_COST
DEPRN_METHOD_CODE
LIFE
ADJUSTED_RATE
PRODUCTION_CAPACITY
UNIT_OF_MEASURE
PRORATE_CONVENTION_CODE
PRORATE_DATE
DATE_PLACED_IN_SERVICE
DEPRECIATE_FLAG
BONUS_RULE
CEILING_NAME
REVALUATION_CEILING
COMMENTS
ADJUSTED_RECOVERABLE_COST
GROUP_ASSET_NUMBER
SOB_ID
TYPE