AR Work Load Review
Description
Categories: BI Publisher
Application: Receivables
Source: Work Load Review Report
Short Name: ARWLREW
DB package: AR_WL_REW_PKG
Source: Work Load Review Report
Short Name: ARWLREW
DB package: AR_WL_REW_PKG
SELECT acr.receipt_number RECEIPT_NUMBER, receipt_date RECEIPT_DATE, hca.account_number CUSTOMER_NUMBER, hp.party_name PARTY_NAME, acr.currency_code CURRENCY_CODE, acr.amount RECEIPT_AMT, decode(acr.status, 'UNAPP', ABS(aps.amount_due_remaining), 0) UNAPP_AMT, decode(acr.status, 'UNID', ABS(aps.amount_due_remaining), 0) UNID_AMT, acr.work_item_assignment_date WORK_ITEM_ASSIGNMENT_DATE, fu.user_name USER_NAME, lu.meaning WORK_ITEM_STATUS FROM ar_cash_receipts_all acr, ar_payment_schedules_all aps, fnd_user fu, hz_cust_accounts_all hca, hz_parties hp, ar_lookups lu WHERE 'Y' = :p_detail AND fu.user_id = acr.cash_appln_owner_id AND acr.cash_receipt_id = aps.cash_receipt_id AND hca.party_id = hp.party_id (+) AND acr.pay_from_customer = hca.cust_account_id (+) AND acr.work_item_status_code = lu.lookup_code AND lu.lookup_type = 'WORK_ITEM_STATUS' &gc_org_id &gc_cash_appln_owner &gc_recpt_date &gc_cust &gc_work_item_status &gc_assgn_date ORDER BY RECEIPT_NUMBER |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV Oracle | |
Cash Application Owner From |
|
LOV Oracle | |
Cash Application Owner To |
|
LOV Oracle | |
Receipt Date From |
|
Date | |
Receipt Date To |
|
Date | |
Customer Number From |
|
LOV Oracle | |
Customer Number To |
|
LOV Oracle | |
Work Item Status From |
|
LOV Oracle | |
Work Item Status To |
|
LOV Oracle | |
Assignment Date From |
|
Date | |
Assignment Date To |
|
Date | |
Detail |
|
LOV Oracle |