View: PA_REP_RES_PROJECTS_V

Product:	PA - Projects
Description:	PA_REP_RES_PROJECTS_V shows all projects that has resource involved
Implementation/DBA Data:	APPS.PA_REP_RES_PROJECTS_V

View Text

SELECT PROJ.PROJECT_ID
, PROJ.NAME || '(' || PROJ.SEGMENT1 || ')'
, PROJ.NAME
, PROJ.SEGMENT1
FROM PA_PROJECTS_ALL PROJ
WHERE PROJ.PROJECT_ID = (SELECT PROJECT_ID
FROM PA_PROJECT_ASSIGNMENTS ASMT
WHERE PROJ.PROJECT_ID = ASMT.PROJECT_ID
AND ASMT.RESOURCE_ID IS NOT NULL
AND ROWNUM=1)

Columns