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

TABLE: APPS.BIV_RES_SUM_MV

Object Details
Object Name: BIV_RES_SUM_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.BIV_RES_SUM_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_BIV_RES_SUM_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("MV_ENT_YEAR_ID")
ColumnSYS_OP_MAP_NONNULL("MV_ENT_QTR_ID")
ColumnSYS_OP_MAP_NONNULL("MV_PERIOD_ID")
ColumnSYS_OP_MAP_NONNULL("MV_WEEK_ID")
ColumnSYS_OP_MAP_NONNULL("MV_DAY_ID")
ColumnSYS_OP_MAP_NONNULL("INCIDENT_TYPE_ID")
ColumnSYS_OP_MAP_NONNULL("INCIDENT_SEVERITY_ID")
ColumnSYS_OP_MAP_NONNULL("VBH_CATEGORY_ID")
ColumnSYS_OP_MAP_NONNULL("PRODUCT_ID")
ColumnSYS_OP_MAP_NONNULL("CUSTOMER_ID")
ColumnSYS_OP_MAP_NONNULL("OWNER_GROUP_ID")
ColumnSYS_OP_MAP_NONNULL("SR_CREATION_CHANNEL")
ColumnSYS_OP_MAP_NONNULL("RESOLUTION_CODE")
ColumnSYS_OP_MAP_NONNULL("MV_GROUPING_ID")
BIV_RES_SUM_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnGRP_ID
BIV_RES_SUM_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnGRP_ID
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
GRP_ID NUMBER

Rollup group identifier. Used to identify the rollup group attributed to the row
INCIDENT_TYPE_ID NUMBER

Type identifier, from cs_incidents_audit_b.incident_type_id. Securing dimension
INCIDENT_SEVERITY_ID NUMBER

Severity identifier, from cs_incidents_audit_b.incident_severity_id
VBH_CATEGORY_ID NUMBER

Product Category identifier, from eni_oltp_item_star.vbh_category_id
PRODUCT_ID VARCHAR2 (25)
Product identifier, from eni_oltp_item_star.master_id
CUSTOMER_ID NUMBER

Customer identifier, from cs_incidents_all_b.customer_id
OWNER_GROUP_ID NUMBER

Owner group identifier, from cs_incidents_audit_b.group_id
SR_CREATION_CHANNEL VARCHAR2 (50)
Channel identifier, from cs_incidents_all_b.sr_creation_channel
RESOLUTION_CODE VARCHAR2 (50)
Resolution code identifer, from cs_incidents_all_b.resolution_code
RESOLUTION_COUNT NUMBER

Count of Service Requests resolved with combination of dimensional values
TOTAL_TIME_TO_RESOLUTION NUMBER

Total (sum) for resolution of Service Requests resolved with combination of dimensional values
TIME_TO_RESOLUTION_B1 NUMBER

Count of Service Requests resolved with combination of dimensional values and time to resolution in bucket range 1
TIME_TO_RESOLUTION_B2 NUMBER

Count of Service Requests resolved with combination of dimensional values and time to resolution in bucket range 2
TIME_TO_RESOLUTION_B3 NUMBER

Count of Service Requests resolved with combination of dimensional values and time to resolution in bucket range 3
TIME_TO_RESOLUTION_B4 NUMBER

Count of Service Requests resolved with combination of dimensional values and time to resolution in bucket range 4
TIME_TO_RESOLUTION_B5 NUMBER

Count of Service Requests resolved with combination of dimensional values and time to resolve in bucket range 5
TIME_TO_RESOLUTION_B6 NUMBER

Count of Service Requests resolved with combination of dimensional values and time to resolution in bucket range 6
TIME_TO_RESOLUTION_B7 NUMBER

Count of Service Requests resolved with combination of dimensional values and time to resolution in bucket range 7
TIME_TO_RESOLUTION_B8 NUMBER

Count of Service Requests resolved with combination of dimensional values and time to resolution in bucket range 8
TIME_TO_RESOLUTION_B9 NUMBER

Count of Service Requests resolved with combination of dimensional values and time to resolution in bucket range 9
TIME_TO_RESOLUTION_B10 NUMBER

Count of Service Requests resolved with combination of dimensional values and time to resolution in bucket range 10
MV_GROUPING_ID NUMBER

Grouping ID Column
MV_DAY_ID NUMBER

FII Day Identifier
MV_WEEK_ID NUMBER

FII Week Identifier
MV_PERIOD_ID NUMBER

Enterprise Period Identifier
MV_ENT_QTR_ID NUMBER

Enterprise Quarter Identifier
MV_ENT_YEAR_ID NUMBER

Enterprise Year Identifier
MV_TOTAL_TIME_TO_RESOLUTION NUMBER

Count Column
MV_TIME_TO_RESOLUTION_B1 NUMBER

Count Column
MV_TIME_TO_RESOLUTION_B2 NUMBER

Count Column
MV_TIME_TO_RESOLUTION_B3 NUMBER

Count Column
MV_TIME_TO_RESOLUTION_B4 NUMBER

Count Column
MV_TIME_TO_RESOLUTION_B5 NUMBER

Count Column
MV_TIME_TO_RESOLUTION_B6 NUMBER

Count Column
MV_TIME_TO_RESOLUTION_B7 NUMBER

Count Column
MV_TIME_TO_RESOLUTION_B8 NUMBER

Count Column
MV_TIME_TO_RESOLUTION_B9 NUMBER

Count Column
MV_TIME_TO_RESOLUTION_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
,      GRP_ID
,      INCIDENT_TYPE_ID
,      INCIDENT_SEVERITY_ID
,      VBH_CATEGORY_ID
,      PRODUCT_ID
,      CUSTOMER_ID
,      OWNER_GROUP_ID
,      SR_CREATION_CHANNEL
,      RESOLUTION_CODE
,      RESOLUTION_COUNT
,      TOTAL_TIME_TO_RESOLUTION
,      TIME_TO_RESOLUTION_B1
,      TIME_TO_RESOLUTION_B2
,      TIME_TO_RESOLUTION_B3
,      TIME_TO_RESOLUTION_B4
,      TIME_TO_RESOLUTION_B5
,      TIME_TO_RESOLUTION_B6
,      TIME_TO_RESOLUTION_B7
,      TIME_TO_RESOLUTION_B8
,      TIME_TO_RESOLUTION_B9
,      TIME_TO_RESOLUTION_B10
,      MV_GROUPING_ID
,      MV_DAY_ID
,      MV_WEEK_ID
,      MV_PERIOD_ID
,      MV_ENT_QTR_ID
,      MV_ENT_YEAR_ID
,      MV_TOTAL_TIME_TO_RESOLUTION
,      MV_TIME_TO_RESOLUTION_B1
,      MV_TIME_TO_RESOLUTION_B2
,      MV_TIME_TO_RESOLUTION_B3
,      MV_TIME_TO_RESOLUTION_B4
,      MV_TIME_TO_RESOLUTION_B5
,      MV_TIME_TO_RESOLUTION_B6
,      MV_TIME_TO_RESOLUTION_B7
,      MV_TIME_TO_RESOLUTION_B8
,      MV_TIME_TO_RESOLUTION_B9
,      MV_TIME_TO_RESOLUTION_B10
,      MV_COUNT
FROM APPS.BIV_RES_SUM_MV;

Dependencies

[top of page]

APPS.BIV_RES_SUM_MV does not reference any database object

APPS.BIV_RES_SUM_MV is referenced by following:

SchemaAPPS
Materialized ViewBIV_RES_H_SUM_MV
Materialized ViewBIV_RES_SUM_MV