AR NEW_1

Description
Categories: BI Publisher
Imported from BI Publisher
Application: Receivables
Source: NEW_1
Short Name: NEW_11
DB package:

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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