ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN F3C8BE918064A448E05362FB090549C7Y SELECT arc.CREATION_DATE, A1.AMOUNT_DUE_ORIGINAL RECEIPT_AMOUNT, A1.AMOUNT_DUE_REMAINING UNAPPLIED_AMOUNT, A1.DUE_DATE, A1.INVOICE_CURRENCY_CODE, A2.CUSTOMER_NAME, A3.SITE_USE_CODE, A6.RECEIPT_NUMBER, A6.RECEIPT_DATE, A1.AMOUNT_APPLIED FROM AR_CASH_RECEIPTS_ALL ARC, ar_payment_schedules_all A1, ar_customers A2, HZ_CUST_SITE_USES_ALL A3, HZ_CUST_ACCT_SITES_ALL A4, HZ_PARTY_SITES A5, ar_cash_receipts_all A6 WHERE ARC.ORG_ID=A1.ORG_ID AND A1.CUSTOMER_ID=A2.CUSTOMER_ID AND A1.CASH_RECEIPT_ID=A6.CASH_RECEIPT_ID AND A1.CLASS='PMT' AND A1.CUSTOMER_SITE_USE_ID=A3.SITE_USE_ID AND A3.CUST_ACCT_SITE_ID=A4.CUST_ACCT_SITE_ID AND A4.PARTY_SITE_ID=A5.PARTY_SITE_ID AR NEW_11 US AR NEW_1 Imported from BI Publisher Application: Receivables Source: NEW_1 Short Name: NEW_11 DB package: BI Publisher 1=1