[Home] [Help] [Dependency Information]
Object Name: | ENI_DBI_CO_UNION_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | ENI.ENI_DBI_CO_UNION_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
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 | |
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 | ||
SOURCE_FLAG | CHAR | (1) | The Initiation Date of the 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 | ||
YEAR_ID | NUMBER | The Year Id to which the data is rolled up | ||
QTR_ID | NUMBER | The Quarter Id to which the data is rolled up | ||
MONTH_ID | NUMBER | The Month Id to which the data is rolled up | ||
WEEK_ID | NUMBER | The Week Id to which the data is rolled up | ||
DAY_ID | NUMBER | The Day Id to which the data is rolled up | ||
CNT | NUMBER | Dummy column to make the MV Fast Refreshable | ||
IMPLEMENTED_SUM | NUMBER | The Total Number of Change Orders which were implemented in the current period | ||
IMPLEMENTED_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_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_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_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_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_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_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_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_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_CNT | NUMBER | Dummy column to make the MV Fast Refreshable | ||
GROUPING_ID(ENT_YEAR_ | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, ITEM_ID
, ITEM_ORG_ID
, CHANGE_ORDER_TYPE_ID
, REASON_CODE
, PRIORITY_CODE
, STATUS_TYPE
, SOURCE_FLAG
, TIME_ID
, PERIOD_TYPE_ID
, YEAR_ID
, QTR_ID
, MONTH_ID
, WEEK_ID
, DAY_ID
, CNT
, IMPLEMENTED_SUM
, IMPLEMENTED_CNT
, CANCELLED_SUM
, CANCELLED_CNT
, NEW_SUM
, NEW_CNT
, CYCLE_TIME_SUM
, CYCLE_TIME_CNT
, APPROVE_TO_IMPL_SUM
, APPROVE_TO_IMPL_CNT
, CREATE_TO_APPROVE_SUM
, CREATE_TO_APPROVE_CNT
, BUCKET1_SUM
, BUCKET1_CNT
, BUCKET2_SUM
, BUCKET2_CNT
, BUCKET3_SUM
, BUCKET3_CNT
, BUCKET4_SUM
, BUCKET4_CNT
, GROUPING_ID(ENT_YEAR_
FROM APPS.ENI_DBI_CO_UNION_MV;
APPS.ENI_DBI_CO_UNION_MV does not reference any database object
APPS.ENI_DBI_CO_UNION_MV is referenced by following:
|
|
|