View: PA_RES_ASGN_LEGEND_V

Product:	PA - Projects
Description:	The purpose of this view is to provide a legend for the resource assignments / requirements timeline
Implementation/DBA Data:	APPS.PA_RES_ASGN_LEGEND_V

View Text

SELECT LOOKUP_CODE
, COLOR_PATTERN_CODE
, FILE_NAME
, STATUS_NAME
FROM ( SELECT TC.LOOKUP_CODE LOOKUP_CODE
, TC.COLOR_PATTERN_CODE COLOR_PATTERN_CODE
, TC.FILE_NAME FILE_NAME
, LUP.MEANING STATUS_NAME
FROM PA_TIMELINE_COLORS TC
, PA_LOOKUPS LUP
WHERE TC.LOOKUP_CODE = LUP.LOOKUP_CODE
AND LUP.LOOKUP_TYPE IN ('STAFFED_ASGMT_SYSTEM_STATUS') UNION SELECT TC.LOOKUP_CODE
, TC.COLOR_PATTERN_CODE
, TC.FILE_NAME
, LUP.MEANING STATUS_NAME
FROM PA_TIMELINE_COLORS TC
, PA_LOOKUPS LUP
WHERE TC.LOOKUP_CODE IN('AVAILABLE'
, 'OVERCOMMITTED')
AND TC.LOOKUP_CODE = LUP.LOOKUP_CODE
AND LUP.LOOKUP_TYPE IN ('TIMELINE_STATUS') UNION SELECT TC.LOOKUP_CODE LOOKUP_CODE
, TC.COLOR_PATTERN_CODE
, TC.FILE_NAME
, LUP.MEANING STATUS_NAME
FROM PA_TIMELINE_COLORS TC
, PA_LOOKUPS LUP
WHERE TC.LOOKUP_CODE IN('CONFIRMED_ADMIN')
AND LUP.LOOKUP_CODE = TC.LOOKUP_CODE
AND LUP.LOOKUP_TYPE IN ('TIMELINE_STATUS') UNION SELECT TC.LOOKUP_CODE
, TC.COLOR_PATTERN_CODE
, TC.FILE_NAME
, NULL STATUS_NAME
FROM PA_TIMELINE_COLORS TC
WHERE TC.LOOKUP_CODE IN('NON_WORKING') ) ORDER BY DECODE(LOOKUP_CODE
, 'OVERCOMMITTED'
, 1
, 'CONFIRMED_ADMIN'
, 2
, 'STAFFED_ASGMT_CONF'
, 3
, 'STAFFED_ASGMT_PROV'
, 4
, 'OPEN_ASGMT'
, 5
, 'AVAILABLE'
, 6
, 7)

Columns