VIEW: APPS.ICX_EDM_MFG_PLAN_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)