VIEW: APPS.BIL_DIMV_SRV_SVTYS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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