VIEW: APPS.ICX_EDM_KEY_MEMBER_PROJ_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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