VIEW: APPS.PA_REP_ASMT_SCH_STATUS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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