VIEW: APPS.FA_TRANS_HIST_TRX_WEB_V

Source

View Text - Preformatted

SELECT TH.TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID , BC.BOOK_TYPE_CODE BOOK_TYPE_CODE , LU.MEANING TRANSACTION_TYPE_CODE , AD.ASSET_ID ASSET_ID , AD.ASSET_NUMBER , AD.ASSET_NUMBER||' - '||AD.DESCRIPTION ASSET_NUMBER_DESC , AD.DESCRIPTION , 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 , LO.MEANING 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 , CK.CONCATENATED_SEGMENTS CATEGORY FROM FA_LOOKUPS LU, FA_LOOKUPS LO, FA_CATEGORIES_B CT, FA_CATEGORIES_B_KFV CK, FA_CALENDAR_PERIODS CP, FA_DEPRN_PERIODS DP, FA_TRANSACTION_HEADERS TH, FA_ASSET_HISTORY AH, FA_ADDITIONS AD, FA_BOOK_CONTROLS BC WHERE AH.ASSET_ID = AD.ASSET_ID AND DP.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND CP.CALENDAR_TYPE = BC.DEPRN_CALENDAR AND CT.CATEGORY_ID = AH.CATEGORY_ID AND CT.CATEGORY_ID = CK.CATEGORY_ID AND LU.LOOKUP_TYPE = 'FAXOLTRX' AND LO.LOOKUP_TYPE(+) = 'TRANSACTION SUBTYPE' AND LO.LOOKUP_CODE(+) = TH.TRANSACTION_SUBTYPE AND TH.ASSET_ID = AD.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_TYPE_CODE = LU.LOOKUP_CODE 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)

View Text - HTML Formatted

SELECT TH.TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, BC.BOOK_TYPE_CODE BOOK_TYPE_CODE
, LU.MEANING TRANSACTION_TYPE_CODE
, AD.ASSET_ID ASSET_ID
, AD.ASSET_NUMBER
, AD.ASSET_NUMBER||' - '||AD.DESCRIPTION ASSET_NUMBER_DESC
, AD.DESCRIPTION
, 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
, LO.MEANING 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
, CK.CONCATENATED_SEGMENTS CATEGORY
FROM FA_LOOKUPS LU
, FA_LOOKUPS LO
, FA_CATEGORIES_B CT
, FA_CATEGORIES_B_KFV CK
, FA_CALENDAR_PERIODS CP
, FA_DEPRN_PERIODS DP
, FA_TRANSACTION_HEADERS TH
, FA_ASSET_HISTORY AH
, FA_ADDITIONS AD
, FA_BOOK_CONTROLS BC
WHERE AH.ASSET_ID = AD.ASSET_ID
AND DP.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND CP.CALENDAR_TYPE = BC.DEPRN_CALENDAR
AND CT.CATEGORY_ID = AH.CATEGORY_ID
AND CT.CATEGORY_ID = CK.CATEGORY_ID
AND LU.LOOKUP_TYPE = 'FAXOLTRX'
AND LO.LOOKUP_TYPE(+) = 'TRANSACTION SUBTYPE'
AND LO.LOOKUP_CODE(+) = TH.TRANSACTION_SUBTYPE
AND TH.ASSET_ID = AD.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_TYPE_CODE = LU.LOOKUP_CODE
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)