APPS.CTO_FLOW_SCHEDULE dependencies on OE_ORDER_LINES_ALL

Line 114: oe_order_lines_all oel

110: --change the if clause after sajani changes her code
111: SELECT ENABLE_LOWER_LEVEL_SUPPLY,oel.created_by
112: INTO l_mlsupply_parameter,l_created_by --bugfix 2803881
113: FROM bom_parameters bp,
114: oe_order_lines_all oel
115: WHERE oel.line_id = p_config_line_id
116: AND oel.ship_from_org_id = bp.organization_id;
117:
118: --ml supply code

Line 240: from oe_order_lines_all oel

236:
237: l_stmt_num := 90;
238: select inventory_item_id, ship_from_org_id
239: into l_config_item_id, l_org_id
240: from oe_order_lines_all oel
241: where oel.line_id = p_config_line_id;
242:
243: --perf bugfix 4905864 (high shared memory)sql id 14505192(drop4)
244: --replacing mrp_unscheduled_orders_v with query on BOR,wip_line and oe_order_lines_all

Line 244: --replacing mrp_unscheduled_orders_v with query on BOR,wip_line and oe_order_lines_all

240: from oe_order_lines_all oel
241: where oel.line_id = p_config_line_id;
242:
243: --perf bugfix 4905864 (high shared memory)sql id 14505192(drop4)
244: --replacing mrp_unscheduled_orders_v with query on BOR,wip_line and oe_order_lines_all
245: --Verified with Yun.lin
246:
247: l_stmt_num := 95;
248: SELECT wl.LINE_ID

Line 285: FROM oe_order_lines_all

281: l_flow_schedule_rec.organization_id,
282: l_flow_schedule_rec.project_id,
283: l_flow_schedule_rec.scheduled_completion_date,
284: l_flow_schedule_rec.task_id
285: FROM oe_order_lines_all
286: WHERE line_id = p_config_line_id;
287:
288:
289:

Line 480: oe_order_lines_all oel

476: select wfs.line_id, wfs.organization_id, oel.schedule_ship_date,
477: wfs.primary_item_id, wfs.planned_quantity
478: into l_line_id, l_org_id, l_ship_date, l_config_item_id, l_planned_qty
479: from wip_flow_schedules wfs,
480: oe_order_lines_all oel
481: where oel.line_id = to_number(p_config_line_id)
482: and wfs.organization_id = oel.ship_from_org_id
483: and wfs.wip_entity_id = p_wip_entity_id
484: and scheduled_flag = 3;