VIEW: APPS.PA_RES_SCH_LEGEND_V

Source

View Text - Preformatted

SELECT lookup_code , color_pattern_code , file_name , status_name FROM ( 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 = lup.lookup_code AND lup.lookup_type IN ('STAFFED_ASGMT_SYSTEM_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','AVAILABLE', 'OVERCOMMITTED') AND lup.lookup_code = tc.lookup_code AND lup.lookup_type IN ('TIMELINE_STATUS') UNION SELECT tc.lookup_code 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)

View Text - HTML Formatted

SELECT LOOKUP_CODE
, COLOR_PATTERN_CODE
, FILE_NAME
, STATUS_NAME
FROM ( 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 = LUP.LOOKUP_CODE
AND LUP.LOOKUP_TYPE IN ('STAFFED_ASGMT_SYSTEM_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'
, 'AVAILABLE'
, 'OVERCOMMITTED')
AND LUP.LOOKUP_CODE = TC.LOOKUP_CODE
AND LUP.LOOKUP_TYPE IN ('TIMELINE_STATUS') UNION SELECT TC.LOOKUP_CODE 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)