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

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

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

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

Line 5558: FROM ar_payment_schedules

5554: END IF;
5555: BEGIN
5556: SELECT 'Y'
5557: INTO x_exist_flag
5558: FROM ar_payment_schedules
5559: WHERE customer_id = p_customer_id
5560: AND ( invoice_currency_code
5561: = p_usage_curr(i).usage_curr_code
5562: OR p_include_all_flag = 'Y' )

Line 5610: FROM ar_payment_schedules

5606: END IF;
5607: BEGIN
5608: SELECT 'Y'
5609: INTO x_exist_flag
5610: FROM ar_payment_schedules
5611: WHERE customer_site_use_id = p_site_use_id
5612: AND ( invoice_currency_code = p_usage_curr(i).usage_curr_code
5613: OR p_include_all_flag = 'Y' )
5614: AND NVL(receipt_confirmed_flag, 'Y') = 'Y'

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

5907: -- created by the bill to sites owned by the customer
5908:
5909: CURSOR cust_ar_balance (p_curr_code IN VARCHAR2 default NULL) IS
5910: SELECT SUM(NVL(ps.amount_due_remaining,0))
5911: FROM ar_payment_schedules ps
5912: , hz_cust_site_uses_all su
5913: -- , hz_cust_acct_sites_all cas -- Commented Bug#11827225
5914: WHERE ps.CUSTOMER_SITE_USE_ID = su.site_use_id
5915: AND ps.org_id = su.org_id /* MOAC_SQL_CHANGE */

Line 5933: FROM ar_payment_schedules ps

5929: ---------------------- BR support -------------------
5930:
5931: CURSOR cust_BR_balance (p_curr_code IN VARCHAR2 default NULL) IS
5932: SELECT SUM(NVL(ps.amount_due_remaining,0))
5933: FROM ar_payment_schedules ps
5934: , hz_cust_site_uses_all su
5935: -- , hz_cust_acct_sites_all cas -- Commented Bug#11827225
5936: WHERE ps.CUSTOMER_SITE_USE_ID = su.site_use_id
5937: AND ps.org_id = su.org_id /* MOAC_SQL_CHANGE */

Line 6951: FROM ar_payment_schedules

6947:
6948:
6949: CURSOR site_ar_balance (p_curr_code IN VARCHAR2 default NULL) IS
6950: SELECT SUM(NVL(amount_due_remaining,0) )
6951: FROM ar_payment_schedules
6952: WHERE customer_site_use_id = p_site_use_id
6953: AND status = 'OP'
6954: AND invoice_currency_code =
6955: p_curr_code

Line 7003: FROM ar_payment_schedules

6999:
7000: ------------------------ SITE BR ------------------------------
7001: CURSOR site_br_balance (p_curr_code IN VARCHAR2 default NULL) IS
7002: SELECT SUM(NVL(amount_due_remaining,0) )
7003: FROM ar_payment_schedules
7004: WHERE customer_site_use_id = l_drawee_site_use_id
7005: AND status = 'OP'
7006: AND invoice_currency_code = p_curr_code
7007: AND (receipt_confirmed_flag IS NULL OR receipt_confirmed_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'