AR NEW_1

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

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