VIEW: APPS.PA_REP_REQT_PROJS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)