APPS.OE_SCH_CONC_REQUESTS dependencies on OE_ORDER_LINES

Line 205: -- Moac. Changed the below cursor logic to also join to oe_order_lines for OU.

201: l_org_id NUMBER;
202: l_selected_line_tbl OE_GLOBALS.Selected_Record_Tbl; -- R12.MOAC
203: l_failure BOOLEAN := FALSE;
204: l_index NUMBER;
205: -- Moac. Changed the below cursor logic to also join to oe_order_lines for OU.
206: CURSOR wf_item IS
207: SELECT item_key, l.org_id
208: FROM wf_item_activity_statuses wias,
209: wf_process_activities wpa,

Line 210: oe_order_lines l

206: CURSOR wf_item IS
207: SELECT item_key, l.org_id
208: FROM wf_item_activity_statuses wias,
209: wf_process_activities wpa,
210: oe_order_lines l
211: WHERE wias.item_type = 'OEOL'
212: AND wias.process_activity = wpa.instance_id
213: AND wpa.activity_item_type = 'OEOL'
214: AND wpa.activity_name = 'SCHEDULING_ELIGIBLE'

Line 221: FROM oe_order_lines_all

217: Order by l.org_id;
218:
219: CURSOR progress_pto IS
220: SELECT line_id
221: FROM oe_order_lines_all
222: WHERE header_id = l_header_id
223: AND top_model_line_id = l_line_id
224: AND item_type_code in ('MODEL','KIT','CLASS','OPTION')
225: AND ((ato_line_id is not null AND

Line 460: l_stmt := l_stmt || 'FROM oe_order_headers_all H, oe_order_lines L, '

456: -- Moac Changed below cursor to use oe_order_headers_all
457: /*Start MOAC_SQL_CHANGE */
458: l_stmt := 'SELECT H.header_id, L.Line_id, L.org_id ';
459: IF NVL(p_sch_mode, 'LINE_ELIGIBLE') = 'LINE_ELIGIBLE' THEN
460: l_stmt := l_stmt || 'FROM oe_order_headers_all H, oe_order_lines L, '
461: || ' wf_item_activity_statuses wias, wf_process_activities wpa ';
462: ELSE
463: l_stmt := l_stmt || 'FROM oe_order_headers_all H, oe_order_lines L ';
464: END IF;

Line 463: l_stmt := l_stmt || 'FROM oe_order_headers_all H, oe_order_lines L ';

459: IF NVL(p_sch_mode, 'LINE_ELIGIBLE') = 'LINE_ELIGIBLE' THEN
460: l_stmt := l_stmt || 'FROM oe_order_headers_all H, oe_order_lines L, '
461: || ' wf_item_activity_statuses wias, wf_process_activities wpa ';
462: ELSE
463: l_stmt := l_stmt || 'FROM oe_order_headers_all H, oe_order_lines L ';
464: END IF;
465: l_stmt := l_stmt || 'WHERE H.header_id = L.header_id '
466: || 'AND H.org_id = L.org_id '
467: || 'AND H.open_flag = ''Y'''||' AND L.open_flag = ''Y''';

Line 768: FROM oe_order_lines_all L

764: l_link_to_line_id,
765: l_smc_flag,
766: l_item_type_code,
767: l_schedule_status_code
768: FROM oe_order_lines_all L
769: WHERE L.open_flag = 'Y'
770: AND L.line_id = l_line_id;
771:
772: