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