View: FA_TRANSACTION_HISTORY_TRX_V

Product:	OFA - Assets
Description:	- Retrofitted
Implementation/DBA Data:	APPS.FA_TRANSACTION_HISTORY_TRX_V

View Text

SELECT TH.TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, TH.TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE
, BC.BOOK_TYPE_CODE BOOK_TYPE_CODE
, LOTL.MEANING TRANSACTION_TYPE
, ADB.ASSET_ID ASSET_ID
, ADB.ASSET_NUMBER
, ADB.ASSET_NUMBER||' - '||ADTL.DESCRIPTION ASSET_NUMBER_DESC
, AH.CATEGORY_ID CATEGORY_ID
, CT.SEGMENT1
, CT.SEGMENT2
, CT.SEGMENT3
, CT.SEGMENT4
, CT.SEGMENT5
, CT.SEGMENT6
, CT.SEGMENT7
, TH.TRANSACTION_DATE_ENTERED TRANSACTION_DATE_ENTERED
, CP.PERIOD_NAME PERIOD_EFFECTIVE
, TH.DATE_EFFECTIVE DATE_EFFECTIVE
, DP.PERIOD_COUNTER PERIOD_COUNTER
, DP.PERIOD_NAME PERIOD_ENTERED
, TH.TRANSACTION_NAME COMMENTS
, TH.ATTRIBUTE_CATEGORY_CODE ATTRIBUTE_CATEGORY_CODE
, TH.INVOICE_TRANSACTION_ID INOVICE_TRANSACTION_ID
, TH.SOURCE_TRANSACTION_HEADER_ID SOURCE_HEADER_ID
, TH.MASS_REFERENCE_ID MASS_REFERENCE_ID
, TH.TRANSACTION_SUBTYPE TRANSACTION_SUBTYPE
, TH.TRANSACTION_KEY TRANSACTION_KEY
, TH.ATTRIBUTE1
, TH.ATTRIBUTE2
, TH.ATTRIBUTE3
, TH.ATTRIBUTE4
, TH.ATTRIBUTE5
, TH.ATTRIBUTE6
, TH.ATTRIBUTE7
, TH.ATTRIBUTE8
, TH.ATTRIBUTE9
, TH.ATTRIBUTE10
, TH.ATTRIBUTE11
, TH.ATTRIBUTE12
, TH.ATTRIBUTE13
, TH.ATTRIBUTE14
, TH.ATTRIBUTE15
, TH.LAST_UPDATE_DATE
, TH.LAST_UPDATED_BY
, TH.LAST_UPDATE_LOGIN
, TRX.TRX_REFERENCE_ID
, TRX.TRANSACTION_TYPE TRX_REFERENCE_TYPE
, ADTL.DESCRIPTION
FROM FA_LOOKUPS_B LOB
, FA_LOOKUPS_TL LOTL
, FA_CATEGORIES CT
, FA_CALENDAR_PERIODS CP
, FA_DEPRN_PERIODS DP
, FA_TRANSACTION_HEADERS TH
, FA_ASSET_HISTORY AH
, FA_ADDITIONS_B ADB
, FA_ADDITIONS_TL ADTL
, FA_BOOK_CONTROLS BC
, FA_TRX_REFERENCES TRX
WHERE AH.ASSET_ID = ADB.ASSET_ID
AND ADB.ASSET_ID = ADTL.ASSET_ID
AND ADTL.LANGUAGE = USERENV('LANG')
AND DP.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND CP.CALENDAR_TYPE = BC.DEPRN_CALENDAR
AND CT.CATEGORY_ID = AH.CATEGORY_ID
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 TH.ASSET_ID = ADB.ASSET_ID
AND TH.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND TH.TRANSACTION_HEADER_ID >= AH.TRANSACTION_HEADER_ID_IN
AND TH.TRANSACTION_HEADER_ID < NVL(AH.TRANSACTION_HEADER_ID_OUT
, TH.TRANSACTION_HEADER_ID + 1)
AND TH.TRANSACTION_DATE_ENTERED BETWEEN CP.START_DATE
AND CP.END_DATE
AND TH.DATE_EFFECTIVE BETWEEN DP.PERIOD_OPEN_DATE
AND NVL(DP.PERIOD_CLOSE_DATE
, TH.DATE_EFFECTIVE)
AND TH.TRX_REFERENCE_ID = TRX.TRX_REFERENCE_ID(+)

Columns