eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CREDIT_CHECK_UTIL dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 3186: FROM ar_payment_schedules_ALL pay

3182: AND cas.cust_account_id = p_entity_id
3183: GROUP BY transactional_curr_code
3184: UNION
3185: SELECT pay.invoice_currency_code user_code
3186: FROM ar_payment_schedules_ALL pay
3187: , hz_cust_acct_sites_ALL cas
3188: , hz_cust_site_uses_ALL su
3189: WHERE pay.customer_site_use_id = su.site_use_id
3190: AND cas.cust_acct_site_id = su.cust_acct_site_id

Line 5683: FROM ar_payment_schedules_ALL

5679:
5680: BEGIN
5681: SELECT 'Y'
5682: INTO x_exist_flag
5683: FROM ar_payment_schedules_ALL
5684: WHERE customer_id = p_customer_id
5685: AND ( invoice_currency_code
5686: = p_usage_curr(i).usage_curr_code
5687: OR p_include_all_flag = 'Y' )

Line 7808: FROM ar_payment_schedules_ALL ps

7804: --Bug 7570339
7805: /*CURSOR cust_ar_balance_global
7806: (p_curr_code IN VARCHAR2 default NULL) IS
7807: SELECT SUM(NVL(ps.amount_due_remaining,0))
7808: FROM ar_payment_schedules_ALL ps
7809: , hz_cust_site_uses_ALL su
7810: , hz_cust_acct_sites_ALL cas
7811: WHERE ps.customer_site_use_id = su.site_use_id
7812: AND ps.status = 'OP'

Line 7827: FROM ar_payment_schedules_ALL ps

7823: CURSOR cust_ar_balance_global
7824: (p_curr_code IN VARCHAR2 default NULL) IS
7825: SELECT SUM(NVL(amount_due_remaining,0)) FROM (
7826: SELECT NVL(ps.amount_due_remaining,0) amount_due_remaining,ps.PAYMENT_SCHEDULE_ID
7827: FROM ar_payment_schedules_ALL ps
7828: , hz_cust_site_uses_ALL su
7829: , hz_cust_acct_sites_ALL cas
7830: WHERE ps.customer_site_use_id = su.site_use_id
7831: AND ps.status = 'OP'

Line 7844: FROM ar_payment_schedules_ALL ps

7840: NVL(p_credit_check_rule_rec.OPEN_AR_DAYS, sysdate - ps.trx_date - 1)
7841: UNION
7842:
7843: SELECT NVL(ps.amount_due_remaining,0) amount_due_remaining,ps.PAYMENT_SCHEDULE_ID
7844: FROM ar_payment_schedules_ALL ps
7845: WHERE ps.status = 'OP'
7846: AND ps.CUSTOMER_ID = p_customer_id
7847: AND ps.CUSTOMER_SITE_USE_ID IS NULL
7848: AND ps.invoice_currency_code = p_curr_code

Line 7967: FROM ar_payment_schedules_ALL ps

7963: ----------------------------- BR -----------------------------
7964: CURSOR cust_br_balance_global
7965: (p_curr_code IN VARCHAR2 default NULL) IS
7966: SELECT SUM(NVL(ps.amount_due_remaining,0))
7967: FROM ar_payment_schedules_ALL ps
7968: , hz_cust_site_uses_ALL su
7969: -- , hz_cust_acct_sites_ALL cas -- Commented Bug#11827225
7970: WHERE ps.customer_site_use_id = su.site_use_id
7971: AND ps.status = 'OP'