View: PA_REP_REQT_PROJS_V

Product:	PA - Projects
Description:	pa_rep_asmt_projs_v is a view that shows all projects that has assignments
Implementation/DBA Data:	APPS.PA_REP_REQT_PROJS_V

View Text

SELECT PROJ.PROJECT_ID
, PROJ.NAME PROJECT_NAME
, PROJ.SEGMENT1 PROJECT_NUMBER
, PROJ.NAME || '(' || PROJ.SEGMENT1 || ')'
FROM PA_PROJECTS_ALL PROJ
WHERE PROJ.PROJECT_ID IN (SELECT PROJECT_ID
FROM PA_PROJECT_ASSIGNMENTS ASMT
WHERE PROJ.PROJECT_ID = ASMT.PROJECT_ID
AND ASMT.ASSIGNMENT_TYPE = 'OPEN_ASSIGNMENT'
AND ROWNUM = 1)

Columns