AR NEW_1

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Receivables
Source: NEW_1
Short Name: NEW_11
DB package:
Run AR NEW_1 and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
JG Receipt Acknowledgment Letter- Not Supported: Reserved For Future Use AR Direct Debit Pre-Notification Letter GL Account Analysis (Distributions) COPY OF: GL Account Analysis JG Regional Dunning Letter - draft GL Account Analysis AR Transactions and Payments AR Aging - 7 Buckets - By Salesperson/Agent AR Unapplied Receipts Register
Blitz Report™

Blitz Report™ provides multiple benefits: