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

Line 3157: FROM ar_payment_schedules pay

3153: AND cas.cust_account_id = p_entity_id
3154: GROUP BY transactional_curr_code
3155: UNION
3156: SELECT pay.invoice_currency_code user_code
3157: FROM ar_payment_schedules pay
3158: , hz_cust_acct_sites_all cas
3159: , hz_cust_site_uses_all su
3160: WHERE pay.org_id = su.org_id
3161: AND pay.customer_site_use_id = su.site_use_id

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 3207: FROM ar_payment_schedules pay

3203: WHERE soh.invoice_to_org_id = p_entity_id
3204: GROUP BY transactional_curr_code
3205: UNION
3206: SELECT pay.invoice_currency_code user_code
3207: FROM ar_payment_schedules pay
3208: WHERE pay.customer_site_use_id = p_entity_id
3209: GROUP BY invoice_currency_code
3210: UNION
3211: SELECT exs.currency_code

Line 5352: FROM ar_payment_schedules

5348: END IF;
5349: BEGIN
5350: SELECT 'Y'
5351: INTO x_exist_flag
5352: FROM ar_payment_schedules
5353: WHERE customer_id = p_customer_id
5354: AND ( invoice_currency_code
5355: = p_usage_curr(i).usage_curr_code
5356: OR p_include_all_flag = 'Y' )

Line 5404: FROM ar_payment_schedules

5400: END IF;
5401: BEGIN
5402: SELECT 'Y'
5403: INTO x_exist_flag
5404: FROM ar_payment_schedules
5405: WHERE customer_site_use_id = p_site_use_id
5406: AND ( invoice_currency_code = p_usage_curr(i).usage_curr_code
5407: OR p_include_all_flag = 'Y' )
5408: AND NVL(receipt_confirmed_flag, 'Y') = 'Y'

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 5705: FROM ar_payment_schedules ps

5701: -- created by the bill to sites owned by the customer
5702:
5703: CURSOR cust_ar_balance (p_curr_code IN VARCHAR2 default NULL) IS
5704: SELECT SUM(NVL(ps.amount_due_remaining,0))
5705: FROM ar_payment_schedules ps
5706: , hz_cust_site_uses_all su
5707: , hz_cust_acct_sites_all cas
5708: WHERE ps.CUSTOMER_SITE_USE_ID = su.site_use_id
5709: AND ps.org_id = su.org_id /* MOAC_SQL_CHANGE */

Line 5726: FROM ar_payment_schedules ps

5722: ---------------------- BR support -------------------
5723:
5724: CURSOR cust_BR_balance (p_curr_code IN VARCHAR2 default NULL) IS
5725: SELECT SUM(NVL(ps.amount_due_remaining,0))
5726: FROM ar_payment_schedules ps
5727: , hz_cust_site_uses_all su
5728: , hz_cust_acct_sites_all cas
5729: WHERE ps.CUSTOMER_SITE_USE_ID = su.site_use_id
5730: AND ps.org_id = su.org_id /* MOAC_SQL_CHANGE */

Line 6695: FROM ar_payment_schedules

6691:
6692:
6693: CURSOR site_ar_balance (p_curr_code IN VARCHAR2 default NULL) IS
6694: SELECT SUM(NVL(amount_due_remaining,0) )
6695: FROM ar_payment_schedules
6696: WHERE customer_site_use_id = p_site_use_id
6697: AND status = 'OP'
6698: AND invoice_currency_code =
6699: p_curr_code

Line 6747: FROM ar_payment_schedules

6743:
6744: ------------------------ SITE BR ------------------------------
6745: CURSOR site_br_balance (p_curr_code IN VARCHAR2 default NULL) IS
6746: SELECT SUM(NVL(amount_due_remaining,0) )
6747: FROM ar_payment_schedules
6748: WHERE customer_site_use_id = l_drawee_site_use_id
6749: AND status = 'OP'
6750: AND invoice_currency_code = p_curr_code
6751: AND (receipt_confirmed_flag IS NULL OR receipt_confirmed_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'