APPS.OE_CREDIT_CHECK_UTIL dependencies on AR_CASH_RECEIPT_HISTORY

Line 5744: FROM ar_cash_receipt_history crh

5740: -- PAY AT RISK
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

Line 5785: FROM ar_cash_receipt_history crh

5781:
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

Line 6709: FROM ar_cash_receipt_history crh

6705: -- PAY AT RISK
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

Line 6756: FROM ar_cash_receipt_history crh

6752: AND gl_date_closed = to_date( '31-12-4712', 'DD-MM-YYYY');
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'

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