[Home] [Help]
View: 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
TRANSACTION_HEADER_ID |
TRANSACTION_TYPE_CODE |
BOOK_TYPE_CODE |
TRANSACTION_TYPE |
ASSET_ID |
ASSET_NUMBER |
ASSET_NUMBER_DESC |
CATEGORY_ID |
SEGMENT1 |
SEGMENT2 |
SEGMENT3 |
SEGMENT4 |
SEGMENT5 |
SEGMENT6 |
SEGMENT7 |
TRANSACTION_DATE_ENTERED |
PERIOD_EFFECTIVE |
DATE_EFFECTIVE |
PERIOD_COUNTER |
PERIOD_ENTERED |
COMMENTS |
ATTRIBUTE_CATEGORY_CODE |
INOVICE_TRANSACTION_ID |
SOURCE_HEADER_ID |
MASS_REFERENCE_ID |
TRANSACTION_SUBTYPE |
TRANSACTION_KEY |
ATTRIBUTE1 |
ATTRIBUTE2 |
ATTRIBUTE3 |
ATTRIBUTE4 |
ATTRIBUTE5 |
ATTRIBUTE6 |
ATTRIBUTE7 |
ATTRIBUTE8 |
ATTRIBUTE9 |
ATTRIBUTE10 |
ATTRIBUTE11 |
ATTRIBUTE12 |
ATTRIBUTE13 |
ATTRIBUTE14 |
ATTRIBUTE15 |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
TRX_REFERENCE_ID |
TRX_REFERENCE_TYPE |
DESCRIPTION |
Name |