APPS.OE_RSCH_SETS_CONC_REQUESTS dependencies on OE_ORDER_LINES

Line 75: -- of included_items in the oe_order_lines table.

71: p_x_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_KIT) THEN
72:
73: -- Calling Process_Included_Items. This procedure
74: -- will take care of exploding and updating the picture
75: -- of included_items in the oe_order_lines table.
76:
77: l_return_status := OE_CONFIG_UTIL.Process_Included_Items
78: (p_line_rec => p_x_line_tbl(I),
79: p_freeze => FALSE,

Line 268: ,oe_order_lines_all l

264: /* MOAC_SQL_CHANGE */
265: CURSOR Line_Set(l_start_date DATE,l_end_date DATE) IS
266: SELECT distinct l.ship_set_id, h.order_number
267: FROM oe_order_headers h
268: ,oe_order_lines_all l
269: , oe_sets s
270: WHERE h.order_number >= nvl(p_order_number_low,h.order_number)
271: AND h.order_number <= nvl(p_order_number_high,h.order_number)
272: AND h.header_id = l.header_id

Line 287: FROM oe_order_lines l

283: ORDER BY l.ship_set_id ;
284:
285: CURSOR Lock_Lines_in_set(l_ship_set_id NUMBER) IS
286: SELECT l.line_id
287: FROM oe_order_lines l
288: WHERE l.ship_set_id = l_ship_set_id
289: FOR UPDATE;
290:
291: CURSOR Get_Set_Name IS