[Home] [Help] [Dependency Information]
Object Name: | BIL_DIMV_SRV_SVTYS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIL.BIL_DIMV_SRV_SVTYS |
Subobject Name: | |
Status: | VALID |
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.
.
.
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 |
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;
APPS.BIL_DIMV_SRV_SVTYS is not referenced by any database object
|
|
|