View: PA_RES_LEG_DET_V

Product:	PA - Projects
Description:	The purpose of this view is to provide the legend details for the resource schedules and resource assignments / requirements timeline
Implementation/DBA Data:	APPS.PA_RES_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 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)

Columns