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 2384: mtl_demand_omoe dem

2380: SELECT NVL(sl.end_item_unit_number, slp.end_item_unit_number)
2381: INTO v_unit_number
2382: FROM so_lines_all sl,
2383: so_lines_all slp,
2384: mtl_demand_omoe dem
2385: WHERE slp.line_id(+) = nvl(sl.parent_line_id,sl.line_id)
2386: AND to_number(dem.demand_source_line) = sl.line_id(+)
2387: AND dem.demand_source_type in (2,8)
2388: AND dem.demand_id = p_demand_id;

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

2388: AND dem.demand_id = p_demand_id;
2389:
2390: ELSE
2391:
2392: /* 1835326 - SCHAUDHA : Removed the join to mtl_demand_omoe as the
2393: query fetched multiple rows for a sales
2394: order line that is reserved against
2395: multiple lots.
2396: */