SELECT DISTINCT CT.TRX_NUMBER DEDUCTION_NUMBER FROM AR_TA_REMIT_HIST RH1 , AR_TA_REMIT_HIST RH2 , RA_CUSTOMER_TRX CT WHERE RH1.RECORD_TYPE=6 AND RH2.RECORD_TYPE=7 AND RH2.PARENT_HISTORY_LINE_ID=RH1.HISTORY_LINE_ID AND RH2.NEW_TRX_ID=CT.CUSTOMER_TRX_ID