VIEW: APPS.FA_TRANSACTION_HEADERS_V

Source

View Text - Preformatted

SELECT TH.ROWID ROW_ID , TH.TRANSACTION_HEADER_ID , TH.BOOK_TYPE_CODE , TH.ASSET_ID , TH.TRANSACTION_TYPE_CODE , TH.TRANSACTION_DATE_ENTERED , TH.DATE_EFFECTIVE , TH.LAST_UPDATE_DATE , TH.LAST_UPDATED_BY , TH.TRANSACTION_NAME , TH.INVOICE_TRANSACTION_ID , TH.SOURCE_TRANSACTION_HEADER_ID , TH.MASS_REFERENCE_ID , TH.LAST_UPDATE_LOGIN , TH.TRANSACTION_SUBTYPE , 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.ATTRIBUTE_CATEGORY_CODE , TH.TRANSACTION_KEY , AD.ASSET_NUMBER , BC.ACCOUNTING_FLEX_STRUCTURE ACCT_FLEX_NUM , AH.UNITS CURRENT_UNITS FROM FA_ADDITIONS_B AD, FA_ASSET_HISTORY AH, FA_BOOK_CONTROLS BC, FA_TRANSACTION_HEADERS TH WHERE AD.ASSET_ID = TH.ASSET_ID AND AH.ASSET_ID = TH.ASSET_ID AND AH.DATE_EFFECTIVE <= TH.DATE_EFFECTIVE AND NVL(AH.DATE_INEFFECTIVE,TH.DATE_EFFECTIVE+1) > TH.DATE_EFFECTIVE AND BC.BOOK_TYPE_CODE = TH.BOOK_TYPE_CODE AND BC.BOOK_CLASS = 'CORPORATE' AND NVL(BC.DATE_INEFFECTIVE, SYSDATE+1) > SYSDATE AND TH.TRANSACTION_TYPE_CODE IN ('TRANSFER','TRANSFER IN', 'UNIT ADJUSTMENT', 'TRANSFER OUT')

View Text - HTML Formatted

SELECT TH.ROWID ROW_ID
, TH.TRANSACTION_HEADER_ID
, TH.BOOK_TYPE_CODE
, TH.ASSET_ID
, TH.TRANSACTION_TYPE_CODE
, TH.TRANSACTION_DATE_ENTERED
, TH.DATE_EFFECTIVE
, TH.LAST_UPDATE_DATE
, TH.LAST_UPDATED_BY
, TH.TRANSACTION_NAME
, TH.INVOICE_TRANSACTION_ID
, TH.SOURCE_TRANSACTION_HEADER_ID
, TH.MASS_REFERENCE_ID
, TH.LAST_UPDATE_LOGIN
, TH.TRANSACTION_SUBTYPE
, 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.ATTRIBUTE_CATEGORY_CODE
, TH.TRANSACTION_KEY
, AD.ASSET_NUMBER
, BC.ACCOUNTING_FLEX_STRUCTURE ACCT_FLEX_NUM
, AH.UNITS CURRENT_UNITS
FROM FA_ADDITIONS_B AD
, FA_ASSET_HISTORY AH
, FA_BOOK_CONTROLS BC
, FA_TRANSACTION_HEADERS TH
WHERE AD.ASSET_ID = TH.ASSET_ID
AND AH.ASSET_ID = TH.ASSET_ID
AND AH.DATE_EFFECTIVE <= TH.DATE_EFFECTIVE
AND NVL(AH.DATE_INEFFECTIVE
, TH.DATE_EFFECTIVE+1) > TH.DATE_EFFECTIVE
AND BC.BOOK_TYPE_CODE = TH.BOOK_TYPE_CODE
AND BC.BOOK_CLASS = 'CORPORATE'
AND NVL(BC.DATE_INEFFECTIVE
, SYSDATE+1) > SYSDATE
AND TH.TRANSACTION_TYPE_CODE IN ('TRANSFER'
, 'TRANSFER IN'
, 'UNIT ADJUSTMENT'
, 'TRANSFER OUT')