APPS.CTO_AUTO_DROPSHIP_PK dependencies on OE_ORDER_LINES_ALL

Line 204: 'from oe_order_lines_all oel, '||

200:
201: drive_mark := 0;
202: sql_stmt := 'INSERT INTO bom_cto_order_lines_temp (line_id, org_id, ship_from_org_id, schedule_ship_date, inventory_item_id) '||
203: 'SELECT oel.line_id, oel.org_id, oel.ship_from_org_id, oel.schedule_ship_date, 1 '||
204: 'from oe_order_lines_all oel, '||
205: ' mtl_system_items msi, '||
206: ' wf_item_activity_statuses was, '||
207: ' wf_process_activities WPA '||
208: 'where oel.inventory_item_id = msi.inventory_item_id '||

Line 265: 'from oe_order_lines_all oelc '||

261: /* Given a Order Line ID */
262: if p_sales_order_line_id is not null then
263: drive_mark := drive_mark + 2;
264: sql_stmt := sql_stmt ||' and oel.line_id in (select oelc.line_id '||
265: 'from oe_order_lines_all oelc '||
266: 'where oelc.ato_line_id = :p_sales_order_line_id '||
267: 'and (oelc.item_type_code = ''CONFIG'' '||
268: --Adding INCLUDED item type code for SUN ER#9793792
269: --' or (oelc.item_type_code in (''STANDARD'',''OPTION'') '||

Line 426: from oe_order_lines_all

422: -- continue processing for the next line
423: savepoint begin_line;
424: begin
425: select line_id into dummy
426: from oe_order_lines_all
427: where line_id = line_id_arr(i)
428: and source_type_code = 'EXTERNAL'
429: and open_flag = 'Y'
430: and booked_flag = 'Y'

Line 454: update oe_order_lines_all

450: end;
451: -- end bug 4384668
452:
453: -- bugfix 3319313: update all lines with the program ID and request_id here.
454: update oe_order_lines_all
455: set program_id = l_program_id,
456: request_id = l_request_id
457: where line_id = line_id_arr(i);
458: