APPS.OE_EXPORT_COMPLIANCE_WF dependencies on OE_ORDER_LINES_ALL

Line 51: from oe_order_lines_all where

47:
48: SAVEPOINT Before_Lock;
49:
50: select top_model_line_id into l_top_model_line_id
51: from oe_order_lines_all where
52: line_id = to_number(itemkey);
53:
54: -- bug 4503620
55: BEGIN

Line 58: from oe_order_lines_all

54: -- bug 4503620
55: BEGIN
56: IF l_top_model_line_id is not null then
57: select '1' into l_dummy
58: from oe_order_lines_all
59: where line_id = l_top_model_line_id
60: for update; --commented for bug 6415831 -- nowait;
61: END IF;
62: EXCEPTION

Line 304: FROM oe_order_lines_all

300: -- MOAC change DBMS_APPLICATION_INFO.Set_Client_Info(l_org_id);
301:
302: SELECT org_id
303: INTO l_org_id
304: FROM oe_order_lines_all
305: WHERE line_id = to_number(itemkey);
306:
307: mo_global.set_policy_context('S', l_org_id);
308:

Line 355: FROM oe_order_lines_all

351:
352: IF l_top_model_line_id IS NOT NULL THEN
353: SELECT '1'
354: INTO l_dummy
355: FROM oe_order_lines_all
356: WHERE line_id = l_top_model_line_id
357: FOR UPDATE
358: --Commented for bug 6415831
359: NOWAIT; -- Uncommented for 8762350

Line 370: FROM oe_order_lines_all

366: -- lock the row
367:
368: SELECT '1'
369: INTO l_dummy
370: FROM oe_order_lines_all
371: WHERE line_id = l_line_id
372: FOR UPDATE
373: --Commented for bug 6415831
374: NOWAIT; -- Uncommented for 8762350