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_RECEIPTS_ALL

Line 5745: , ar_cash_receipts_all cr

5741:
5742: CURSOR cust_pay_risk (p_curr_code IN VARCHAR2 default NULL) IS
5743: SELECT SUM(NVL(crh.amount,0))
5744: FROM ar_cash_receipt_history crh
5745: , ar_cash_receipts_all cr
5746: , hz_cust_site_uses_all su
5747: , hz_cust_acct_sites_all cas
5748: WHERE crh.cash_receipt_id = cr.cash_receipt_id
5749: AND crh.org_id = cr.org_id /* MOAC_SQL_CHANGE */

Line 5786: , ar_cash_receipts_all cr

5782:
5783: CURSOR cust_br_pay_risk (p_curr_code IN VARCHAR2 default NULL) IS
5784: SELECT SUM(NVL(crh.amount,0))
5785: FROM ar_cash_receipt_history crh
5786: , ar_cash_receipts_all cr
5787: , hz_cust_site_uses_all su
5788: , hz_cust_acct_sites_all cas
5789: WHERE crh.cash_receipt_id = cr.cash_receipt_id
5790: AND crh.org_id = cr.org_id /* MOAC_SQL_CHANGE */

Line 6710: , ar_cash_receipts_all cr

6706:
6707: CURSOR site_pay_risk (p_curr_code IN VARCHAR2 default NULL) IS
6708: SELECT SUM(NVL(crh.amount,0))
6709: FROM ar_cash_receipt_history crh
6710: , ar_cash_receipts_all cr
6711: , hz_cust_site_uses_all s
6712: , hz_cust_acct_sites_all a
6713: WHERE crh.cash_receipt_id = cr.cash_receipt_id
6714: AND crh.org_id = cr.org_id

Line 6757: , ar_cash_receipts_all cr

6753:
6754: CURSOR site_br_pay_risk (p_curr_code IN VARCHAR2 default NULL) IS
6755: SELECT SUM(NVL(crh.amount,0))
6756: FROM ar_cash_receipt_history crh
6757: , ar_cash_receipts_all cr
6758: WHERE crh.cash_receipt_id = cr.cash_receipt_id
6759: AND crh.org_id = cr.org_id /* MOAC_SQL_CHANGE */
6760: AND crh.current_record_flag = 'Y'
6761: AND crh.status <> DECODE ( crh.factor_flag

Line 7557: , ar_cash_receipts_ALL cr

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
7561: AND (cr.confirmed_flag IS NULL OR cr.confirmed_flag = 'Y')

Line 7595: , ar_cash_receipts_ALL cr

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
7599: AND (cr.confirmed_flag IS NULL OR cr.confirmed_flag = 'Y')

Line 7630: , ar_cash_receipts_ALL cr

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'
7634: AND crh.status <> DECODE ( crh.factor_flag

Line 7679: , ar_cash_receipts_ALL cr

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
7683: AND (cr.confirmed_flag IS NULL OR cr.confirmed_flag = 'Y')