VIEW: APPS.PJM_PROJECT_PROJ_V

Source

View Text - Preformatted

SELECT PROJ.PROJECT_ID , PROJ.PROJECT_NUMBER , PROJ.PROJECT_NAME , PROJ.PROJECT_DESCRIPTION , PROJ.START_DATE , PROJ.COMPLETION_DATE , PS.PROJECT_STATUS_NAME , PROJ.PROJECT_TYPE , PROJ.CARRYING_OUT_ORGANIZATION_ID , ORG.NAME , PROJMGR.FULL_NAME , PROJ.OPERATING_UNIT , PROJ.SEIBAN_NUMBER_FLAG FROM PJM_PROJECTS_ALL_OU_V PROJ , HR_ALL_ORGANIZATION_UNITS_TL ORG , PA_PROJECT_STATUSES PS , ( SELECT PLAYER.PROJECT_ID , PLAYER.PERSON_ID , PEOPLE.FULL_NAME FROM PER_ALL_PEOPLE_F PEOPLE , PA_PROJECT_PLAYERS PLAYER WHERE PLAYER.PROJECT_ROLE_TYPE = 'PROJECT MANAGER' AND TRUNC(SYSDATE) BETWEEN PLAYER.START_DATE_ACTIVE AND NVL( PLAYER.END_DATE_ACTIVE , SYSDATE + 1 ) AND PEOPLE.PERSON_ID = PLAYER.PERSON_ID AND TRUNC(SYSDATE) BETWEEN PEOPLE.EFFECTIVE_START_DATE AND PEOPLE.EFFECTIVE_END_DATE ) PROJMGR WHERE ORG.ORGANIZATION_ID (+) = PROJ.CARRYING_OUT_ORGANIZATION_ID AND ORG.LANGUAGE (+) = USERENV('LANG') AND PS.PROJECT_STATUS_CODE(+) = PROJ.PROJECT_STATUS_CODE AND PROJMGR.PROJECT_ID (+) = PROJ.PROJECT_ID

View Text - HTML Formatted

SELECT PROJ.PROJECT_ID
, PROJ.PROJECT_NUMBER
, PROJ.PROJECT_NAME
, PROJ.PROJECT_DESCRIPTION
, PROJ.START_DATE
, PROJ.COMPLETION_DATE
, PS.PROJECT_STATUS_NAME
, PROJ.PROJECT_TYPE
, PROJ.CARRYING_OUT_ORGANIZATION_ID
, ORG.NAME
, PROJMGR.FULL_NAME
, PROJ.OPERATING_UNIT
, PROJ.SEIBAN_NUMBER_FLAG
FROM PJM_PROJECTS_ALL_OU_V PROJ
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, PA_PROJECT_STATUSES PS
, ( SELECT PLAYER.PROJECT_ID
, PLAYER.PERSON_ID
, PEOPLE.FULL_NAME
FROM PER_ALL_PEOPLE_F PEOPLE
, PA_PROJECT_PLAYERS PLAYER
WHERE PLAYER.PROJECT_ROLE_TYPE = 'PROJECT MANAGER'
AND TRUNC(SYSDATE) BETWEEN PLAYER.START_DATE_ACTIVE
AND NVL( PLAYER.END_DATE_ACTIVE
, SYSDATE + 1 )
AND PEOPLE.PERSON_ID = PLAYER.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PEOPLE.EFFECTIVE_START_DATE
AND PEOPLE.EFFECTIVE_END_DATE ) PROJMGR
WHERE ORG.ORGANIZATION_ID (+) = PROJ.CARRYING_OUT_ORGANIZATION_ID
AND ORG.LANGUAGE (+) = USERENV('LANG')
AND PS.PROJECT_STATUS_CODE(+) = PROJ.PROJECT_STATUS_CODE
AND PROJMGR.PROJECT_ID (+) = PROJ.PROJECT_ID