View: PA_REP_ASMT_SCH_STATUS_V

Product:	PA - Projects
Description:	pa_rep_asmt_sch_status_v is a view that shows all schedule statuses for existing assignments
Implementation/DBA Data:	APPS.PA_REP_ASMT_SCH_STATUS_V

View Text

SELECT PS.PROJECT_STATUS_CODE
, PS.PROJECT_STATUS_NAME
FROM PA_PROJECT_STATUSES PS
WHERE PS.PROJECT_STATUS_CODE IN ( SELECT STATUS_CODE
FROM PA_PROJECT_ASSIGNMENTS ASMT
WHERE PS.PROJECT_STATUS_CODE = ASMT.STATUS_CODE
AND ASMT.ASSIGNMENT_TYPE <> 'OPEN_ASSIGNMENT'
AND ROWNUM = 1) UNION ALL SELECT ASMT.STATUS_CODE
, PL.MEANING
FROM PA_PROJECT_ASSIGNMENTS ASMT
, PA_LOOKUPS PL
WHERE ASMT.MULTIPLE_STATUS_FLAG = 'Y'
AND ASMT.ASSIGNMENT_TYPE <> 'OPEN_ASSIGNMENT'
AND PL.LOOKUP_TYPE = 'MULTIPLE_STATUS_TEXT'
AND PL.LOOKUP_CODE = 'MULTIPLE'
AND ROWNUM = 1

Columns