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 5953: , ar_cash_receipts_all cr

5949:
5950: CURSOR cust_pay_risk (p_curr_code IN VARCHAR2 default NULL) IS
5951: SELECT SUM(NVL(crh.amount,0))
5952: FROM ar_cash_receipt_history crh
5953: , ar_cash_receipts_all cr
5954: , hz_cust_site_uses_all su
5955: , hz_cust_acct_sites_all cas
5956: WHERE crh.cash_receipt_id = cr.cash_receipt_id
5957: AND crh.org_id = cr.org_id /* MOAC_SQL_CHANGE */

Line 5994: , ar_cash_receipts_all cr

5990:
5991: CURSOR cust_br_pay_risk (p_curr_code IN VARCHAR2 default NULL) IS
5992: SELECT SUM(NVL(crh.amount,0))
5993: FROM ar_cash_receipt_history crh
5994: , ar_cash_receipts_all cr
5995: , hz_cust_site_uses_all su
5996: , hz_cust_acct_sites_all cas
5997: WHERE crh.cash_receipt_id = cr.cash_receipt_id
5998: AND crh.org_id = cr.org_id /* MOAC_SQL_CHANGE */

Line 6966: , ar_cash_receipts_all cr

6962:
6963: CURSOR site_pay_risk (p_curr_code IN VARCHAR2 default NULL) IS
6964: SELECT SUM(NVL(crh.amount,0))
6965: FROM ar_cash_receipt_history crh
6966: , ar_cash_receipts_all cr
6967: , hz_cust_site_uses_all s
6968: , hz_cust_acct_sites_all a
6969: WHERE crh.cash_receipt_id = cr.cash_receipt_id
6970: AND crh.org_id = cr.org_id

Line 7013: , ar_cash_receipts_all cr

7009:
7010: CURSOR site_br_pay_risk (p_curr_code IN VARCHAR2 default NULL) IS
7011: SELECT SUM(NVL(crh.amount,0))
7012: FROM ar_cash_receipt_history crh
7013: , ar_cash_receipts_all cr
7014: WHERE crh.cash_receipt_id = cr.cash_receipt_id
7015: AND crh.org_id = cr.org_id /* MOAC_SQL_CHANGE */
7016: AND crh.current_record_flag = 'Y'
7017: AND crh.status <> DECODE ( crh.factor_flag

Line 7861: , ar_cash_receipts_ALL cr

7857: /*CURSOR cust_pay_risk_global
7858: (p_curr_code IN VARCHAR2 default NULL) IS
7859: SELECT SUM(NVL(crh.amount,0))
7860: FROM ar_cash_receipt_history_ALL crh
7861: , ar_cash_receipts_ALL cr
7862: , hz_cust_site_uses_ALL su
7863: , hz_cust_acct_sites_ALL cas
7864: WHERE crh.cash_receipt_id = cr.cash_receipt_id
7865: AND (cr.confirmed_flag IS NULL OR cr.confirmed_flag = 'Y')

Line 7899: , ar_cash_receipts_ALL cr

7895: (p_curr_code IN VARCHAR2 default NULL) IS
7896: SELECT SUM(NVL(amount,0)) FROM (
7897: SELECT NVL(crh.amount,0) amount,cr.pay_from_customer,cr.cash_receipt_id
7898: FROM ar_cash_receipt_history_ALL crh
7899: , ar_cash_receipts_ALL cr
7900: , hz_cust_site_uses_ALL su
7901: , hz_cust_acct_sites_ALL cas
7902: WHERE crh.cash_receipt_id = cr.cash_receipt_id
7903: AND (cr.confirmed_flag IS NULL OR cr.confirmed_flag = 'Y')

Line 7934: , ar_cash_receipts_ALL cr

7930: )
7931: UNION
7932: SELECT NVL(crh.amount,0) amount,cr.pay_from_customer,cr.cash_receipt_id
7933: FROM ar_cash_receipt_history_ALL crh
7934: , ar_cash_receipts_ALL cr
7935: WHERE crh.cash_receipt_id = cr.cash_receipt_id
7936: AND (cr.confirmed_flag IS NULL OR cr.confirmed_flag = 'Y')
7937: AND crh.current_record_flag = 'Y'
7938: AND crh.status <> DECODE ( crh.factor_flag

Line 7984: , ar_cash_receipts_ALL cr

7980: CURSOR cust_br_pay_risk_global
7981: (p_curr_code IN VARCHAR2 default NULL) IS
7982: SELECT SUM(NVL(crh.amount,0))
7983: FROM ar_cash_receipt_history_ALL crh
7984: , ar_cash_receipts_ALL cr
7985: , hz_cust_site_uses_ALL su
7986: , hz_cust_acct_sites_ALL cas
7987: WHERE crh.cash_receipt_id = cr.cash_receipt_id
7988: AND (cr.confirmed_flag IS NULL OR cr.confirmed_flag = 'Y')