[Home] [Help]
305: HZ_LOCATIONS HL,
306: HZ_CUST_ACCT_SITES HCAS,
307: AR_CASH_RECEIPTS CR,
308: AR_CASH_RECEIPT_HISTORY CRH,
309: HZ_PARTY_SITES HPS
310: WHERE HP.PARTY_ID = HCA.PARTY_ID
311: AND ( HP.PARTY_NAME >= C_FROM
312: AND HP.PARTY_NAME <= C_TO )
313: AND HCA.CUST_ACCOUNT_ID = HCAS.CUST_ACCOUNT_ID