APPS.MRP_MANAGER_PK dependencies on MTL_DEMAND_OMOE

Line 757: FROM mtl_demand_omoe demand

753:
754:
755: CURSOR MTL_DEMAND_CUR1 IS
756: SELECT demand.rowid
757: FROM mtl_demand_omoe demand
758: WHERE ((EXISTS
759: (SELECT NULL
760: FROM mrp_sales_order_updates updates
761: WHERE updates.sales_order_id = demand.demand_id

Line 2379: mtl_demand_omoe dem

2375: SELECT NVL(sl.end_item_unit_number, slp.end_item_unit_number)
2376: INTO v_unit_number
2377: FROM so_lines_all sl,
2378: so_lines_all slp,
2379: mtl_demand_omoe dem
2380: WHERE slp.line_id(+) = nvl(sl.parent_line_id,sl.line_id)
2381: AND to_number(dem.demand_source_line) = sl.line_id(+)
2382: AND dem.demand_source_type in (2,8)
2383: AND dem.demand_id = p_demand_id;

Line 2387: /* 1835326 - SCHAUDHA : Removed the join to mtl_demand_omoe as the

2383: AND dem.demand_id = p_demand_id;
2384:
2385: ELSE
2386:
2387: /* 1835326 - SCHAUDHA : Removed the join to mtl_demand_omoe as the
2388: query fetched multiple rows for a sales
2389: order line that is reserved against
2390: multiple lots.
2391: */