VIEW: APPS.CSM_INCIDENT_SEVERITIES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.INCIDENT_SEVERITY_ID , TL.NAME , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE , B.IMPORTANCE_LEVEL , B.DISPLAY_COLOR , B.RGB_COLOR FROM CS_INCIDENT_SEVERITIES_B B , CS_INCIDENT_SEVERITIES_TL TL , CSM_INCIDENT_SEVERITIES_ACC ACC WHERE B.INCIDENT_SEVERITY_ID = TL.INCIDENT_SEVERITY_ID AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE AND B.INCIDENT_SEVERITY_ID = ACC.INCIDENT_SEVERITY_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.INCIDENT_SEVERITY_ID
, TL.NAME
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.IMPORTANCE_LEVEL
, B.DISPLAY_COLOR
, B.RGB_COLOR
FROM CS_INCIDENT_SEVERITIES_B B
, CS_INCIDENT_SEVERITIES_TL TL
, CSM_INCIDENT_SEVERITIES_ACC ACC
WHERE B.INCIDENT_SEVERITY_ID = TL.INCIDENT_SEVERITY_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND B.INCIDENT_SEVERITY_ID = ACC.INCIDENT_SEVERITY_ID