View: ICX_EDM_PLANNER_PROJ_V

Product:	ICX - Oracle iProcurement
Description:	Project Information Summary View by Planner
Implementation/DBA Data:	APPS.ICX_EDM_PLANNER_PROJ_V

View Text

SELECT DISTINCT POD.PROJECT_ID
, PROJ.SEGMENT1 PROJECT_NUMBER
, PROJ.NAME PROJECT_NAME
, PROJ.DESCRIPTION
, PROJ.CARRYING_OUT_ORGANIZATION_ID ORGANIZATION_ID
, ORG.NAME ORGANIZATION_NAME
, NULL
, PROJ.PROJECT_TYPE
, PROJ.PROJECT_STATUS_CODE
, PS.PROJECT_STATUS_NAME
, PROJ.START_DATE
, PROJ.COMPLETION_DATE
, NULL
, PLANNER.EMPLOYEE_ID
, PLANEMP.FULL_NAME
FROM PO_DISTRIBUTIONS POD
, PO_LINES POL
, MTL_SYSTEM_ITEMS ITEM
, MTL_PLANNERS PLANNER
, PA_PROJECTS_ALL PROJ
, HR_ORGANIZATION_UNITS ORG
, PA_PROJECT_STATUSES PS
, PER_PEOPLE_F PLANEMP
WHERE POL.PO_LINE_ID = POD.PO_LINE_ID
AND ITEM.INVENTORY_ITEM_ID = POL.ITEM_ID
AND PLANNER.PLANNER_CODE = ITEM.PLANNER_CODE
AND PLANNER.ORGANIZATION_ID = ITEM.ORGANIZATION_ID
AND PROJ.PROJECT_ID = POD.PROJECT_ID
AND ORG.ORGANIZATION_ID = PROJ.CARRYING_OUT_ORGANIZATION_ID
AND PLANEMP.PERSON_ID (+) = PLANNER.EMPLOYEE_ID
AND PROJ.TEMPLATE_FLAG != 'Y'
AND PS.PROJECT_STATUS_CODE = PROJ.PROJECT_STATUS_CODE UNION SELECT DISTINCT WDJ.PROJECT_ID
, PROJ.SEGMENT1
, PROJ.NAME PROJECT_NAME
, PROJ.DESCRIPTION PROJECT_DESCRIPTION
, PROJ.CARRYING_OUT_ORGANIZATION_ID ORGANIZATION_ID
, ORG.NAME ORGANIZATION_NAME
, NULL
, PROJ.PROJECT_TYPE
, PROJ.PROJECT_STATUS_CODE PROJECT_STATUS
, PS.PROJECT_STATUS_NAME
, PROJ.START_DATE PROJECT_START_DATE
, PROJ.COMPLETION_DATE PROJECT_END_DATE
, NULL
, PLANNER.EMPLOYEE_ID PLANNER_EMPLOYEE_ID
, PLANEMP.FULL_NAME
FROM WIP_DISCRETE_JOBS WDJ
, MTL_SYSTEM_ITEMS ITEM
, MTL_PLANNERS PLANNER
, PA_PROJECTS_ALL PROJ
, HR_ORGANIZATION_UNITS ORG
, PA_PROJECT_STATUSES PS
, PER_PEOPLE_F PLANEMP
WHERE ITEM.INVENTORY_ITEM_ID = WDJ.PRIMARY_ITEM_ID
AND PLANNER.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND ITEM.PLANNER_CODE = PLANNER.PLANNER_CODE
AND ITEM.ORGANIZATION_ID = PLANNER.ORGANIZATION_ID
AND WDJ.PROJECT_ID = PROJ.PROJECT_ID
AND ORG.ORGANIZATION_ID = PROJ.CARRYING_OUT_ORGANIZATION_ID
AND PLANEMP.PERSON_ID (+) = PLANNER.EMPLOYEE_ID
AND PROJ.TEMPLATE_FLAG != 'Y'
AND PS.PROJECT_STATUS_CODE = PROJ.PROJECT_STATUS_CODE UNION SELECT DISTINCT PRD.PROJECT_ID
, PROJ.SEGMENT1
, PROJ.NAME PROJECT_NAME
, PROJ.DESCRIPTION PROJECT_DESCRIPTION
, PROJ.CARRYING_OUT_ORGANIZATION_ID ORGANIZATION_ID
, ORG.NAME ORGANIZATION_NAME
, NULL
, PROJ.PROJECT_TYPE
, PROJ.PROJECT_STATUS_CODE PROJECT_STATUS
, PS.PROJECT_STATUS_NAME
, PROJ.START_DATE PROJECT_START_DATE
, PROJ.COMPLETION_DATE PROJECT_END_DATE
, NULL
, PLANNER.EMPLOYEE_ID PLANNER_EMPLOYEE_ID
, PLANEMP.FULL_NAME
FROM PO_REQ_DISTRIBUTIONS PRD
, PO_REQUISITION_LINES PRL
, MTL_SYSTEM_ITEMS ITEM
, MTL_PLANNERS PLANNER
, PA_PROJECTS_ALL PROJ
, HR_ORGANIZATION_UNITS ORG
, PA_PROJECT_STATUSES PS
, PER_PEOPLE_F PLANEMP
WHERE PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
AND ITEM.INVENTORY_ITEM_ID = PRL.ITEM_ID
AND PLANNER.PLANNER_CODE = ITEM.PLANNER_CODE
AND PLANNER.ORGANIZATION_ID = ITEM.ORGANIZATION_ID
AND PROJ.PROJECT_ID = PRD.PROJECT_ID
AND ORG.ORGANIZATION_ID = PROJ.CARRYING_OUT_ORGANIZATION_ID
AND PLANEMP.PERSON_ID (+) = PLANNER.EMPLOYEE_ID
AND PROJ.TEMPLATE_FLAG != 'Y'
AND PS.PROJECT_STATUS_CODE = PROJ.PROJECT_STATUS_CODE UNION SELECT DISTINCT POD.PROJECT_ID
, SEIB.PROJECT_NUMBER
, SEIB.PROJECT_NAME
, SEIB.PROJECT_NAME PROJECT_DESCRIPTION
, SEIB.OPERATING_UNIT ORGANIZATION_ID
, ORG.NAME ORGANIZATION_NAME
, NULL
, TO_CHAR(NULL) PROJECT_TYPE
, TO_CHAR(NULL) PROJECT_STATUS
, TO_CHAR(NULL) PROJECT_STATUS_DSP
, TO_DATE(NULL) PROJECT_START_DATE
, TO_DATE(NULL) PROJECT_END_DATE
, TO_CHAR(NULL) LAST_ACCUMULATED_PERIOD
, PLANNER.EMPLOYEE_ID PLANNER_EMPLOYEE_ID
, PLANEMP.FULL_NAME
FROM PO_DISTRIBUTIONS POD
, PO_LINES POL
, MTL_SYSTEM_ITEMS ITEM
, MTL_PLANNERS PLANNER
, PJM_SEIBAN_NUMBERS SEIB
, HR_ORGANIZATION_UNITS ORG
, PER_PEOPLE_F PLANEMP
WHERE POL.PO_LINE_ID = POD.PO_LINE_ID
AND ORG.ORGANIZATION_ID(+) = SEIB.OPERATING_UNIT
AND ITEM.INVENTORY_ITEM_ID = POL.ITEM_ID
AND PLANNER.PLANNER_CODE = ITEM.PLANNER_CODE
AND PLANNER.ORGANIZATION_ID = ITEM.ORGANIZATION_ID
AND SEIB.PROJECT_ID = POD.PROJECT_ID
AND PLANEMP.PERSON_ID (+) = PLANNER.EMPLOYEE_ID UNION SELECT DISTINCT WDJ.PROJECT_ID
, SEIB.PROJECT_NUMBER
, SEIB.PROJECT_NAME
, SEIB.PROJECT_NAME PROJECT_DESCRIPTION
, SEIB.OPERATING_UNIT ORGANIZATION_ID
, ORG.NAME ORGANIZATION_NAME
, NULL
, TO_CHAR(NULL) PROJECT_TYPE
, TO_CHAR(NULL) PROJECT_STATUS
, TO_CHAR(NULL) PROJECT_STATUS_DSP
, TO_DATE(NULL) PROJECT_START_DATE
, TO_DATE(NULL) PROJECT_END_DATE
, TO_CHAR(NULL) LAST_ACCUMULATED_PERIOD
, PLANNER.EMPLOYEE_ID PLANNER_EMPLOYEE_ID
, PLANEMP.FULL_NAME
FROM WIP_DISCRETE_JOBS WDJ
, MTL_SYSTEM_ITEMS ITEM
, MTL_PLANNERS PLANNER
, PJM_SEIBAN_NUMBERS SEIB
, HR_ORGANIZATION_UNITS ORG
, PER_PEOPLE_F PLANEMP
WHERE ITEM.INVENTORY_ITEM_ID = WDJ.PRIMARY_ITEM_ID
AND ORG.ORGANIZATION_ID = SEIB.OPERATING_UNIT
AND PLANNER.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND ITEM.PLANNER_CODE = PLANNER.PLANNER_CODE
AND ITEM.ORGANIZATION_ID = PLANNER.ORGANIZATION_ID
AND SEIB.PROJECT_ID = WDJ.PROJECT_ID
AND PLANEMP.PERSON_ID (+) = PLANNER.EMPLOYEE_ID UNION SELECT DISTINCT PRD.PROJECT_ID
, SEIB.PROJECT_NUMBER
, SEIB.PROJECT_NAME
, SEIB.PROJECT_NAME PROJECT_DESCRIPTION
, SEIB.OPERATING_UNIT ORGANIZATION_ID
, ORG.NAME ORGANIZATION_NAME
, NULL
, TO_CHAR(NULL) PROJECT_TYPE
, TO_CHAR(NULL) PROJECT_STATUS
, TO_CHAR(NULL) PROJECT_STATUS_DSP
, TO_DATE(NULL) PROJECT_START_DATE
, TO_DATE(NULL) PROJECT_END_DATE
, TO_CHAR(NULL) LAST_ACCUMULATED_PERIOD
, PLANNER.EMPLOYEE_ID PLANNER_EMPLOYEE_ID
, PLANEMP.FULL_NAME
FROM PO_REQ_DISTRIBUTIONS PRD
, PO_REQUISITION_LINES PRL
, MTL_SYSTEM_ITEMS ITEM
, MTL_PLANNERS PLANNER
, PJM_SEIBAN_NUMBERS SEIB
, HR_ORGANIZATION_UNITS ORG
, PER_PEOPLE_F PLANEMP
WHERE PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
AND ITEM.INVENTORY_ITEM_ID = PRL.ITEM_ID
AND ORG.ORGANIZATION_ID = SEIB.OPERATING_UNIT
AND PLANNER.PLANNER_CODE = ITEM.PLANNER_CODE
AND PLANNER.ORGANIZATION_ID = ITEM.ORGANIZATION_ID
AND SEIB.PROJECT_ID = PRD.PROJECT_ID
AND PLANEMP.PERSON_ID (+) = PLANNER.EMPLOYEE_ID

Columns