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

MATERIALIZED VIEW: APPS.BIV_B_AGE_H_SUM_MV

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

BIV_BAC_AGE_SUM_F
ENI_DENORM_HIERARCHIES
MTL_DEFAULT_CATEGORY_SETS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
REPORT_DATE DATE
Yes The date of the backlog
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
RESOLVED_FLAG VARCHAR2 (1)
Flag indicates the resolution status of the backlog audit record
BACKLOG_COUNT NUMBER

Count of Service Requests in backlog
TOTAL_BACKLOG_AGE NUMBER

Total for age of Service Requests in backlog. Average age can be calculated as TOTAL_BACKLOG_AGE/BACKLOG_COUNT
BACKLOG_AGE_B1 NUMBER

Count of Service Requests in backlog with age in bucket range 1
BACKLOG_AGE_B2 NUMBER

Count of Service Requests in backlog with age in bucket range 2
BACKLOG_AGE_B3 NUMBER

Count of Service Requests in backlog with age in bucket range 3
BACKLOG_AGE_B4 NUMBER

Count of Service Requests in backlog with age in bucket range 4
BACKLOG_AGE_B5 NUMBER

Count of Service Requests in backlog with age in bucket range 5
BACKLOG_AGE_B6 NUMBER

Count of Service Requests in backlog with age in bucket range 6
BACKLOG_AGE_B7 NUMBER

Count of Service Requests in backlog with age in bucket range 7
BACKLOG_AGE_B8 NUMBER

Count of Service Requests in backlog with age in bucket range 8
BACKLOG_AGE_B9 NUMBER

Count of Service Requests in backlog with age in bucket range 9
BACKLOG_AGE_B10 NUMBER

Count of Service Requests in backlog with age in bucket range 10
ESCALATED_COUNT NUMBER

Count of escalated Service Requests in backlog
TOTAL_ESCALATED_AGE NUMBER

Total for age of escalated Service Requests in backlog. Average age can be calculated as TOTAL_ESCALATED_AGE/ESCALATED_COUNT
ESCALATED_AGE_B1 NUMBER

Count of escalated Service Requests in backlog with age in bucket range 1
ESCALATED_AGE_B2 NUMBER

Count of escalated Service Requests in backlog with age in bucket range 2
ESCALATED_AGE_B3 NUMBER

Count of escalated Service Requests in backlog with age in bucket range 3
ESCALATED_AGE_B4 NUMBER

Count of escalated Service Requests in backlog with age in bucket range 4
ESCALATED_AGE_B5 NUMBER

Count of escalated Service Requests in backlog with age in bucket range 5
ESCALATED_AGE_B6 NUMBER

Count of escalated Service Requests in backlog with age in bucket range 6
ESCALATED_AGE_B7 NUMBER

Count of escalated Service Requests in backlog with age in bucket range 7
ESCALATED_AGE_B8 NUMBER

Count of escalated Service Requests in backlog with age in bucket range 8
ESCALATED_AGE_B9 NUMBER

Count of escalated Service Requests in backlog with age in bucket range 9
ESCALATED_AGE_B10 NUMBER

Count of escalated Service Requests in backlog with age in bucket range 10
UNOWNED_COUNT NUMBER

Count of unowned Service Requests in backlog
TOTAL_UNOWNED_AGE NUMBER

Total for age of unowned Service Requests in backlog. Average age can be calculated as TOTAL_UNOWNED_AGE/UNOWNED_COUNT
UNOWNED_AGE_B1 NUMBER

Count of unowned Service Requests in backlog with age in bucket range 1
UNOWNED_AGE_B2 NUMBER

Count of unowned Service Requests in backlog with age in bucket range 2
UNOWNED_AGE_B3 NUMBER

Count of unowned Service Requests in backlog with age in bucket range 3
UNOWNED_AGE_B4 NUMBER

Count of unowned Service Requests in backlog with age in bucket range 4
UNOWNED_AGE_B5 NUMBER

Count of unowned Service Requests in backlog with age in bucket range 5
UNOWNED_AGE_B6 NUMBER

Count of unowned Service Requests in backlog with age in bucket range 6
UNOWNED_AGE_B7 NUMBER

Count of unowned Service Requests in backlog with age in bucket range 7
UNOWNED_AGE_B8 NUMBER

Count of unowned Service Requests in backlog with age in bucket range 8
UNOWNED_AGE_B9 NUMBER

Count of unowned Service Requests in backlog with age in bucket range 9
UNOWNED_AGE_B10 NUMBER

Count of unowned Service Requests in backlog with age in bucket range 10
Query Text

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


SELECT REPORT_DATE
,      INCIDENT_TYPE_ID
,      VBH_TOP_NODE_FLAG
,      VBH_PARENT_CATEGORY_ID
,      VBH_CHILD_CATEGORY_ID
,      INCIDENT_SEVERITY_ID
,      RESOLVED_FLAG
,      BACKLOG_COUNT
,      TOTAL_BACKLOG_AGE
,      BACKLOG_AGE_B1
,      BACKLOG_AGE_B2
,      BACKLOG_AGE_B3
,      BACKLOG_AGE_B4
,      BACKLOG_AGE_B5
,      BACKLOG_AGE_B6
,      BACKLOG_AGE_B7
,      BACKLOG_AGE_B8
,      BACKLOG_AGE_B9
,      BACKLOG_AGE_B10
,      ESCALATED_COUNT
,      TOTAL_ESCALATED_AGE
,      ESCALATED_AGE_B1
,      ESCALATED_AGE_B2
,      ESCALATED_AGE_B3
,      ESCALATED_AGE_B4
,      ESCALATED_AGE_B5
,      ESCALATED_AGE_B6
,      ESCALATED_AGE_B7
,      ESCALATED_AGE_B8
,      ESCALATED_AGE_B9
,      ESCALATED_AGE_B10
,      UNOWNED_COUNT
,      TOTAL_UNOWNED_AGE
,      UNOWNED_AGE_B1
,      UNOWNED_AGE_B2
,      UNOWNED_AGE_B3
,      UNOWNED_AGE_B4
,      UNOWNED_AGE_B5
,      UNOWNED_AGE_B6
,      UNOWNED_AGE_B7
,      UNOWNED_AGE_B8
,      UNOWNED_AGE_B9
,      UNOWNED_AGE_B10
FROM APPS.BIV_B_AGE_H_SUM_MV;

Dependencies

[top of page]

APPS.BIV_B_AGE_H_SUM_MV references the following:

SchemaAPPS
TableBIV_B_AGE_H_SUM_MV
SchemaBIV
TableBIV_BAC_AGE_SUM_F
SchemaENI
TableENI_DENORM_HIERARCHIES
SchemaINV
TableMTL_DEFAULT_CATEGORY_SETS

APPS.BIV_B_AGE_H_SUM_MV is not referenced by any database object