View: PA_PROJ_ASGN_LEG_DET_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PROJ_ASGN_LEG_DET_V

View Text

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 PROJECT_SYSTEM_STATUS_CODE IN ('OPEN_ASGMT'
, 'STAFFED_ASGMT_CONF'
, 'STAFFED_ASGMT_PROV')
AND LOOKUP_TYPE IN ('STAFFED_ASGMT_SYSTEM_STATUS'
, 'OPEN_ASGMT_SYSTEM_STATUS') 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)

Columns