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

TABLE: APPS.CSY_AGENT_RESPN_RESOL_MV

Object Details
Object Name: CSY_AGENT_RESPN_RESOL_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSY_AGENT_RESPN_RESOL_MV_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnPERIOD_TYPE
ColumnINCIDENT_OWNER_ID
ColumnINCIDENT_SEVERITY_ID
Columns
Name Datatype Length Mandatory Comments
PERIOD_TYPE VARCHAR2 (30) Yes
PERIOD_NAME VARCHAR2 (80) Yes
INCIDENT_SEVERITY_ID NUMBER
Yes
INCIDENT_OWNER_ID NUMBER
Yes
TOTAL_RESPONSE_TIME NUMBER

TOTAL_SR_RESPONDED NUMBER

TOTAL_RESP_SLA_MISSED NUMBER

TOTAL_AGENT_WAIT NUMBER

TOTAL_OTHERS_WAIT NUMBER

TOTAL_RESOLVE_TIME NUMBER

TOTAL_SR_RESOLVED NUMBER

TOTAL_WAIT_AGENT NUMBER

TOTAL_WAIT_SUPPORT NUMBER

TOTAL_WAIT_INTERNAL NUMBER

TOTAL_WAIT_EXTERNAL NUMBER

TOTAL_WAIT_CUSTOMER NUMBER

TOTAL_RESL_SLA_MISSED NUMBER

BEGINNING_BACKLOG NUMBER

ENDING_BACKLOG NUMBER

TOTAL_SR_ASSIGNED NUMBER

TOTAL_SR_REASSIGNED_TO_OTHERS NUMBER

Query Text

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


SELECT PERIOD_TYPE
,      PERIOD_NAME
,      INCIDENT_SEVERITY_ID
,      INCIDENT_OWNER_ID
,      TOTAL_RESPONSE_TIME
,      TOTAL_SR_RESPONDED
,      TOTAL_RESP_SLA_MISSED
,      TOTAL_AGENT_WAIT
,      TOTAL_OTHERS_WAIT
,      TOTAL_RESOLVE_TIME
,      TOTAL_SR_RESOLVED
,      TOTAL_WAIT_AGENT
,      TOTAL_WAIT_SUPPORT
,      TOTAL_WAIT_INTERNAL
,      TOTAL_WAIT_EXTERNAL
,      TOTAL_WAIT_CUSTOMER
,      TOTAL_RESL_SLA_MISSED
,      BEGINNING_BACKLOG
,      ENDING_BACKLOG
,      TOTAL_SR_ASSIGNED
,      TOTAL_SR_REASSIGNED_TO_OTHERS
FROM APPS.CSY_AGENT_RESPN_RESOL_MV;

Dependencies

[top of page]

APPS.CSY_AGENT_RESPN_RESOL_MV does not reference any database object

APPS.CSY_AGENT_RESPN_RESOL_MV is referenced by following:

SchemaAPPS
Materialized ViewCSY_AGENT_RESPN_RESOL_MV