7/17/2019 Cost Adjustment Query

1/1

SELECT distinct fat1.TRANSACTION_HEADER_ID, fat1.ADJUSTMENT_TYPE, fat1.SOURCE_TYPE_CODE, fat2.TRANSACTION_TYPE, fat1.ASSET_ID, fab1.ORIGINAL_COST, (fat2.CURRENT_COST - fat1.ADJUSTMENT_AMOUNT) as Before_Change, fat1.ADJUSTMENT_AMOUNT, fat2.CURRENT_COST, fat1.DEBIT_CREDIT_FLAG, fat2.DATE_EFFECTIVE, fat2.TRANSACTION_DATE_ENTEREDFROM FA.FA_ADJUSTMENTS fat1, FA_FINANCIAL_INQUIRY_COST_V fat2, FA.FA_BOOKS fab1WHERE fat1.TRANSACTION_HEADER_ID = fat2.TRANSACTION_HEADER_ID_INAND fat2.TRANSACTION_TYPE = 'Adjustment'AND fat1.SOURCE_TYPE_CODE = 'ADJUSTMENT'AND fat1.ADJUSTMENT_TYPE = 'COST'AND fat1.ASSET_ID = fat2.ASSET_IDand fat1.ASSET_ID = fab1.ASSET_IDand fab1.ASSET_ID = fat2.ASSET_IDAND fat1.ASSET_ID = '110896'order by fat2.TRANSACTION_DATE_ENTERED asc, fat1.ASSET_ID asc, fat2.CURRENT_COST

asc;