APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_PAYMENTS

Line 4478: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L ,

4474: END IF;
4475:
4476: SELECT NVL(SUM(P.commitment_applied_amount), 0)
4477: INTO l_commitment
4478: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L ,
4479: HZ_CUST_SITE_USES_ALL su,
4480: HZ_CUST_ACCT_SITES_ALL cas,
4481: ra_terms_b t
4482: WHERE h.header_id = p_header_id

Line 4725: FROM OE_PAYMENTS P,

4721: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN
4722: BEGIN
4723: SELECT NVL(SUM(P.commitment_applied_amount), 0)
4724: INTO l_commitment
4725: FROM OE_PAYMENTS P,
4726: OE_ORDER_HEADERS_ALL H,
4727: OE_ORDER_LINES L,
4728: ra_terms_b t
4729: WHERE h.header_id = p_header_id

Line 4974: oe_payments p

4970: INTO l_commitment
4971: FROM oe_order_lines l,
4972: oe_order_headers_all h,
4973: ra_terms_b t,
4974: oe_payments p
4975: WHERE h.header_id = p_header_id
4976: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
4977: AND h.header_id = l.header_id
4978: AND p.header_id = p_header_id

Line 5022: FROM oe_payments p

5018: END IF;
5019:
5020: SELECT SUM(P.prepaid_amount)
5021: INTO l_prepayment
5022: FROM oe_payments p
5023: WHERE p.header_id = p_header_id
5024: AND p.line_id IS NULL;
5025:
5026: END IF; -- prepayment

Line 5901: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L

5897: ------------------------------------------------
5898:
5899: Cursor customer_commitment_total (p_curr_code IN VARCHAR2 default NULL) IS
5900: SELECT NVL(SUM(P.commitment_applied_amount), 0)
5901: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L
5902: , hz_cust_site_uses_all su
5903: , hz_cust_acct_sites_all cas
5904: WHERE H.invoice_to_org_id = su.site_use_id
5905: AND h.org_id = su.org_id

Line 5932: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L

5928: OR
5929: (l.payment_type_code IS NULL AND h.payment_type_code IS NULL));
5930: Cursor site_commitment_total (p_curr_code IN VARCHAR2 default NULL) IS
5931: SELECT NVL(SUM(P.commitment_applied_amount), 0)
5932: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L
5933: WHERE H.INVOICE_TO_ORG_ID = p_site_use_id
5934: AND H.TRANSACTIONAL_CURR_CODE = p_curr_code
5935: AND H.OPEN_FLAG = 'Y'
5936: AND H.BOOKED_FLAG = 'Y'

Line 7787: -------- There is no multi org table for OE_PAYMENTS_ALL

7783:
7784: -------------------------------------------------
7785: ------- commitments -- Exiting code enhancement
7786: ------------------------------------------------
7787: -------- There is no multi org table for OE_PAYMENTS_ALL
7788:
7789: Cursor cust_commitment_total_global
7790: (p_curr_code IN VARCHAR2 default NULL) IS
7791: SELECT NVL(SUM(P.commitment_applied_amount), 0)

Line 7792: FROM OE_PAYMENTS P

7788:
7789: Cursor cust_commitment_total_global
7790: (p_curr_code IN VARCHAR2 default NULL) IS
7791: SELECT NVL(SUM(P.commitment_applied_amount), 0)
7792: FROM OE_PAYMENTS P
7793: , OE_ORDER_HEADERS_ALL H
7794: , OE_ORDER_LINES_ALL L
7795: , hz_cust_site_uses_ALL su
7796: , hz_cust_acct_sites_ALL cas