VIEW: APPS.BIV_SEVERITIES_V

Source

View Text - Preformatted

SELECT b.incident_severity_id as ID , t.name as VALUE , b.importance_level from cs_incident_severities_b b , cs_incident_severities_tl t WHERE b.incident_severity_id = t.incident_severity_id and b.incident_subtype = 'INC' and t.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.INCIDENT_SEVERITY_ID AS ID
, T.NAME AS VALUE
, B.IMPORTANCE_LEVEL
FROM CS_INCIDENT_SEVERITIES_B B
, CS_INCIDENT_SEVERITIES_TL T
WHERE B.INCIDENT_SEVERITY_ID = T.INCIDENT_SEVERITY_ID
AND B.INCIDENT_SUBTYPE = 'INC'
AND T.LANGUAGE = USERENV('LANG')