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 3185: FROM ar_payment_schedules_ALL pay

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

Line 5477: FROM ar_payment_schedules_ALL

5473:
5474: BEGIN
5475: SELECT 'Y'
5476: INTO x_exist_flag
5477: FROM ar_payment_schedules_ALL
5478: WHERE customer_id = p_customer_id
5479: AND ( invoice_currency_code
5480: = p_usage_curr(i).usage_curr_code
5481: OR p_include_all_flag = 'Y' )

Line 7504: FROM ar_payment_schedules_ALL ps

7500: --Bug 7570339
7501: /*CURSOR cust_ar_balance_global
7502: (p_curr_code IN VARCHAR2 default NULL) IS
7503: SELECT SUM(NVL(ps.amount_due_remaining,0))
7504: FROM ar_payment_schedules_ALL ps
7505: , hz_cust_site_uses_ALL su
7506: , hz_cust_acct_sites_ALL cas
7507: WHERE ps.customer_site_use_id = su.site_use_id
7508: AND ps.status = 'OP'

Line 7523: FROM ar_payment_schedules_ALL ps

7519: CURSOR cust_ar_balance_global
7520: (p_curr_code IN VARCHAR2 default NULL) IS
7521: SELECT SUM(NVL(amount_due_remaining,0)) FROM (
7522: SELECT NVL(ps.amount_due_remaining,0) amount_due_remaining,ps.PAYMENT_SCHEDULE_ID
7523: FROM ar_payment_schedules_ALL ps
7524: , hz_cust_site_uses_ALL su
7525: , hz_cust_acct_sites_ALL cas
7526: WHERE ps.customer_site_use_id = su.site_use_id
7527: AND ps.status = 'OP'

Line 7540: FROM ar_payment_schedules_ALL ps

7536: NVL(p_credit_check_rule_rec.OPEN_AR_DAYS, sysdate - ps.trx_date - 1)
7537: UNION
7538:
7539: SELECT NVL(ps.amount_due_remaining,0) amount_due_remaining,ps.PAYMENT_SCHEDULE_ID
7540: FROM ar_payment_schedules_ALL ps
7541: WHERE ps.status = 'OP'
7542: AND ps.CUSTOMER_ID = p_customer_id
7543: AND ps.CUSTOMER_SITE_USE_ID IS NULL
7544: AND ps.invoice_currency_code = p_curr_code

Line 7663: FROM ar_payment_schedules_ALL ps

7659: ----------------------------- BR -----------------------------
7660: CURSOR cust_br_balance_global
7661: (p_curr_code IN VARCHAR2 default NULL) IS
7662: SELECT SUM(NVL(ps.amount_due_remaining,0))
7663: FROM ar_payment_schedules_ALL ps
7664: , hz_cust_site_uses_ALL su
7665: , hz_cust_acct_sites_ALL cas
7666: WHERE ps.customer_site_use_id = su.site_use_id
7667: AND ps.status = 'OP'