SELECT MD.COMPILE_DESIGNATOR PLAN , MD.DESCRIPTION PLAN_DESCRIPTION , MP.CURR_PLAN_TYPE PLAN_TYPE_CODE , L.MEANING PLAN_TYPE_DESCRIPTION , MD.ORGANIZATION_ID , ORG.NAME ORGANIZATION_NAME , PARA.ORGANIZATION_CODE , MP.PLAN_START_DATE , MP.PLAN_COMPLETION_DATE , MP.CURR_CUTOFF_DATE PLAN_HORIZON , PROJ.PROJECT_ID , TASK.TASK_ID FROM MRP_DESIGNATORS MD , MRP_PLANS MP , HR_ORGANIZATION_UNITS ORG , MTL_PARAMETERS PARA , MFG_LOOKUPS L , PA_PROJECTS_ALL PROJ , PA_TASKS TASK WHERE MD.COMPILE_DESIGNATOR = MP.COMPILE_DESIGNATOR AND MD.ORGANIZATION_ID = MP.ORGANIZATION_ID AND ORG.ORGANIZATION_ID = MD.ORGANIZATION_ID AND PARA.ORGANIZATION_ID = MD.ORGANIZATION_ID AND L.LOOKUP_TYPE(+) = 'MRP_PLAN_TYPE' AND L.LOOKUP_CODE(+) = MP.CURR_PLAN_TYPE AND TASK.PROJECT_ID = PROJ.PROJECT_ID AND EXISTS ( SELECT NULL FROM MRP_RECOMMENDATIONS WHERE PROJECT_ID = PROJ.PROJECT_ID AND TASK_ID = TASK.TASK_ID AND ORGANIZATION_ID = MD.ORGANIZATION_ID AND COMPILE_DESIGNATOR = MD.COMPILE_DESIGNATOR UNION SELECT NULL FROM MRP_GROSS_REQUIREMENTS WHERE PROJECT_ID = PROJ.PROJECT_ID AND TASK_ID = TASK.TASK_ID AND ORGANIZATION_ID = MD.ORGANIZATION_ID AND COMPILE_DESIGNATOR = MD.COMPILE_DESIGNATOR) UNION SELECT MD.COMPILE_DESIGNATOR PLAN , MD.DESCRIPTION PLAN_DESCRIPTION , MP.CURR_PLAN_TYPE PLAN_TYPE_CODE , L.MEANING PLAN_TYPE , MD.ORGANIZATION_ID , ORG.NAME ORGANIZATION_NAME , PARA.ORGANIZATION_CODE , MP.PLAN_START_DATE , MP.PLAN_COMPLETION_DATE , MP.CURR_CUTOFF_DATE PLAN_HORIZON , SEIB.PROJECT_ID , TO_NUMBER(NULL) TASK_ID FROM MRP_DESIGNATORS MD , MRP_PLANS MP , HR_ORGANIZATION_UNITS ORG , MTL_PARAMETERS PARA , MFG_LOOKUPS L , PJM_SEIBAN_NUMBERS SEIB WHERE MD.COMPILE_DESIGNATOR = MP.COMPILE_DESIGNATOR AND MD.ORGANIZATION_ID = MP.ORGANIZATION_ID AND SEIB.OPERATING_UNIT = MD.ORGANIZATION_ID(+) AND ORG.ORGANIZATION_ID = MD.ORGANIZATION_ID AND PARA.ORGANIZATION_ID = MD.ORGANIZATION_ID AND L.LOOKUP_TYPE(+) = 'MRP_PLAN_TYPE' AND L.LOOKUP_CODE(+) = MP.CURR_PLAN_TYPE AND EXISTS ( SELECT NULL FROM MRP_RECOMMENDATIONS WHERE PROJECT_ID = SEIB.PROJECT_ID AND TASK_ID IS NULL AND ORGANIZATION_ID = MD.ORGANIZATION_ID AND COMPILE_DESIGNATOR = MD.COMPILE_DESIGNATOR UNION SELECT NULL FROM MRP_GROSS_REQUIREMENTS WHERE PROJECT_ID = SEIB.PROJECT_ID AND TASK_ID IS NULL AND ORGANIZATION_ID = MD.ORGANIZATION_ID AND COMPILE_DESIGNATOR = MD.COMPILE_DESIGNATOR)