DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 1453: FROM oe_order_headers_all oh

1449: --Added in R12 by rsu
1450: oh.tax_exempt_reason_code,
1451: oh.tax_point_code
1452: --
1453: FROM oe_order_headers_all oh
1454: WHERE oh.header_id = p_hdr_id;
1455:
1456: CURSOR l_party_csr (l_cust_id NUMBER)
1457: IS

Line 1504: FROM oe_order_headers_all

1500:
1501: CURSOR l_contact_csr (p_hdr_id NUMBER)
1502: IS
1503: SELECT ship_to_contact_id
1504: FROM oe_order_headers_all
1505: WHERE header_id = p_hdr_id;
1506:
1507: l_ord_hdr_rec l_ord_hdr_csr%ROWTYPE;
1508: l_return_status VARCHAR2 (1) := okc_api.g_ret_sts_success;

Line 3742: oe_order_headers_all oh -- OKX_ORDER_HEADERS_V OH

3738: oh.invoice_to_contact_id, oh.agreement_id,
3739: oh.invoicing_rule_id, oh.accounting_rule_id
3740: FROM oe_order_lines_all ol -- OKX_ORDER_LINES_V OL
3741: ,
3742: oe_order_headers_all oh -- OKX_ORDER_HEADERS_V OH
3743: WHERE ol.line_id = p_line_id AND ol.header_id = oh.header_id;
3744:
3745: cust_rec cust_csr%ROWTYPE;
3746: order_rec order_csr%ROWTYPE;