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_CASH_RECEIPT_HISTORY_ALL

Line 7556: FROM ar_cash_receipt_history_ALL crh

7552:
7553: /*CURSOR cust_pay_risk_global
7554: (p_curr_code IN VARCHAR2 default NULL) IS
7555: SELECT SUM(NVL(crh.amount,0))
7556: FROM ar_cash_receipt_history_ALL crh
7557: , ar_cash_receipts_ALL cr
7558: , hz_cust_site_uses_ALL su
7559: , hz_cust_acct_sites_ALL cas
7560: WHERE crh.cash_receipt_id = cr.cash_receipt_id

Line 7594: FROM ar_cash_receipt_history_ALL crh

7590: CURSOR cust_pay_risk_global
7591: (p_curr_code IN VARCHAR2 default NULL) IS
7592: SELECT SUM(NVL(amount,0)) FROM (
7593: SELECT NVL(crh.amount,0) amount,cr.pay_from_customer,cr.cash_receipt_id
7594: FROM ar_cash_receipt_history_ALL crh
7595: , ar_cash_receipts_ALL cr
7596: , hz_cust_site_uses_ALL su
7597: , hz_cust_acct_sites_ALL cas
7598: WHERE crh.cash_receipt_id = cr.cash_receipt_id

Line 7629: FROM ar_cash_receipt_history_ALL crh

7625: AND rap.display = 'Y'
7626: )
7627: UNION
7628: SELECT NVL(crh.amount,0) amount,cr.pay_from_customer,cr.cash_receipt_id
7629: FROM ar_cash_receipt_history_ALL crh
7630: , ar_cash_receipts_ALL cr
7631: WHERE crh.cash_receipt_id = cr.cash_receipt_id
7632: AND (cr.confirmed_flag IS NULL OR cr.confirmed_flag = 'Y')
7633: AND crh.current_record_flag = 'Y'

Line 7678: FROM ar_cash_receipt_history_ALL crh

7674:
7675: CURSOR cust_br_pay_risk_global
7676: (p_curr_code IN VARCHAR2 default NULL) IS
7677: SELECT SUM(NVL(crh.amount,0))
7678: FROM ar_cash_receipt_history_ALL crh
7679: , ar_cash_receipts_ALL cr
7680: , hz_cust_site_uses_ALL su
7681: , hz_cust_acct_sites_ALL cas
7682: WHERE crh.cash_receipt_id = cr.cash_receipt_id