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


MATERIALIZED VIEW: APPS.CSY_GROUP_RESPN_RESOL_MV

Object Details
Object Name: CSY_GROUP_RESPN_RESOL_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: CSY_GROUP_RESPN_RESOL_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: NONE
Refresh Mode: DEMAND
Refresh Method: FORCE
Build Mode: DEFERRED
Fast Refreshable: NO
MV Log Dependencies:

FND_LOOKUP_VALUES

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
PERIOD_TYPE VARCHAR2 (30) Yes
PERIOD_NAME VARCHAR2 (80) Yes
INCIDENT_SEVERITY_ID NUMBER
Yes
OWNER_GROUP_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
,      OWNER_GROUP_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_GROUP_RESPN_RESOL_MV;

Dependencies

[top of page]

APPS.CSY_GROUP_RESPN_RESOL_MV references the following:

SchemaAPPLSYS
TableFND_LOOKUP_VALUES
SchemaAPPS
TableCSY_GROUP_RESPN_RESOL_MV
ViewCSY_PERIODS_V
SynonymCSY_RESPONSE_RESOLUTIONS
ViewCS_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_LOOKUP_VALUES
SchemaCS
TableCSY_RESPONSE_RESOLUTIONS

APPS.CSY_GROUP_RESPN_RESOL_MV is not referenced by any database object