DBA Data[Home] [Help]

APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKX_ORDER_LINES_V

Line 93: FROM okx_order_lines_v ol

89: -- Cursor for getting the Order header id for a order line
90: CURSOR l_ord_csr
91: IS
92: SELECT header_id
93: FROM okx_order_lines_v ol
94: WHERE ol.id1 = p_order_line_id;
95:
96: l_ord_hdr_id NUMBER;
97: BEGIN

Line 3740: FROM oe_order_lines_all ol -- OKX_ORDER_LINES_V OL

3736: IS
3737: SELECT ol.header_id, oh.transactional_curr_code, oh.cust_po_number,
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: