View: ICX_EDM_MFG_PLAN_V

Product:	ICX - Oracle iProcurement
Description:	Manufacturing Plan Information by Project
Implementation/DBA Data:	APPS.ICX_EDM_MFG_PLAN_V

View Text

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)

Columns