View: FAFV_TRANS_HDRS

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

View Text

SELECT TH.TRANSACTION_HEADER_ID
, TH.TRANSACTION_TYPE_CODE
, TH.TRANSACTION_DATE_ENTERED
, TH.TRANSACTION_NAME
, AJ.SOURCE_TYPE_CODE
, TH.BOOK_TYPE_CODE
, TH.ASSET_ID
, AD.ASSET_NUMBER
, AJ.LAST_UPDATE_DATE
, AJ.LAST_UPDATED_BY
FROM FA_TRANSACTION_HEADERS TH
, FA_ADJUSTMENTS AJ
, FA_ADDITIONS AD
WHERE AJ.TRANSACTION_HEADER_ID = TH.TRANSACTION_HEADER_ID
AND AJ.BOOK_TYPE_CODE = TH.BOOK_TYPE_CODE
AND AJ.ASSET_ID = TH.ASSET_ID
AND TH.ASSET_ID = AD.ASSET_ID WITH READ ONLY

Columns