APPS.OE_DS_PVT dependencies on OE_ORDER_LINES_ALL

Line 200: FROM OE_ORDER_LINES_ALL OL,

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

Line 290: FROM oe_order_lines_all

286: -- Set the Context only for Enhanced Drop Ships.
287: /*
288: SELECT org_id
289: INTO l_so_ou_id
290: FROM oe_order_lines_all
291: WHERE line_id = l_line_id;
292:
293:
294: SELECT pol.org_id

Line 2692: UPDATE oe_order_lines_all

2688: x_part_of_container => l_part_of_container);
2689:
2690: IF l_part_of_container = 'Y' THEN
2691:
2692: UPDATE oe_order_lines_all
2693: SET shipped_quantity = NULL
2694: ,actual_shipment_date = NULL
2695: ,lock_control = lock_control + 1
2696: WHERE top_model_line_id = p_line_rec.top_model_line_id

Line 2714: FROM oe_order_lines_all

2710: END IF;
2711: BEGIN
2712: SELECT max(line_id)
2713: INTO l_new_line_id
2714: FROM oe_order_lines_all
2715: WHERE header_id = p_line_rec.header_id --Bug2489150
2716: AND split_from_line_id = p_line_rec.line_id
2717: AND split_by = 'SYSTEM'; -- Bug-2437391
2718: EXCEPTION