DBA Data[Home] [Help]

APPS.OE_SCH_CONC_REQUESTS dependencies on OE_ORDER_LINES_ALL

Line 278: FROM oe_order_lines_all

274: Order by l.org_id;
275:
276: CURSOR progress_pto IS
277: SELECT line_id
278: FROM oe_order_lines_all
279: WHERE header_id = l_header_id
280: AND top_model_line_id = l_line_id
281: AND item_type_code in ('MODEL','KIT','CLASS','OPTION')
282: AND ((ato_line_id is not null AND

Line 508: FROM oe_order_lines_all

504: --Lock the line first
505: BEGIN
506: SELECT line_id
507: INTO l_locked_line_id
508: FROM oe_order_lines_all
509: WHERE line_id = to_number(l_wf_item_rec(K).ITEM_KEY)
510: FOR UPDATE NOWAIT;
511:
512: wf_engine.CompleteActivityInternalName

Line 926: FROM oe_order_lines_all L

922: l_link_to_line_id,
923: l_smc_flag,
924: l_item_type_code,
925: l_schedule_status_code
926: FROM oe_order_lines_all L
927: WHERE L.open_flag = 'Y'
928: AND L.line_id = l_line_id;
929:
930:

Line 960: FROM oe_order_lines_all

956: -- Lock the record before processing
957: BEGIN
958: SELECT line_id
959: INTO l_locked_line_id
960: FROM oe_order_lines_all
961: WHERE line_id = l_line_id
962: FOR UPDATE NOWAIT;
963: wf_engine.CompleteActivityInternalName ('OEOL',
964: to_char(l_line_id),