VIEW: APPS.FA_TRANSACTION_HISTORY_TRX_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)