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

MATERIALIZED VIEW: APPS.BIV_CLO_H_SUM_MV

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

BIV_CLO_SUM_MV
     BIS_BUCKET
     BIS_BUCKET_CUSTOMIZATIONS
     BIV_DBI_CLOSED_SUM_F
     ENI_OLTP_ITEM_STAR
     FII_TIME_DAY
ENI_DENORM_HIERARCHIES
MTL_DEFAULT_CATEGORY_SETS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Period type identifier based on XTD nested model
INCIDENT_TYPE_ID NUMBER

Type identifier, from cs_incidents_audit_b.incident_type_id. Securing dimension
VBH_TOP_NODE_FLAG VARCHAR2 (1)
Indicates if VBH_PARENT_CATEGORY_ID is for a top node in the hierarchy
VBH_PARENT_CATEGORY_ID NUMBER

Parent Product Category identifier, from eni_denorm_hierarchies.parent_id
VBH_CHILD_CATEGORY_ID NUMBER

Child Product Category identifier, from eni_denorm_hierarchies.imm_child_id
INCIDENT_SEVERITY_ID NUMBER

Severity identifier, from cs_incidents_audit_b.incident_severity_id
CLOSED_COUNT NUMBER

Count of Service Requests closed with combination of dimensional values
TOTAL_TIME_TO_CLOSE NUMBER

Total (sum) for time to close of Service Requests closed with combination of dimensional values
TIME_TO_CLOSE_B1 NUMBER

Count of Service Requests closed with combination of dimensional values and time to close in bucket range 1
TIME_TO_CLOSE_B2 NUMBER

Count of Service Requests closed with combination of dimensional values and time to close in bucket range 2
TIME_TO_CLOSE_B3 NUMBER

Count of Service Requests closed with combination of dimensional values and time to close in bucket range 3
TIME_TO_CLOSE_B4 NUMBER

Count of Service Requests closed with combination of dimensional values and time to close in bucket range 4
TIME_TO_CLOSE_B5 NUMBER

Count of Service Requests closed with combination of dimensional values and time to close in bucket range 5
TIME_TO_CLOSE_B6 NUMBER

Count of Service Requests closed with combination of dimensional values and time to close in bucket range 6
TIME_TO_CLOSE_B7 NUMBER

Count of Service Requests closed with combination of dimensional values and time to close in bucket range 7
TIME_TO_CLOSE_B8 NUMBER

Count of Service Requests closed with combination of dimensional values and time to close in bucket range 8
TIME_TO_CLOSE_B9 NUMBER

Count of Service Requests closed with combination of dimensional values and time to close in bucket range 9
TIME_TO_CLOSE_B10 NUMBER

Count of Service Requests closed with combination of dimensional values and time to close in bucket range 10
MV_CLOSED_COUNT NUMBER

Count Column
MV_TOTAL_TIME_TO_CLOSE NUMBER

Count Column
MV_TIME_TO_CLOSE_B1 NUMBER

Count Column
MV_TIME_TO_CLOSE_B2 NUMBER

Count Column
MV_TIME_TO_CLOSE_B3 NUMBER

Count Column
MV_TIME_TO_CLOSE_B4 NUMBER

Count Column
MV_TIME_TO_CLOSE_B5 NUMBER

Count Column
MV_TIME_TO_CLOSE_B6 NUMBER

Count Column
MV_TIME_TO_CLOSE_B7 NUMBER

Count Column
MV_TIME_TO_CLOSE_B8 NUMBER

Count Column
MV_TIME_TO_CLOSE_B9 NUMBER

Count Column
MV_TIME_TO_CLOSE_B10 NUMBER

Count Column
MV_COUNT NUMBER

Row Count
Query Text

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


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      INCIDENT_TYPE_ID
,      VBH_TOP_NODE_FLAG
,      VBH_PARENT_CATEGORY_ID
,      VBH_CHILD_CATEGORY_ID
,      INCIDENT_SEVERITY_ID
,      CLOSED_COUNT
,      TOTAL_TIME_TO_CLOSE
,      TIME_TO_CLOSE_B1
,      TIME_TO_CLOSE_B2
,      TIME_TO_CLOSE_B3
,      TIME_TO_CLOSE_B4
,      TIME_TO_CLOSE_B5
,      TIME_TO_CLOSE_B6
,      TIME_TO_CLOSE_B7
,      TIME_TO_CLOSE_B8
,      TIME_TO_CLOSE_B9
,      TIME_TO_CLOSE_B10
,      MV_CLOSED_COUNT
,      MV_TOTAL_TIME_TO_CLOSE
,      MV_TIME_TO_CLOSE_B1
,      MV_TIME_TO_CLOSE_B2
,      MV_TIME_TO_CLOSE_B3
,      MV_TIME_TO_CLOSE_B4
,      MV_TIME_TO_CLOSE_B5
,      MV_TIME_TO_CLOSE_B6
,      MV_TIME_TO_CLOSE_B7
,      MV_TIME_TO_CLOSE_B8
,      MV_TIME_TO_CLOSE_B9
,      MV_TIME_TO_CLOSE_B10
,      MV_COUNT
FROM APPS.BIV_CLO_H_SUM_MV;

Dependencies

[top of page]

APPS.BIV_CLO_H_SUM_MV references the following:

SchemaAPPS
TableBIV_CLO_H_SUM_MV
TableBIV_CLO_SUM_MV
Materialized ViewBIV_CLO_SUM_MV
SchemaENI
TableENI_DENORM_HIERARCHIES
SchemaINV
TableMTL_DEFAULT_CATEGORY_SETS

APPS.BIV_CLO_H_SUM_MV is not referenced by any database object