Introduction:
This report will display all the Non printed invoices details to business.
select
(SELECT B1.ACCOUNT_NUMBER FROM apps.hz_cust_accounts_all B1 WHERE A.BILL_TO_CUSTOMER_ID=B1.CUST_ACCOUNT_ID)ACCOUNT_NUMBER,
(SELECT E.PARTY_SITE_NUMBER
FROM apps.hz_cust_acct_sites_all C,
apps.hz_cust_site_uses_all D,
apps.hz_party_sites E,
apps.hz_cust_accounts_all B
WHERE 1=1
AND A.BILL_TO_CUSTOMER_ID=B.CUST_ACCOUNT_ID
AND B.CUST_ACCOUNT_ID=C.CUST_ACCOUNT_ID
AND C.CUST_ACCT_SITE_ID=D.CUST_ACCT_SITE_ID
AND C.PARTY_SITE_ID=E.PARTY_SITE_ID
AND D.SITE_USE_ID=A.BILL_TO_SITE_USE_ID
AND d.org_id=c.org_id) BILL_TO_PARTY_SITE_NUM,
(SELECT E.PARTY_SITE_NUMBER
FROM apps.hz_cust_acct_sites_all C,
apps.hz_cust_site_uses_all D,
apps.hz_party_sites E,
apps.hz_cust_accounts_all B
WHERE 1=1
AND A.SHIP_TO_CUSTOMER_ID=B.CUST_ACCOUNT_ID
AND B.CUST_ACCOUNT_ID=C.CUST_ACCOUNT_ID
AND C.CUST_ACCT_SITE_ID=D.CUST_ACCT_SITE_ID
AND C.PARTY_SITE_ID=E.PARTY_SITE_ID
AND D.SITE_USE_ID=A.SHIP_TO_SITE_USE_ID
AND d.org_id=c.org_id) SHIP_TO_PARTY_SITE_NUM,
A.trx_number INVOICE_NUM,
A.creation_date,
A.trx_date,
A.INTERFACE_HEADER_ATTRIBUTE2 Invoice_Source,
A.Attribute1 Period,
A.interface_header_context ,
A.PRINTING_ORIGINAL_DATE,
A.PRINTING_LAST_PRINTED,
A.PRINTING_PENDING
FROM apps.ra_customer_trx_all A
where 1 = 1
and A.PRINTING_LAST_PRINTED IS NULL
AND A.INTERFACE_HEADER_CONTEXT = ‘ORDER ENTRY’
and A.interface_header_ATTRIBUTE2 LIKE ‘%XXXX%’
and A.printing_original_date is null
and TRUNC(A.CREATION_DATE) between NVL(:P_START_DATE,TRUNC(A.CREATION_DATE)) AND nvl(:P_END_DATE,TRUNC(SYSDATE))
and a.org_id=:P_ORG_ID
Summary:
This report will use the business to identity the non printed AR invoices and they can print the same.
Know more about post.
Doyen.ebiz@gmail.com
