APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_PAYMENTS

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

4632: END IF;
4633:
4634: SELECT NVL(SUM(P.commitment_applied_amount), 0)
4635: INTO l_commitment
4636: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L ,
4637: HZ_CUST_SITE_USES_ALL su,
4638: HZ_CUST_ACCT_SITES_ALL cas,
4639: ra_terms_b t
4640: WHERE h.header_id = p_header_id

Line 4896: FROM OE_PAYMENTS P,

4892: IF OE_Commitment_PVT.Do_Commitment_Sequencing THEN
4893: BEGIN
4894: SELECT NVL(SUM(P.commitment_applied_amount), 0)
4895: INTO l_commitment
4896: FROM OE_PAYMENTS P,
4897: OE_ORDER_HEADERS_ALL H,
4898: OE_ORDER_LINES L,
4899: ra_terms_b t
4900: WHERE h.header_id = p_header_id

Line 5158: oe_payments p

5154: INTO l_commitment
5155: FROM oe_order_lines l,
5156: oe_order_headers_all h,
5157: ra_terms_b t,
5158: oe_payments p
5159: WHERE h.header_id = p_header_id
5160: AND h.org_id = l.org_id /* MOAC_SQL_CHANGE */
5161: AND h.header_id = l.header_id
5162: AND p.header_id = p_header_id

Line 5207: FROM oe_payments p

5203: END IF;
5204:
5205: SELECT SUM(P.prepaid_amount)
5206: INTO l_prepayment
5207: FROM oe_payments p
5208: WHERE p.header_id = p_header_id
5209: AND p.line_id IS NULL;
5210:
5211: END IF; -- prepayment

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

6105: ------------------------------------------------
6106:
6107: Cursor customer_commitment_total (p_curr_code IN VARCHAR2 default NULL) IS
6108: SELECT NVL(SUM(P.commitment_applied_amount), 0)
6109: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L
6110: , hz_cust_site_uses_all su
6111: , hz_cust_acct_sites_all cas
6112: WHERE H.invoice_to_org_id = su.site_use_id
6113: AND h.org_id = su.org_id

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

6136: OR
6137: (l.payment_type_code IS NULL AND h.payment_type_code IS NULL));
6138: Cursor site_commitment_total (p_curr_code IN VARCHAR2 default NULL) IS
6139: SELECT NVL(SUM(P.commitment_applied_amount), 0)
6140: FROM OE_PAYMENTS P, OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES L
6141: WHERE H.INVOICE_TO_ORG_ID = p_site_use_id
6142: AND H.TRANSACTIONAL_CURR_CODE = p_curr_code
6143: AND H.OPEN_FLAG = 'Y'
6144: AND H.BOOKED_FLAG = 'Y'

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

8088:
8089: -------------------------------------------------
8090: ------- commitments -- Exiting code enhancement
8091: ------------------------------------------------
8092: -------- There is no multi org table for OE_PAYMENTS_ALL
8093:
8094: Cursor cust_commitment_total_global
8095: (p_curr_code IN VARCHAR2 default NULL) IS
8096: SELECT NVL(SUM(P.commitment_applied_amount), 0)

Line 8097: FROM OE_PAYMENTS P

8093:
8094: Cursor cust_commitment_total_global
8095: (p_curr_code IN VARCHAR2 default NULL) IS
8096: SELECT NVL(SUM(P.commitment_applied_amount), 0)
8097: FROM OE_PAYMENTS P
8098: , OE_ORDER_HEADERS_ALL H
8099: , OE_ORDER_LINES_ALL L
8100: , hz_cust_site_uses_ALL su
8101: , hz_cust_acct_sites_ALL cas