View: FA_TRANSACTIONS_V

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

View Text

SELECT TH.ASSET_ID
, AD.ASSET_NUMBER
, ADTL.DESCRIPTION
, TH.TRANSACTION_HEADER_ID
, TH.TRANSACTION_TYPE_CODE
, TH.BOOK_TYPE_CODE
, TH.INVOICE_TRANSACTION_ID
, TH.TRX_REFERENCE_ID
, DP.PERIOD_COUNTER
, DP.PERIOD_NAME
FROM FA_TRANSACTION_HEADERS TH
, FA_ADDITIONS_B AD
, FA_ADDITIONS_TL ADTL
, FA_DEPRN_PERIODS DP
WHERE TH.ASSET_ID = AD.ASSET_ID
AND ADTL.ASSET_ID = AD.ASSET_ID
AND ADTL.LANGUAGE = USERENV('LANG')
AND TH.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND TH.DATE_EFFECTIVE BETWEEN DP.PERIOD_OPEN_DATE
AND NVL(DP.PERIOD_CLOSE_DATE
, SYSDATE) UNION SELECT TH.ASSET_ID
, AD.ASSET_NUMBER
, ADTL.DESCRIPTION
, TH.TRANSACTION_HEADER_ID
, TH.TRANSACTION_TYPE_CODE
, DP.BOOK_TYPE_CODE
, TH.INVOICE_TRANSACTION_ID
, TH.TRX_REFERENCE_ID
, DP.PERIOD_COUNTER
, DP.PERIOD_NAME
FROM FA_TRANSACTION_HEADERS TH
, FA_ADDITIONS_B AD
, FA_ADDITIONS_TL ADTL
, FA_DEPRN_PERIODS DP
, FA_BOOK_CONTROLS FBC
WHERE TH.ASSET_ID = AD.ASSET_ID
AND ADTL.ASSET_ID = AD.ASSET_ID
AND ADTL.LANGUAGE = USERENV('LANG')
AND TH.BOOK_TYPE_CODE = FBC.DISTRIBUTION_SOURCE_BOOK
AND FBC.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND TH.TRANSACTION_TYPE_CODE IN ( 'TRANSFER'
, 'RECLASS'
, 'UNIT ADJUSTMENT'
, 'REINSTATEMENT'
, 'TRANSFER OUT')
AND TH.DATE_EFFECTIVE BETWEEN DP.PERIOD_OPEN_DATE
AND NVL(DP.PERIOD_CLOSE_DATE
, SYSDATE)

Columns