APPS.MRP_WFS_FORM_FLOW_SCHEDULE dependencies on MRP_RECOMMENDATIONS

Line 2766: MRP_RECOMMENDATIONS MR1,

2762: WL.LINE_ID) alternate_routing_designator
2763: FROM MTL_SYSTEM_ITEMS_B KFV,
2764: MRP_SYSTEM_ITEMS RSI1,
2765: MRP_PLANS MP1,
2766: MRP_RECOMMENDATIONS MR1,
2767: WIP_LINES WL
2768: WHERE MP1.PLAN_COMPLETION_DATE IS NOT NULL
2769: AND MP1.DATA_COMPLETION_DATE IS NOT NULL
2770: AND MP1.COMPILE_DESIGNATOR = MR1.COMPILE_DESIGNATOR

Line 2937: FROM mrp_recommendations

2933: -- Lock the planned order rows so we don't get duplicate
2934: -- flow schedules
2935: SELECT rowid
2936: INTO l_rowid
2937: FROM mrp_recommendations
2938: WHERE rowid = l_rowid
2939: FOR UPDATE of quantity_in_process NOWAIT;
2940:
2941: EXCEPTION