View: BIL_DIMV_SRV_SVTYS

Product:	BIL - Sales Intelligence
Description:	Service incident severities view
Implementation/DBA Data:	APPS.BIL_DIMV_SRV_SVTYS

View Text

SELECT CISB.INCIDENT_SEVERITY_ID
, CIST.NAME
, CIST.DESCRIPTION
, CISB.IMPORTANCE_LEVEL
, CISB.INCIDENT_SUBTYPE
, CISB.START_DATE_ACTIVE
, CISB.END_DATE_ACTIVE
, TO_CHAR( CISB.INCIDENT_SEVERITY_ID) ID
, CIST.NAME
FROM CS_INCIDENT_SEVERITIES_B CISB
, CS_INCIDENT_SEVERITIES_TL CIST
WHERE CISB. INCIDENT_SUBTYPE = 'INC'
AND TRUNC(SYSDATE) BETWEEN NVL(CISB.START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(CISB.END_DATE_ACTIVE
, TRUNC(SYSDATE))
AND CISB.INCIDENT_SEVERITY_ID = CIST.INCIDENT_SEVERITY_ID
AND CIST.LANGUAGE = USERENV('LANG') UNION ALL (SELECT TO_NUMBER(FL.LOOKUP_CODE) INCIDENT_SEVERITY_ID
, SUBSTR(FL.MEANING
, 1
, 30) NAME
, FL.DESCRIPTION DESCRIPTION
, -999 IMPORTANCE_LEVEL
, SUBSTR(FL.MEANING
, 1
, 30) INCIDENT_SUBTYPE
, FL.START_DATE_ACTIVE START_DATE_ACTIVE
, FL.END_DATE_ACTIVE END_DATE_ACTIVE
, FL.LOOKUP_CODE ID
, SUBSTR(FL.MEANING
, 1
, 30) VALUE
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY

Columns