VIEW: APPS.PA_RES_LEG_DET_V

Source

View Text - Preformatted

SELECT lup.meaning, st.project_status_name FROM pa_lookups lup, pa_project_statuses st WHERE lup.lookup_code = st.project_system_status_code AND lookup_type = ('STAFFED_ASGMT_SYSTEM_STATUS') AND project_system_status_code IN ('STAFFED_ASGMT_CONF', 'STAFFED_ASGMT_PROV') ORDER BY DECODE(st.project_system_status_code,'STAFFED_ASGMT_CONF',1, 'STAFFED_ASGMT_PROV',2, 'OPEN_ASGMT', 3, 'CONFIRMED_ADMIN',4, 'AVAILABLE', 5, 6)

View Text - HTML Formatted

SELECT LUP.MEANING
, ST.PROJECT_STATUS_NAME
FROM PA_LOOKUPS LUP
, PA_PROJECT_STATUSES ST
WHERE LUP.LOOKUP_CODE = ST.PROJECT_SYSTEM_STATUS_CODE
AND LOOKUP_TYPE = ('STAFFED_ASGMT_SYSTEM_STATUS')
AND PROJECT_SYSTEM_STATUS_CODE IN ('STAFFED_ASGMT_CONF'
, 'STAFFED_ASGMT_PROV') ORDER BY DECODE(ST.PROJECT_SYSTEM_STATUS_CODE
, 'STAFFED_ASGMT_CONF'
, 1
, 'STAFFED_ASGMT_PROV'
, 2
, 'OPEN_ASGMT'
, 3
, 'CONFIRMED_ADMIN'
, 4
, 'AVAILABLE'
, 5
, 6)