DBA Data[Home] [Help]

APPS.XNB_SALES_ORDER_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 1200: FROM oe_order_headers_all head,

1196:
1197: CURSOR l_line_ids (p_order_num NUMBER)
1198: IS
1199: SELECT line.line_id
1200: FROM oe_order_headers_all head,
1201: oe_order_lines_all line,
1202: mtl_system_items_vl item
1203: WHERE head.order_number = p_order_num
1204: AND head.header_id = line.header_id

Line 1546: FROM oe_order_headers_all head,

1542:
1543: CURSOR l_line_ids (p_order_num NUMBER)
1544: IS
1545: SELECT line_id
1546: FROM oe_order_headers_all head,
1547: oe_order_lines_all line
1548: WHERE head.header_id = line.header_id
1549: AND head.order_number = p_order_num;
1550: