View: FA_TRANSACTION_HEADERS_V

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

View Text

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')

Columns