DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 1449: FROM oe_order_headers_all oh

1445: --Added in R12 by rsu
1446: oh.tax_exempt_reason_code,
1447: oh.tax_point_code
1448: --
1449: FROM oe_order_headers_all oh
1450: WHERE oh.header_id = p_hdr_id;
1451:
1452: CURSOR l_party_csr (l_cust_id NUMBER)
1453: IS

Line 1500: FROM oe_order_headers_all

1496:
1497: CURSOR l_contact_csr (p_hdr_id NUMBER)
1498: IS
1499: SELECT ship_to_contact_id
1500: FROM oe_order_headers_all
1501: WHERE header_id = p_hdr_id;
1502:
1503: l_ord_hdr_rec l_ord_hdr_csr%ROWTYPE;
1504: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

Line 3696: oe_order_headers_all oh -- OKX_ORDER_HEADERS_V OH

3692: oh.invoice_to_contact_id, oh.agreement_id,
3693: oh.invoicing_rule_id, oh.accounting_rule_id
3694: FROM oe_order_lines_all ol -- OKX_ORDER_LINES_V OL
3695: ,
3696: oe_order_headers_all oh -- OKX_ORDER_HEADERS_V OH
3697: WHERE ol.line_id = p_line_id AND ol.header_id = oh.header_id;
3698:
3699: cust_rec cust_csr%ROWTYPE;
3700: order_rec order_csr%ROWTYPE;