DBA Data[Home] [Help]

APPS.OKS_IBINT_PUB dependencies on OKX_ORDER_LINES_V

Line 243: Select Header_id from OKX_ORDER_LINES_V

239:
240: Function get_order_header_id (p_order_line_id Number) Return Number
241: Is
242: Cursor l_header_csr Is
243: Select Header_id from OKX_ORDER_LINES_V
244: Where Id1 = p_order_line_id;
245:
246: l_header_id NUMBER;
247:

Line 397: From OKX_ORDER_LINES_V

393: And OD.order_line_id1 = to_char(p_line_id); -- Bug Fix #4896051
394:
395: Cursor l_Qty_csr(p_id Number) Is
396: Select fulfilled_quantity
397: From OKX_ORDER_LINES_V
398: Where Id1 = p_id;
399:
400: -- warranty consolidation
401: -- cursor to get chr_id of existing warranty contract for an order. vigandhi