SELECT DISTINCT SU.LOCATION LOCATION_NUMBER FROM AR_TA_REMIT_HIST RH1 , AR_TA_REMIT_HIST RH2 , RA_CUSTOMER_TRX CT , HZ_CUST_SITE_USES SU 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 AND CT.BILL_TO_SITE_USE_ID=SU.SITE_USE_ID