APPS.OE_DS_PVT dependencies on OE_ORDER_LINES_ALL

Line 203: FROM OE_ORDER_LINES_ALL OL,

199: OL.ORG_ID, -- bug 4402566
200: OD.LINE_LOCATION_ID, -- bug 4402566
201: RT.PO_HEADER_ID, -- bug 4402566
202: nvl(OL.SHIPPED_QUANTITY,0) shp_qty
203: FROM OE_ORDER_LINES_ALL OL,
204: OE_DROP_SHIP_SOURCES OD,
205: RCV_TRANSACTIONS RT
206: WHERE OL.LINE_ID = OD.LINE_ID
207: AND OL.SOURCE_TYPE_CODE = 'EXTERNAL'

Line 295: FROM oe_order_lines_all

291: -- Set the Context only for Enhanced Drop Ships.
292: /*
293: SELECT org_id
294: INTO l_so_ou_id
295: FROM oe_order_lines_all
296: WHERE line_id = l_line_id;
297:
298:
299: SELECT pol.org_id

Line 2732: UPDATE oe_order_lines_all

2728: x_part_of_container => l_part_of_container);
2729:
2730: IF l_part_of_container = 'Y' THEN
2731:
2732: UPDATE oe_order_lines_all
2733: SET shipped_quantity = NULL
2734: ,actual_shipment_date = NULL
2735: ,lock_control = lock_control + 1
2736: WHERE top_model_line_id = p_line_rec.top_model_line_id

Line 2754: FROM oe_order_lines_all

2750: END IF;
2751: BEGIN
2752: SELECT max(line_id)
2753: INTO l_new_line_id
2754: FROM oe_order_lines_all
2755: WHERE header_id = p_line_rec.header_id --Bug2489150
2756: AND split_from_line_id = p_line_rec.line_id
2757: AND split_by = 'SYSTEM'; -- Bug-2437391
2758: EXCEPTION