[Home] [Help]
228: MR1.INVENTORY_ITEM_ID item_id,
229: WL.LINE_ID
230: FROM MTL_SYSTEM_ITEMS_B KFV,
231: MRP_SYSTEM_ITEMS RSI1,
232: MRP_PLANS MP1,
233: MRP_RECOMMENDATIONS MR1,
234: WIP_LINES WL
235: WHERE MP1.PLAN_COMPLETION_DATE IS NOT NULL
236: AND MP1.DATA_COMPLETION_DATE IS NOT NULL