[Home] [Help]
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
237: AND MP1.COMPILE_DESIGNATOR = MR1.COMPILE_DESIGNATOR