VIEW: APPS.OKX_INCIDENT_SEVERITS_V

Source

View Text - Preformatted

SELECT B.INCIDENT_SEVERITY_ID ID1, '#' ID2, B.INCIDENT_SUBTYPE INCIDENT_SUBTYPE, B.START_DATE_ACTIVE START_DATE_ACTIVE, B.END_DATE_ACTIVE END_DATE_ACTIVE, DECODE(SIGN(trunc(sysdate)-NVL(b.start_date_active,trunc(sysdate))),-1,'I', DECODE(SIGN(trunc(sysdate) - NVL(b.end_date_active,trunc(sysdate))), 1,'I','A')) STATUS, T.DESCRIPTION DESCRIPTION, T.NAME NAME FROM CS_INCIDENT_SEVERITIES_B B,CS_INCIDENT_SEVERITIES_TL T WHERE B.INCIDENT_SEVERITY_ID=T.INCIDENT_SEVERITY_ID AND T.LANGUAGE=userenv('LANG')

View Text - HTML Formatted

SELECT B.INCIDENT_SEVERITY_ID ID1
, '#' ID2
, B.INCIDENT_SUBTYPE INCIDENT_SUBTYPE
, B.START_DATE_ACTIVE START_DATE_ACTIVE
, B.END_DATE_ACTIVE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(B.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(B.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, T.DESCRIPTION DESCRIPTION
, T.NAME NAME
FROM CS_INCIDENT_SEVERITIES_B B
, CS_INCIDENT_SEVERITIES_TL T
WHERE B.INCIDENT_SEVERITY_ID=T.INCIDENT_SEVERITY_ID
AND T.LANGUAGE=USERENV('LANG')