[Home] [Help]
View: PA_REP_ASMT_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_ASMT_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
Name |
PROJECT_ID |
PROJECT_NAME |
PROJECT_NUMBER |
PROJECT_NAME_NUMBER |