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

MATERIALIZED VIEW: APPS.ISC_DR_MTTR_02_MV

Object Details
Object Name: ISC_DR_MTTR_02_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ISC_DR_MTTR_02_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:

ENI_DENORM_HIERARCHIES
ISC_DR_MTTR_01_MV
     BIS_BUCKET
     BIS_BUCKET_CUSTOMIZATIONS
     ENI_OLTP_ITEM_STAR
     FII_TIME_DAY
     ISC_DR_MTTR_F
     ISC_DR_REPAIR_ORDERS_F
MTL_DEFAULT_CATEGORY_SETS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
PRODUCT_CATEGORY_ID NUMBER

Parent Product Category Identifier
REPAIR_ORGANIZATION_ID NUMBER (15)
Repair Organization Identifier
REPAIR_TYPE_ID NUMBER (15)
Repair type Identifier
CUSTOMER_ID NUMBER (15)
Customer Identifier
AGGREGATION_FLAG NUMBER

MV Level aggregation flag
TIME_ID NUMBER

Activity date time identifier
PERIOD_TYPE_ID NUMBER

Activity date period type identifier
TIME_TO_REPAIR NUMBER

Aggregation of the time to repair of the repair orders
MV_TIME_TO_REPAIR_COUNT NUMBER

To make MV fast refreshable
RO_COUNT NUMBER

Aggregation of the number of repair orders
MV_RO_COUNT NUMBER

To make MV fast refreshable
MV_GRP_ID NUMBER

To make MV fast refreshable
MV_COUNT NUMBER

To make MV fast refreshable
TIME_TO_REPAIR_B1 NUMBER

The number of repair orders which has its time to repair falling in the first bucket.
MV_TIME_TO_REPAIR_B1_COUNT NUMBER

To make MV fast refreshable
TIME_TO_REPAIR_B2 NUMBER

The number of repair orders which has its time to repair falling in the second bucket.
MV_TIME_TO_REPAIR_B2_COUNT NUMBER

To make MV fast refreshable
TIME_TO_REPAIR_B3 NUMBER

The number of repair orders which has its time to repair falling in the third bucket.
MV_TIME_TO_REPAIR_B3_COUNT NUMBER

To make MV fast refreshable
TIME_TO_REPAIR_B4 NUMBER

The number of repair orders which has its time to repair falling in the fourth bucket.
MV_TIME_TO_REPAIR_B4_COUNT NUMBER

To make MV fast refreshable
TIME_TO_REPAIR_B5 NUMBER

The number of repair orders which has its time to repair falling in the fifth bucket.
MV_TIME_TO_REPAIR_B5_COUNT NUMBER

To make MV fast refreshable
TIME_TO_REPAIR_B6 NUMBER

The number of repair orders which has its time to repair falling in the sixth bucket.
MV_TIME_TO_REPAIR_B6_COUNT NUMBER

To make MV fast refreshable
TIME_TO_REPAIR_B7 NUMBER

The number of repair orders which has its time to repair falling in the seventh bucket.
MV_TIME_TO_REPAIR_B7_COUNT NUMBER

To make MV fast refreshable
TIME_TO_REPAIR_B8 NUMBER

The number of repair orders which has its time to repair falling in the eigth bucket.
MV_TIME_TO_REPAIR_B8_COUNT NUMBER

To make MV fast refreshable
TIME_TO_REPAIR_B9 NUMBER

The number of repair orders which has its time to repair falling in the ninth bucket.
MV_TIME_TO_REPAIR_B9_COUNT NUMBER

To make MV fast refreshable
TIME_TO_REPAIR_B10 NUMBER

The number of repair orders which has its time to repair falling in the tenth bucket.
MV_TIME_TO_REPAIR_B10_COUNT NUMBER

To make MV fast refreshable
Query Text

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


SELECT PRODUCT_CATEGORY_ID
,      REPAIR_ORGANIZATION_ID
,      REPAIR_TYPE_ID
,      CUSTOMER_ID
,      AGGREGATION_FLAG
,      TIME_ID
,      PERIOD_TYPE_ID
,      TIME_TO_REPAIR
,      MV_TIME_TO_REPAIR_COUNT
,      RO_COUNT
,      MV_RO_COUNT
,      MV_GRP_ID
,      MV_COUNT
,      TIME_TO_REPAIR_B1
,      MV_TIME_TO_REPAIR_B1_COUNT
,      TIME_TO_REPAIR_B2
,      MV_TIME_TO_REPAIR_B2_COUNT
,      TIME_TO_REPAIR_B3
,      MV_TIME_TO_REPAIR_B3_COUNT
,      TIME_TO_REPAIR_B4
,      MV_TIME_TO_REPAIR_B4_COUNT
,      TIME_TO_REPAIR_B5
,      MV_TIME_TO_REPAIR_B5_COUNT
,      TIME_TO_REPAIR_B6
,      MV_TIME_TO_REPAIR_B6_COUNT
,      TIME_TO_REPAIR_B7
,      MV_TIME_TO_REPAIR_B7_COUNT
,      TIME_TO_REPAIR_B8
,      MV_TIME_TO_REPAIR_B8_COUNT
,      TIME_TO_REPAIR_B9
,      MV_TIME_TO_REPAIR_B9_COUNT
,      TIME_TO_REPAIR_B10
,      MV_TIME_TO_REPAIR_B10_COUNT
FROM APPS.ISC_DR_MTTR_02_MV;

Dependencies

[top of page]

APPS.ISC_DR_MTTR_02_MV references the following:

SchemaAPPS
TableISC_DR_MTTR_01_MV
Materialized ViewISC_DR_MTTR_01_MV
TableISC_DR_MTTR_02_MV
SchemaENI
TableENI_DENORM_HIERARCHIES
SchemaINV
TableMTL_DEFAULT_CATEGORY_SETS

APPS.ISC_DR_MTTR_02_MV is not referenced by any database object