[Home] [Help] [Dependency Information]
Object Name: | ENI_DBI_CO_SUM_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | ENI_DBI_CO_SUM_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
ENI_DBI_CO_UNION_MV
ENI_DBI_CO_DNUM_MV
ENI_DBI_CO_NUM_MV
ENI_DBI_CO_ALL_MV
ENG_CHANGE_SUBJECTS
ENG_ENGINEERING_CHANGES
ENG_REVISED_ITEMS
ENI_DBI_CO_OBJIDS_MV
FND_OBJECTS
FII_TIME_DAY
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | The Organization in which the Change Order is created | ||
ITEM_ID | VARCHAR2 | (100) | The Inventory Item Id for the Item attached to this Change Order | |
ITEM_ORG_ID | VARCHAR2 | (141) | The concatenated ItemId-OrganizationId for the Item attached to this Change Order | |
TIME_ID | NUMBER | The Time ID to which the data is rolled up | ||
PERIOD_TYPE_ID | NUMBER | The Period Id to which the data is rolled up | ||
CHANGE_ORDER_TYPE_ID | NUMBER | The Change Order Type Id for the Change Order | ||
REASON_CODE | VARCHAR2 | (10) | The Reason for the Change Order | |
PRIORITY_CODE | VARCHAR2 | (10) | The Priority of the Change Order | |
STATUS_TYPE | NUMBER | The current Status of the Change Order | ||
IMPLEMENTED_SUM | NUMBER | The Total Number of Change Orders which were implemented in the current period | ||
IMPLEMENTED_SUM_CNT | NUMBER | Dummy column to make the MV Fast Refreshable | ||
CANCELLED_SUM | NUMBER | The Total Number of Change Orders which were cancelled in the current period | ||
CANCELLED_SUM_CNT | NUMBER | Dummy column to make the MV Fast Refreshable | ||
NEW_SUM | NUMBER | The Total Number of Change Orders which were created newly in the current period | ||
NEW_SUM_CNT | NUMBER | Dummy column to make the MV Fast Refreshable | ||
CYCLE_TIME_SUM | NUMBER | The Sum of the Number of Days it takes for the change orders in the current period to get implemented | ||
CYCLE_TIME_SUM_CNT | NUMBER | Dummy column to make the MV Fast Refreshable | ||
CYCLE_TIME_CNT | NUMBER | The Number of change orders in the current period to get implemented | ||
CYCLE_TIME_CNT_CNT | NUMBER | Dummy column to make the MV Fast Refreshable | ||
APPROVE_TO_IMPL_SUM | NUMBER | The Sum of the Number of Days it takes for the change orders in the current period to get implemented after being approved | ||
APPROVE_TO_IMPL_SUM_CNT | NUMBER | Dummy column to make the MV Fast Refreshable | ||
APPROVE_TO_IMPL_CNT | NUMBER | The Number of change orders in the current period to get implemented after being approved | ||
APPROVE_TO_IMPL_CNT_CNT | NUMBER | Dummy column to make the MV Fast Refreshable | ||
CREATE_TO_APPROVE_SUM | NUMBER | The Sum of the Number of Days it takes for the change order in the current period to get approved after being created | ||
CREATE_TO_APPROVE_SUM_CNT | NUMBER | Dummy column to make the MV Fast Refreshable | ||
CREATE_TO_APPROVE_CNT | NUMBER | The Number of change order in the current period to get approved after being created | ||
CREATE_TO_APPROVE_CNT_CNT | NUMBER | Dummy column to make the MV Fast Refreshable | ||
BUCKET1_SUM | NUMBER | The Number of Change Orders having a Cycle Time between 0 to 1 Days | ||
BUCKET1_SUM_CNT | NUMBER | Dummy column to make the MV Fast Refreshable | ||
BUCKET2_SUM | NUMBER | The Number of Change Orders having a Cycle Time between 2 to 5 Days | ||
BUCKET2_SUM_CNT | NUMBER | Dummy column to make the MV Fast Refreshable | ||
BUCKET3_SUM | NUMBER | The Number of Change Orders having a Cycle Time between 6 to 10 Days | ||
BUCKET3_SUM_CNT | NUMBER | Dummy column to make the MV Fast Refreshable | ||
BUCKET4_SUM | NUMBER | The Number of Change Orders having a Cycle Time of > 10 Days | ||
BUCKET4_SUM_CNT | NUMBER | Dummy column to make the MV Fast Refreshable | ||
COUNT(*) | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, ITEM_ID
, ITEM_ORG_ID
, TIME_ID
, PERIOD_TYPE_ID
, CHANGE_ORDER_TYPE_ID
, REASON_CODE
, PRIORITY_CODE
, STATUS_TYPE
, IMPLEMENTED_SUM
, IMPLEMENTED_SUM_CNT
, CANCELLED_SUM
, CANCELLED_SUM_CNT
, NEW_SUM
, NEW_SUM_CNT
, CYCLE_TIME_SUM
, CYCLE_TIME_SUM_CNT
, CYCLE_TIME_CNT
, CYCLE_TIME_CNT_CNT
, APPROVE_TO_IMPL_SUM
, APPROVE_TO_IMPL_SUM_CNT
, APPROVE_TO_IMPL_CNT
, APPROVE_TO_IMPL_CNT_CNT
, CREATE_TO_APPROVE_SUM
, CREATE_TO_APPROVE_SUM_CNT
, CREATE_TO_APPROVE_CNT
, CREATE_TO_APPROVE_CNT_CNT
, BUCKET1_SUM
, BUCKET1_SUM_CNT
, BUCKET2_SUM
, BUCKET2_SUM_CNT
, BUCKET3_SUM
, BUCKET3_SUM_CNT
, BUCKET4_SUM
, BUCKET4_SUM_CNT
, COUNT(*)
FROM APPS.ENI_DBI_CO_SUM_MV;
APPS.ENI_DBI_CO_SUM_MV is not referenced by any database object
|
|
|