DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.BIL_DIMV_SRV_SVTYS

Object Details
Object Name: BIL_DIMV_SRV_SVTYS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIL.BIL_DIMV_SRV_SVTYS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


BIL_DIMV_SRV_SVTYS - Dimension view used to provide descriptive information related to
service request (incident) severity classifications.
.
Source is Oracle CRM Service schema.
.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INCIDENT_SEVERITY_ID NUMBER

Severity Id
NAME VARCHAR2 (90)
Severity Name
DESCRIPTION VARCHAR2 (720)
Severity Description
IMPORTANCE_LEVEL NUMBER

Severity Importance Level
INCIDENT_SUBTYPE VARCHAR2 (30)
Incident severity sub type
START_DATE_ACTIVE DATE

Start date of the Incident
END_DATE_ACTIVE DATE

End date of the Incident
ID VARCHAR2 (40)
Incident Severity Identifier
VALUE VARCHAR2 (90)
Incident Severity Name
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INCIDENT_SEVERITY_ID
,      NAME
,      DESCRIPTION
,      IMPORTANCE_LEVEL
,      INCIDENT_SUBTYPE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ID
,      VALUE
FROM APPS.BIL_DIMV_SRV_SVTYS;

Dependencies

[top of page]

APPS.BIL_DIMV_SRV_SVTYS references the following:

SchemaAPPS
SynonymCS_INCIDENT_SEVERITIES_B
SynonymCS_INCIDENT_SEVERITIES_TL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS

APPS.BIL_DIMV_SRV_SVTYS is not referenced by any database object