View: ICX_EDM_KEY_MEMBER_PROJ_V

Product:	ICX - Oracle iProcurement
Description:	Project Information Summary View by Key Member
Implementation/DBA Data:	APPS.ICX_EDM_KEY_MEMBER_PROJ_V

View Text

SELECT DISTINCT PLAYER.PROJECT_ID
, PROJ.SEGMENT1 PROJECT_NUMBER
, 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
, PLAYER.PERSON_ID KEY_MEMBER_ID
, KMEM.FULL_NAME KEY_MEMBER_NAME
FROM PA_PROJECT_PLAYERS PLAYER
, PA_PROJECTS_ALL PROJ
, PER_PEOPLE_F KMEM
, HR_ORGANIZATION_UNITS ORG
, PA_PROJECT_STATUSES PS
WHERE PROJ.PROJECT_ID = PLAYER.PROJECT_ID
AND KMEM.PERSON_ID = PLAYER.PERSON_ID
AND PROJ.CARRYING_OUT_ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND PROJ.TEMPLATE_FLAG != 'Y'
AND PS.PROJECT_STATUS_CODE = PROJ.PROJECT_STATUS_CODE

Columns