View: FA_RETIREMENT_ADJUSTMENTS_V

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

View Text

SELECT TH.TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, TH.BOOK_TYPE_CODE BOOK_TYPE_CODE
, TH.ASSET_ID ASSET_ID
, TH.TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE
, POS.ADJUSTMENT_AMOUNT PROCEEDS_OF_SALE
, COR.ADJUSTMENT_AMOUNT COST_OF_REMOVAL
FROM FA_TRANSACTION_HEADERS TH
, FA_ADJUSTMENTS POS
, FA_ADJUSTMENTS COR
WHERE TH.TRANSACTION_HEADER_ID = POS.TRANSACTION_HEADER_ID
AND TH.TRANSACTION_HEADER_ID = COR.TRANSACTION_HEADER_ID
AND POS.ADJUSTMENT_TYPE = 'PROCEEDS CLR'
AND COR.ADJUSTMENT_TYPE = 'REMOVALCOST CLR'

Columns