VIEW: APPS.BIV_STATUSES_V

Source

View Text - Preformatted

SELECT b.incident_status_id as ID , t.name as VALUE from cs_incident_statuses_b b , cs_incident_statuses_tl t WHERE b.incident_status_id = t.incident_status_id and b.incident_subtype = 'INC' and t.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.INCIDENT_STATUS_ID AS ID
, T.NAME AS VALUE
FROM CS_INCIDENT_STATUSES_B B
, CS_INCIDENT_STATUSES_TL T
WHERE B.INCIDENT_STATUS_ID = T.INCIDENT_STATUS_ID
AND B.INCIDENT_SUBTYPE = 'INC'
AND T.LANGUAGE = USERENV('LANG')