AR Automatic Receipts Awaiting Confirmation
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Automatic Receipts Awaiting Confirmation
Application: Receivables
Source: Automatic Receipts Awaiting Confirmation (XML)
Short Name: ARXAPRCF_XML
DB package: AR_ARXAPRCF_XMLP_PKG
Description: Automatic Receipts Awaiting Confirmation
Application: Receivables
Source: Automatic Receipts Awaiting Confirmation (XML)
Short Name: ARXAPRCF_XML
DB package: AR_ARXAPRCF_XMLP_PKG
Run
AR Automatic Receipts Awaiting Confirmation and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT decode(:p_sort_by, 'REMITT ACCOUNT', cba.bank_account_name, null) dcol_A, decode(:p_sort_by, 'MATURITY DATE', ps.due_date, 'REMITT ACCOUNT', ps.due_date, null) dcoldate_A, decode(:p_sort_by, 'CUSTOMER', SUBSTRB(PARTY.PARTY_NAME,1,50), 'PHONETIC',DECODE(PARTY.PARTY_TYPE, 'ORGANIZATION', PARTY.ORGANIZATION_NAME_PHONETIC,NULL), &P_SORT) dcolcust_A, cr.currency_code curr_code, SUBSTRB(PARTY.PARTY_NAME,1,50) cust_name, cust.ACCOUNT_NUMBER cust_num, site.location location, cba.bank_account_name acct_name, ps.due_date due_date, cr.receipt_number rcpt_num, cr.receipt_date rcpt_date, cr.amount amount FROM ar_cash_receipts cr, ar_cash_receipt_history crh, ar_payment_schedules ps, HZ_CUST_ACCOUNTS cust, HZ_PARTIES PARTY, HZ_CUST_site_uses site, ce_bank_acct_uses acct, ce_bank_accounts cba WHERE crh.cash_receipt_id = cr.cash_receipt_id AND crh.status = 'APPROVED' AND crh.current_record_flag = 'Y' AND ps.cash_receipt_id = cr.cash_receipt_id AND cust.CUST_ACCOUNT_ID = cr.pay_from_customer AND CUST.PARTY_ID = PARTY.PARTY_ID AND site.site_use_id (+) = cr.customer_site_use_id AND acct.bank_acct_use_id(+) = cr.remit_bank_acct_use_id AND acct.bank_account_id = cba.bank_account_id (+) &LP_CUST_NAME &LP_CUST_NUM &LP_REMIT_ACCOUNT &LP_MATURITY_DATE &LP_CURRENCY ORDER BY curr_code, dcol_A, dcoldate_A, dcolcust_A, cust_num, location, acct_name, due_date, rcpt_num, rcpt_date, amount, 10, 12 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV | |
Order By |
|
LOV Oracle | |
CustomerName Low |
|
LOV Oracle | |
Customer Name High |
|
LOV Oracle | |
Customer Number Low |
|
LOV Oracle | |
Customer Number High |
|
LOV Oracle | |
Remittance Account |
|
LOV Oracle | |
Maturity Date Low |
|
Date | |
Maturity Date High |
|
Date | |
Currency |
|
LOV Oracle |