[Home] [Help] [Dependency Information]
Object Name: | ENI_DBI_CO_SUM_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | ENI.ENI_DBI_CO_SUM_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SNAP$_ENI_DBI_CO_SUM_MV | FUNCTION-BASED NORMAL | UNIQUE | APPS_TS_SUMMARY |
SYS_OP_MAP_NONNULL("ORGANIZATION_ID")
SYS_OP_MAP_NONNULL("ITEM_ID") SYS_OP_MAP_NONNULL("ITEM_ORG_ID") SYS_OP_MAP_NONNULL("TIME_ID") SYS_OP_MAP_NONNULL("PERIOD_TYPE_ID") SYS_OP_MAP_NONNULL("CHANGE_ORDER_TYPE_ID") SYS_OP_MAP_NONNULL("REASON_CODE") SYS_OP_MAP_NONNULL("PRIORITY_CODE") SYS_OP_MAP_NONNULL("STATUS_TYPE") |
ENI_DBI_CO_SUM_MV_N1 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY |
ORGANIZATION_ID
ITEM_ID TIME_ID PERIOD_TYPE_ID |
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 does not reference any database object
APPS.ENI_DBI_CO_SUM_MV is referenced by following:
|
|
|