APPS.OE_SHIPPING_WF dependencies on OE_ORDER_LINES

Line 31: FROM oe_order_lines_all

27: IF G_FREEZE_II = 'PICK RELEASE' THEN
28:
29: SELECT item_type_code,ato_line_id,explosion_date
30: INTO l_item_type,l_ato_line_id,l_explosion_date
31: FROM oe_order_lines_all
32: WHERE line_id = to_number(itemkey);
33:
34: IF l_debug_level > 0 THEN
35: OE_DEBUG_PUB.Add('Item Type:'||l_item_type);

Line 156: FROM oe_order_lines

152: ELSIF l_if = 'Y' THEN
153: BEGIN
154: SELECT NVL(shipped_quantity,0)
155: INTO l_oe_shipped_quantity
156: FROM oe_order_lines
157: WHERE line_id= to_number(itemkey);
158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN
160: IF l_debug_level > 0 THEN

Line 238: FROM oe_order_lines

234: , l_change_sequence
235: , l_source_document_type_id
236: , l_source_document_id
237: , l_source_document_line_id
238: FROM oe_order_lines
239: WHERE line_id = to_number(itemkey);
240: END IF; -- bulk mode or not
241:
242: OE_MSG_PUB.set_msg_context(

Line 273: FROM oe_order_lines_all

269: oe_debug_pub.add( 'BEFORE LOCKING THE TOP LINE '||TO_CHAR ( SYSDATE , 'DD-MM-YYYY HH24:MI:SS' ) , 3 ) ;
270: END IF;
271: SELECT line_id, top_model_line_id
272: INTO l_line_id, l_top_model_line_id
273: FROM oe_order_lines_all
274: WHERE line_id = l_top_model_line_id
275: FOR UPDATE NOWAIT;
276: IF l_debug_level > 0 THEN
277: oe_debug_pub.add( 'TOP LINE LOCKED AT '||TO_CHAR ( SYSDATE , 'DD-MM-YYYY HH24:MI:SS' ) , 3 ) ;

Line 285: FROM oe_order_lines_all

281: --bug 3814076
282: l_itemkey := to_number(itemkey);
283: SELECT line_id
284: INTO l_line_id
285: FROM oe_order_lines_all
286: WHERE line_id = l_itemkey
287: FOR UPDATE NOWAIT;
288:
289: END IF;

Line 352: from oe_order_lines_all

348:
349: resultout := 'COMPLETE';
350: select header_id
351: into l_header_id
352: from oe_order_lines_all
353: where line_id = to_number(itemkey);
354:
355: oe_msg_pub.initialize;
356: oe_msg_pub.set_process_activity(actid);