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

VIEW: IEB.IEB_INB_SVC_COVERAGES#

Object Details
Object Name: IEB_INB_SVC_COVERAGES#
Object Type: VIEW
Owner: IEB
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ISVCCOV_ID NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
SCHEDULE_TYPE VARCHAR2 (1) Yes
REGULAR_SCHD_DAY NUMBER (1)
SPEC_SCHD_DATE DATE

BEGIN_TIME_HHMM NUMBER (4) Yes
END_TIME_HHMM NUMBER (4) Yes
MIN_AGENT NUMBER (8) Yes
PERCENTAGE NUMBER (4) Yes
TIME_THRESHOLD NUMBER (8) Yes
MAX_WAIT_TIME NUMBER (8) Yes
REROUTE_TIME NUMBER (8) Yes
REROUTE_WARNING_TIME NUMBER (8) Yes
SVCPLN_SVCPLN_ID NUMBER (15) Yes
OBJECT_VERSION_NUMBER NUMBER

SECURITY_GROUP_ID NUMBER (15)
SERVICE_LEVEL_ID NUMBER (15)
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT ISVCCOV_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SCHEDULE_TYPE
,      REGULAR_SCHD_DAY
,      SPEC_SCHD_DATE
,      BEGIN_TIME_HHMM
,      END_TIME_HHMM
,      MIN_AGENT
,      PERCENTAGE
,      TIME_THRESHOLD
,      MAX_WAIT_TIME
,      REROUTE_TIME
,      REROUTE_WARNING_TIME
,      SVCPLN_SVCPLN_ID
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      SERVICE_LEVEL_ID
,      ZD_EDITION_NAME
FROM IEB.IEB_INB_SVC_COVERAGES#;

Dependencies

[top of page]

IEB.IEB_INB_SVC_COVERAGES# references the following:

SchemaIEB
TableIEB_INB_SVC_COVERAGES
IEB.IEB_INB_SVC_COVERAGES# is referenced by following:

SchemaAPPS
SynonymIEB_INB_SVC_COVERAGES
TriggerIEB_INB_SVC_COVERAGES+
TriggerIEB_INB_SVC_COVERAGES_ALERT