Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - ENI Tables and Views

TABLE - APPS.ENI_DBI_AR_BASE_MV
TABLE - APPS.ENI_DBI_BOM_COMPONENTS_MV1
TABLE - APPS.ENI_DBI_BOM_COMPONENTS_MV2
TABLE - APPS.ENI_DBI_COGS_BASE_MV
TABLE - APPS.ENI_DBI_CO_ALL_MV
TABLE - APPS.ENI_DBI_CO_DNUM_MV
TABLE - APPS.ENI_DBI_CO_NEW_MV
TABLE - APPS.ENI_DBI_CO_NUM_MV
TABLE - APPS.ENI_DBI_CO_OBJIDS_MV
TABLE - APPS.ENI_DBI_CO_SUM_MV
TABLE - APPS.ENI_DBI_CO_UNION_MV
TABLE - APPS.ENI_DBI_GL_BASE_MV
TABLE - APPS.ENI_DBI_GL_BASE_SUM_C_MV
TABLE - APPS.ENI_DBI_GL_BASE_SUM_MV
TABLE - APPS.ENI_DBI_INV_BASE_MV
TABLE - APPS.ENI_DBI_INV_SUM_MV
TABLE - APPS.ENI_DBI_MFG_STEPS_JOIN_MV
TABLE - APPS.ENI_DBI_ORG_MV
TABLE - APPS.ENI_DBI_PART_COUNT_MV
TABLE - APPS.ENI_DBI_PRC_SUM1_MV
TABLE - APPS.ENI_DBI_PRC_SUM2_MV
TABLE - APPS.ENI_DBI_PRC_UNION_MV
TABLE - APPS.ENI_DBI_TOB_MV
TABLE - APPS.ENI_DBI_TOO_MV
TABLE - APPS.ENI_RES_1_MV
TABLE - APPS.ENI_RES_2_MV
TABLE - APPS.ENI_RES_3_MV
TABLE - APPS.ENI_RES_4_MV
TABLE - APPS.ENI_RES_5_MV

Table: ENI_DBI_AR_BASE_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ENI_DBI_AR_BASE_MV UNIQUE APPS_TS_SUMMARY SYS_NC00017$
SYS_NC00018$
SYS_NC00019$
SYS_NC00020$
SYS_NC00021$
SYS_NC00022$
SYS_NC00023$
SYS_NC00024$
SYS_NC00025$
Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

Time id
PERIOD_TYPE_ID NUMBER

Period type id
REPORT_DATE_JULIAN NUMBER

Report Date
ENT_QTR_ID NUMBER

Quarter id
ENT_PERIOD_ID NUMBER

Period id
WEEK_ID NUMBER

Week id
ENT_YEAR_ID NUMBER

Year id
PRODUCT_CATEGORY_ID NUMBER

Product Category id
INVENTORY_ITEM_ID NUMBER

Inventory Item id
ORGANIZATION_ID NUMBER

Organization id
COUNT(*) NUMBER

REV_PRIM_ACTUAL_G NUMBER

Revenue of the item-org on report_date in Primary Currency
COUNT_REV_PRIM_ACTUAL_G NUMBER

Dummy column to make materialized view fast refreshable
REV_SEC_ACTUAL_G NUMBER

Revenue of the item-org on report_date in Secondary Currency
COUNT_REV_SEC_ACTUAL_G NUMBER

Dummy column to make materialized view fast refreshable
GID NUMBER

group id

[top of page]

APPS.ENI_DBI_AR_BASE_MV does not reference any database object

APPS.ENI_DBI_AR_BASE_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_AR_BASE_MV
MATERIALIZED VIEW - ENI_DBI_PRC_UNION_MV

[top of page]

Table: ENI_DBI_BOM_COMPONENTS_MV1

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ENI_DBI_BOM_COMPON UNIQUE APPS_TS_SUMMARY SYS_NC00003$
Columns
Name Datatype Length Mandatory Comments
BILL_SEQUENCE_ID NUMBER
Y Bill Sequence Id of the Bill
COUNT(*) NUMBER

Dummy Column to make MV fast refreshable

[top of page]

APPS.ENI_DBI_BOM_COMPONENTS_MV1 does not reference any database object

APPS.ENI_DBI_BOM_COMPONENTS_MV1 is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_BOM_COMPONENTS_MV1

[top of page]

Table: ENI_DBI_BOM_COMPONENTS_MV2

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ENI_DBI_BOM_COMPON1 UNIQUE APPS_TS_SUMMARY SYS_NC00003$
Columns
Name Datatype Length Mandatory Comments
COMPONENT_SEQUENCE_ID NUMBER
Y Component Sequence Id of the component in a Bill
COUNT(*) NUMBER

Dummy Column to make MV fast refreshable

[top of page]

APPS.ENI_DBI_BOM_COMPONENTS_MV2 does not reference any database object

APPS.ENI_DBI_BOM_COMPONENTS_MV2 is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_BOM_COMPONENTS_MV2

[top of page]

Table: ENI_DBI_COGS_BASE_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ENI_DBI_COGS_BASE_ UNIQUE APPS_TS_SUMMARY SYS_NC00015$
SYS_NC00016$
SYS_NC00017$
SYS_NC00018$
SYS_NC00019$
SYS_NC00020$
SYS_NC00021$
SYS_NC00022$
Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

Time id
REPORT_DATE_JULIAN NUMBER

Report Date
ENT_QTR_ID NUMBER

Quarter id
ENT_PERIOD_ID NUMBER

Period id
WEEK_ID NUMBER

Week id
ENT_YEAR_ID NUMBER

Year id
INVENTORY_ITEM_ID NUMBER

Inventory Item id
ORGANIZATION_ID NUMBER

Organization id
COGS_VAL_G NUMBER

Cost of Goods Sold in Primary Currency
C_COGS_VAL_G NUMBER

Dummy column to make materialized view fast refreshable
COGS_VAL_SG NUMBER

Cost of Goods Sold in Secondary Currency
C_COGS_VAL_SG NUMBER

Dummy column to make materialized view fast refreshable
GID NUMBER

group id
COUNT(*) NUMBER

[top of page]

APPS.ENI_DBI_COGS_BASE_MV does not reference any database object

APPS.ENI_DBI_COGS_BASE_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_COGS_BASE_MV
MATERIALIZED VIEW - ENI_DBI_PRC_UNION_MV

[top of page]

Table: ENI_DBI_CO_ALL_MV

Description:
Columns
Name Datatype Length Mandatory Comments
CHANGE_NOTICE VARCHAR2 (10)
The Name of the Change Order
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
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
CREATION_DATE DATE

The Initiation Date of the Change Order
IMPLEMENTATION_DATE DATE

The Implementation Date of the Change Order
CANCELLATION_DATE DATE

The Cancellation Date of the Change Order
APPROVAL_DATE DATE

The Approval Date of the Change Order
NEED_BY_DATE DATE

The Date by which this Change Order is Needed to be implemented
ASSIGNEE_ID NUMBER

The Id of the Assignee for this Change Order
DESCRIPTION VARCHAR2 (2000)
The Description of the Change Order
CHANGE_ID NUMBER

The Unique Change Id of the Change Order
MARKER NUMBER

The Marker to indicate if the Change Order contains Items as Revised Items or Items as Subjects
CNT NUMBER

Dummy column to make the MV Fast Refreshable

[top of page]

APPS.ENI_DBI_CO_ALL_MV does not reference any database object

APPS.ENI_DBI_CO_ALL_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_CO_ALL_MV
MATERIALIZED VIEW - ENI_DBI_CO_NUM_MV

[top of page]

Table: ENI_DBI_CO_DNUM_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ENI_DBI_CO_DNUM_MV UNIQUE APPS_TS_SUMMARY SYS_NC00014$
SYS_NC00015$
SYS_NC00016$
SYS_NC00017$
SYS_NC00018$
SYS_NC00019$
SYS_NC00020$
SYS_NC00021$
SYS_NC00022$
SYS_NC00023$
SYS_NC00024$
ENI_DBI_CO_DNUM_MV_N1 NONUNIQUE APPS_TS_SUMMARY ORGANIZATION_ID
ITEM_ID
CREATION_DATE
Columns
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
CREATION_DATE DATE

The Initiation Date of the Change Order
IMPLEMENTATION_DATE DATE

The Implementation Date of the Change Order
CANCELLATION_DATE DATE

The Cancellation Date of the Change Order
APPROVAL_DATE DATE

The Approval Date of the Change Order
NEED_BY_DATE DATE

The Date by which this Change Order is Needed to be implemented
CNT NUMBER

Dummy column to make the MV Fast Refreshable

[top of page]

APPS.ENI_DBI_CO_DNUM_MV does not reference any database object

APPS.ENI_DBI_CO_DNUM_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_CO_DNUM_MV
MATERIALIZED VIEW - ENI_DBI_CO_UNION_MV

[top of page]

Table: ENI_DBI_CO_NEW_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ENI_DBI_CO_NEW_MV UNIQUE APPS_TS_SUMMARY SYS_NC00002$
Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

[top of page]

APPS.ENI_DBI_CO_NEW_MV does not reference any database object

APPS.ENI_DBI_CO_NEW_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_CO_NEW_MV

[top of page]

Table: ENI_DBI_CO_NUM_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ENI_DBI_CO_NUM_MV UNIQUE APPS_TS_SUMMARY SYS_NC00017$
SYS_NC00018$
SYS_NC00019$
SYS_NC00020$
SYS_NC00021$
SYS_NC00022$
SYS_NC00023$
SYS_NC00024$
SYS_NC00025$
SYS_NC00026$
SYS_NC00027$
SYS_NC00028$
SYS_NC00029$
SYS_NC00030$
SYS_NC00031$
Columns
Name Datatype Length Mandatory Comments
CHANGE_NOTICE VARCHAR2 (10)
The Name of the Change Order
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
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
CREATION_DATE DATE

The Initiation Date of the Change Order
IMPLEMENTATION_DATE DATE

The Implementation Date of the Change Order
CANCELLATION_DATE DATE

The Cancellation Date of the Change Order
APPROVAL_DATE DATE

The Approval Date of the Change Order
NEED_BY_DATE DATE

The Date by which this Change Order is Needed to be implemented
CNT NUMBER

Dummy column to make the MV Fast Refreshable
ASSIGNEE_ID NUMBER

The Id of the Assignee for this Change Order
DESCRIPTION VARCHAR2 (2000)
The Description of the Change Order
CHANGE_ID NUMBER

The Unique Change Id of the Change Order

[top of page]

APPS.ENI_DBI_CO_NUM_MV does not reference any database object

APPS.ENI_DBI_CO_NUM_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_CO_DNUM_MV
MATERIALIZED VIEW - ENI_DBI_CO_NUM_MV

[top of page]

Table: ENI_DBI_CO_OBJIDS_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ENI_DBI_CO_OBJIDS_ UNIQUE APPS_TS_SUMMARY SYS_NC00003$
SYS_NC00004$
ENI_DBI_CO_OBJIDS_MV_N1 NONUNIQUE APPS_TS_SUMMARY OBJECT_ID
OBJ_NAME
Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER (15) Y The Object ID of the Item and Item Revision Objects
OBJ_NAME VARCHAR2 (430) Y The Object Name of the Item and Item Revision Objects

[top of page]

APPS.ENI_DBI_CO_OBJIDS_MV does not reference any database object

APPS.ENI_DBI_CO_OBJIDS_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_CO_ALL_MV
MATERIALIZED VIEW - ENI_DBI_CO_OBJIDS_MV

[top of page]

Table: ENI_DBI_CO_SUM_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ENI_DBI_CO_SUM_MV UNIQUE APPS_TS_SUMMARY SYS_NC00037$
SYS_NC00038$
SYS_NC00039$
SYS_NC00040$
SYS_NC00041$
SYS_NC00042$
SYS_NC00043$
SYS_NC00044$
SYS_NC00045$
ENI_DBI_CO_SUM_MV_N1 NONUNIQUE APPS_TS_SUMMARY ORGANIZATION_ID
ITEM_ID
TIME_ID
PERIOD_TYPE_ID
Columns
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

[top of page]

APPS.ENI_DBI_CO_SUM_MV does not reference any database object

APPS.ENI_DBI_CO_SUM_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_CO_SUM_MV

[top of page]

Table: ENI_DBI_CO_UNION_MV

Description:
Columns
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

[top of page]

APPS.ENI_DBI_CO_UNION_MV does not reference any database object

APPS.ENI_DBI_CO_UNION_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_CO_NEW_MV
MATERIALIZED VIEW - ENI_DBI_CO_SUM_MV
MATERIALIZED VIEW - ENI_DBI_CO_UNION_MV

[top of page]

Table: ENI_DBI_GL_BASE_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ENI_DBI_GL_BASE_MV UNIQUE APPS_TS_SUMMARY SYS_NC00009$
SYS_NC00010$
SYS_NC00011$
Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

time_id references time_id in FII_TIME_RPT_STRUCT_V view
PRODUCT_CATEGORY_ID NUMBER

Product Category ID. product_category_id references parent_id in ENI_DENORM_HIERARCHIES
LINE_OF_BUSINESS_ID NUMBER

line_of_business_id references id in FII_LOB_V view
PRIM_ACTUAL_G NUMBER

Other Expense Amount in the Global Primary Currency
CNT_PRIM_ACTUAL_G NUMBER

Dummy column to make the MView fast refreshable
SEC_ACTUAL_G NUMBER

Other Expense Amount in the Global Secondary Currency
CNT_SEC_ACTUAL_G NUMBER

Dummy column to make the Mview fast refreshable
COUNT(*) NUMBER

Dummy column to make MV fast refreshable

[top of page]

APPS.ENI_DBI_GL_BASE_MV does not reference any database object

APPS.ENI_DBI_GL_BASE_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_GL_BASE_MV
MATERIALIZED VIEW - ENI_DBI_GL_BASE_SUM_MV
MATERIALIZED VIEW - ENI_DBI_PRC_UNION_MV

[top of page]

Table: ENI_DBI_GL_BASE_SUM_C_MV

Description:
Indexes
Index Type Tablespace Column
ENI_DBI_GL_BASE_SUM_C_MV_U1 UNIQUE APPS_TS_SUMMARY MARKER
TIME_ID
PARENT_PROD_CAT_ID
CHILD_PROD_CAT_ID
Columns
Name Datatype Length Mandatory Comments
PARENT_PROD_CAT_ID NUMBER

Parent Product Category Id
CHILD_PROD_CAT_ID NUMBER

Child Product Category ID. References id in ENI_ITEM_VBH_NODES_V
TIME_ID NUMBER

time_id references time_id in FII_TIME_RPT_STRUCT_V view
PRIM_ACTUAL_G NUMBER

Other Expense Amount in the Global Currency
CNT_PRIM_ACTUAL_G NUMBER

Dummy column to make the MView fast refreshable
SEC_ACTUAL_G NUMBER

Other Expense Amount in the Secondary Currency
CNT_SEC_ACTUAL_G NUMBER

Dummy column to make the MView fast refreshable
COUNT(*) NUMBER

Dummy column to make the MView fast refreshable
MARKER NUMBER

marker identifies the top level product_category summarization and child level summarizations

[top of page]

APPS.ENI_DBI_GL_BASE_SUM_C_MV does not reference any database object

APPS.ENI_DBI_GL_BASE_SUM_C_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_GL_BASE_SUM_C_MV

[top of page]

Table: ENI_DBI_GL_BASE_SUM_MV

Description:
Indexes
Index Type Tablespace Column
ENI_DBI_GL_BASE_SUM_MV_U1 UNIQUE APPS_TS_SUMMARY MARKER
GID
TIME_ID
PRODUCT_CATEGORY_ID
LINE_OF_BUSINESS_ID
Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

time_id references time_id in FII_TIME_RPT_STRUCT_V view
LINE_OF_BUSINESS_ID NUMBER

line_of_business_id references id in FII_LOB_V view
PRODUCT_CATEGORY_ID NUMBER

Product Category ID. product_category_id references parent_id in ENI_DENORM_HIERARCHIES
PRIM_ACTUAL_G NUMBER

Other Expense Amount in the Global Currency
CNT_PRIM_ACTUAL_G NUMBER

Dummy column to make the MView fast refreshable
SEC_ACTUAL_G NUMBER

Other Expense Amount in the Secondary Currency
CNT_SEC_ACTUAL_G NUMBER

Dummy column to make the MView fast refreshable
COUNT(*) NUMBER

Dummy column to make MView fast refreshable
GID NUMBER

GROUPING SET value of various combination of time_id, product_category_id, line_of_business_id
MARKER NUMBER

marker identifies the row summarized based on time_id, product_category_id or line_of_business_id

[top of page]

APPS.ENI_DBI_GL_BASE_SUM_MV does not reference any database object

APPS.ENI_DBI_GL_BASE_SUM_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_GL_BASE_SUM_C_MV
MATERIALIZED VIEW - ENI_DBI_GL_BASE_SUM_MV

[top of page]

Table: ENI_DBI_INV_BASE_MV

Description:
Indexes
Index Type Tablespace Column
ENI_DBI_INV_BASE_MV_U1 UNIQUE APPS_TS_SUMMARY TIME_ID
ITEM_MASTER_ORG_ID
ITEM_ORG_ID
ITEM_CATEGORY_ID
I_SNAP$_ENI_DBI_INV_BASE_M UNIQUE APPS_TS_SUMMARY SYS_NC00038$
SYS_NC00039$
SYS_NC00040$
SYS_NC00041$
SYS_NC00042$
SYS_NC00043$
SYS_NC00044$
SYS_NC00045$
SYS_NC00046$
SYS_NC00047$
SYS_NC00048$
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
ITEM_ORG_ID VARCHAR2 (81)
Item Organization Identifier
ITEM_MASTER_ORG_ID VARCHAR2 (81)
Item Master Organization Identifier
ITEM_CATEGORY_ID NUMBER

Item Category Identifier
TIME_ID NUMBER

Nested Grouping ID Column for Time
YEAR_ID NUMBER

FII Year Identifier
QTR_ID NUMBER

FII Quarter Identifier
MONTH_ID NUMBER

FII Month Identifier
WEEK_ID NUMBER

FII Week Identifier
DAY_ID NUMBER

FII Day Identifier
ONHAND_VALUE_G NUMBER

Value of onhand inventory in Primary Global Currency
COUNT_OVG NUMBER

Count Column
ONHAND_VALUE_B NUMBER

Value of onhand inventory in Functional Currency
COUNT_OVB NUMBER

Count Column
INTRANSIT_VALUE_G NUMBER

Value of in-transit inventory in Primary Global Currency
COUNT_IVG NUMBER

Count Column
INTRANSIT_VALUE_B NUMBER

Value of in-transit inventory in Functional Currency
COUNT_IVB NUMBER

Count Column
WIP_VALUE_G NUMBER

Value of WIP inventory in Primary Global Currency
COUNT_WVG NUMBER

Count Column
WIP_VALUE_B NUMBER

Value of WIP inventory in Functional Currency
COUNT_WVB NUMBER

Count Column
INV_TOTAL_VALUE_G NUMBER

Value of total inventory in Primary Global Currency
COUNT_I_T_V_G NUMBER

Count Column
INV_TOTAL_VALUE_B NUMBER

Value of total inventory in Functional Currency
COUNT_I_T_V_B NUMBER

Count Column
ONHAND_VALUE_SG NUMBER

Value of onhand inventory in Secondary Global Currency
CNT_ONHAND_VALUE_SG NUMBER

Count Column
INTRANSIT_VALUE_SG NUMBER

Value of in-transit inventory in Secondary Global Currency
CNT_INTRANSIT_VALUE_SG NUMBER

Count Column
WIP_VALUE_SG NUMBER

Value of WIP inventory in Secondary Global Currency
CNT_WIP_VALUE_SG NUMBER

Count Column
INV_TOTAL_VALUE_SG NUMBER

Value of total inventory in Secondary Global Currency
CNT_INV_TOTAL_VALUE_SG NUMBER

Count Column
COUNT_TOTAL NUMBER

Count Column
GRP_ID NUMBER

Grouping ID Column

[top of page]

APPS.ENI_DBI_INV_BASE_MV does not reference any database object

APPS.ENI_DBI_INV_BASE_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_INV_BASE_MV
MATERIALIZED VIEW - ENI_DBI_INV_SUM_MV

[top of page]

Table: ENI_DBI_INV_SUM_MV

Description:
Indexes
Index Type Tablespace Column
ENI_DBI_INV_SUM_MV_U1 UNIQUE APPS_TS_SUMMARY MARKER
TIME_ID
ITEM_ORG_ID
PRODUCT_CATEGORY_ID
ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

Nested Grouping ID Column for Time
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
PRODUCT_CATEGORY_ID NUMBER

Product Category Identifier
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
ITEM_ORG_ID VARCHAR2 (81)
Item Organization Identifier
ONHAND_VALUE_G NUMBER

Value of onhand inventory in Primary Global Currency
CNT_ONHAND_VALUE_G NUMBER

Count Column
INTRANSIT_VALUE_G NUMBER

Value of in-transit inventory in Primary Global Currency
CNT_INTRANSIT_VALUE_G NUMBER

Count Column
WIP_VALUE_G NUMBER

Value of WIP inventory in Primary Global Currency
CNT_WIP_VALUE_G NUMBER

Count Column
INV_TOTAL_VALUE_G NUMBER

Value of total inventory in Primary Global Currency
CNT_INV_TOTAL_VALUE_G NUMBER

Count Column
ONHAND_VALUE_SG NUMBER

Value of onhand inventory in Secondary Global Currency
CNT_ONHAND_VALUE_SG NUMBER

Count Column
INTRANSIT_VALUE_SG NUMBER

Value of in-transit inventory in Secondary Global Currency
CNT_INTRANSIT_VALUE_SG NUMBER

Count Column
WIP_VALUE_SG NUMBER

Value of WIP inventory in Secondary Global Currency
CNT_WIP_VALUE_SG NUMBER

Count Column
INV_TOTAL_VALUE_SG NUMBER

Value of total inventory in Secondary Global Currency
CNT_INV_TOTAL_VALUE_SG NUMBER

Count Column
COUNT_TOTAL NUMBER

Count Column
GID NUMBER

Grouping ID Column
MARKER NUMBER

Marker Column

[top of page]

APPS.ENI_DBI_INV_SUM_MV does not reference any database object

APPS.ENI_DBI_INV_SUM_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_INV_SUM_MV

[top of page]

Table: ENI_DBI_MFG_STEPS_JOIN_MV

Description:
Indexes
Index Type Tablespace Column
ENI_DBI_MFG_STEPS_JOIN_MV_U1 UNIQUE APPS_TS_SUMMARY ORGANIZATION_ID
ITEM_ID
ITEM_ORG_ID
EFFECTIVITY_DATE
DISABLE_DATE
I_SNAP$_ENI_DBI_MFG_STEPS_ UNIQUE APPS_TS_SUMMARY SYS_NC00007$
SYS_NC00008$
SYS_NC00009$
SYS_NC00010$
Columns
Name Datatype Length Mandatory Comments
ITEM_ORG_ID VARCHAR2 (81)
Item-Org Id of the routing
ITEM_ID NUMBER
Y Inventory Item id of the Routing
ORGANIZATION_ID NUMBER
Y Organization id of the Routing
EFFECTIVITY_DATE DATE
Y effectivity date
DISABLE_DATE DATE

disable date
MFGSTEPS_COUNT NUMBER

Number of operations of the routing effective between effectivity_date and disable_date

[top of page]

APPS.ENI_DBI_MFG_STEPS_JOIN_MV does not reference any database object

APPS.ENI_DBI_MFG_STEPS_JOIN_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_MFG_STEPS_JOIN_MV

[top of page]

Table: ENI_DBI_ORG_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ENI_DBI_ORG_MV UNIQUE APPS_TS_SUMMARY SYS_NC00006$
SYS_NC00007$
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Y Organization id
MASTER_ORGANIZATION_ID NUMBER

Master Organization id
DUMMY_ORGANIZATION_ID NUMBER
Y Dummy Organization Id. It is same as master organization id
SUM(ORGANIZATION_ID) NUMBER

Dummy Column to make MV fast refreshable
COUNT(ORGANIZATION_ID) NUMBER

Dummy Column to make MV fast refreshable

[top of page]

APPS.ENI_DBI_ORG_MV does not reference any database object

APPS.ENI_DBI_ORG_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_INV_BASE_MV
MATERIALIZED VIEW - ENI_DBI_INV_SUM_MV
MATERIALIZED VIEW - ENI_DBI_ORG_MV
MATERIALIZED VIEW - ENI_DBI_PRC_UNION_MV

[top of page]

Table: ENI_DBI_PART_COUNT_MV

Description:
Indexes
Index Type Tablespace Column
ENI_DBI_PART_COUNT_MV_U1 UNIQUE APPS_TS_SUMMARY ORGANIZATION_ID
ASSEMBLY_ITEM_ID
EFFECTIVITY_DATE
DISABLE_DATE
MAX_BOM_LEVEL
PART_COUNT
I_SNAP$_ENI_DBI_PART_COUNT UNIQUE APPS_TS_SUMMARY SYS_NC00007$
SYS_NC00008$
SYS_NC00009$
SYS_NC00010$
Columns
Name Datatype Length Mandatory Comments
ASSEMBLY_ITEM_ID NUMBER

Item id of the assembly (or Bill)
ORGANIZATION_ID NUMBER

Organization id of the assembly (or Bill)
EFFECTIVITY_DATE DATE

Effectivity date
DISABLE_DATE DATE

Disable date
MAX_BOM_LEVEL NUMBER

Max BOM Level of the components of the assembly that are effective between effectivity_date and disable_date
PART_COUNT NUMBER

Number of components of the assembly effective between effectivity_date and disable_date

[top of page]

APPS.ENI_DBI_PART_COUNT_MV does not reference any database object

APPS.ENI_DBI_PART_COUNT_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_PART_COUNT_MV

[top of page]

Table: ENI_DBI_PRC_SUM1_MV

Description:
Indexes
Index Type Tablespace Column
ENI_DBI_PRC_SUM1_MV_U1 UNIQUE APPS_TS_SUMMARY TIME_ID
ITEM_ORG_ID
PRODUCT_CATEGORY_ID
INVENTORY_ITEM_ID
ORGANIZATION_ID
I_SNAP$_ENI_DBI_PRC_SUM1_M UNIQUE APPS_TS_SUMMARY SYS_NC00019$
SYS_NC00020$
SYS_NC00021$
SYS_NC00022$
SYS_NC00023$
Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

Time id
INVENTORY_ITEM_ID NUMBER

Inventory Item id
PRODUCT_CATEGORY_ID NUMBER

Product Category id
ORGANIZATION_ID NUMBER

Organization id
ITEM_ORG_ID VARCHAR2 (81)
Item-org id
REV_AMOUNT NUMBER

Revenue for organization item in Primary Currency
CNT_REV_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
REV_SEC_AMOUNT NUMBER

Revenue for organization item in Secondary Currency
CNT_REV_SEC_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
EXP_AMOUNT NUMBER

Other Expenses for oganization item in Primary Currency
CNT_EXP_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
EXP_SEC_AMOUNT NUMBER

Other Expenses for organization item in Secondary Currency
CNT_EXP_SEC_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
COGS_AMOUNT NUMBER

Cost Of Goods Sold for organization in Primary Currency
CNT_COGS_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
COGS_SEC_AMOUNT NUMBER

Cost Of Goods Sold for organization item in Secondary Currency
CNT_COGS_SEC_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
COUNT(*) NUMBER

Dummy column to make materialized view fast refreshable

[top of page]

APPS.ENI_DBI_PRC_SUM1_MV does not reference any database object

APPS.ENI_DBI_PRC_SUM1_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_PRC_SUM1_MV
MATERIALIZED VIEW - ENI_DBI_PRC_SUM2_MV

[top of page]

Table: ENI_DBI_PRC_SUM2_MV

Description:
Indexes
Index Type Tablespace Column
ENI_DBI_PRC_SUM2_MV_U1 UNIQUE APPS_TS_SUMMARY MARKER
TIME_ID
PRODUCT_CATEGORY_ID
Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

Time id
INVENTORY_ITEM_ID NUMBER

Inventory Item id
PRODUCT_CATEGORY_ID NUMBER

Product Category id
ORGANIZATION_ID NUMBER

Organization id
ITEM_ORG_ID CHAR (2)
Item-org id
REV_AMOUNT NUMBER

Revenue for item-org on time_id in Primary Currency
CNT_REV_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
REV_SEC_AMOUNT NUMBER

Revenue for item-org on time_id in Secondary Currency
CNT_REV_SEC_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
EXP_AMOUNT NUMBER

Other Expenses on time_id in Primary Currency
CNT_EXP_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
EXP_SEC_AMOUNT NUMBER

Other Expenses on time_id in Secondary Currency
CNT_EXP_SEC_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
COGS_AMOUNT NUMBER

Cost Of Goods Sold for item-org on time_id in Primary Currency
CNT_COGS_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
COGS_SEC_AMOUNT NUMBER

Cost Of Goods Sold for item-org on time_id in Secondary Currency
CNT_COGS_SEC_AMOUNT NUMBER

Dummy column to make materialized view fast refreshable
COUNT(*) NUMBER

Dummy column to make materialized view fast refreshable
MARKER NUMBER

Used to distinguish between various summarization levels in the MV definition

[top of page]

APPS.ENI_DBI_PRC_SUM2_MV does not reference any database object

APPS.ENI_DBI_PRC_SUM2_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_PRC_SUM2_MV

[top of page]

Table: ENI_DBI_PRC_UNION_MV

Description:
Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

Time id
INVENTORY_ITEM_ID NUMBER

Inventory Item id
PRODUCT_CATEGORY_ID NUMBER

Product Category id
ORGANIZATION_ID NUMBER

Organization id
ITEM_ORG_ID VARCHAR2 (81)
Item-org id
REV_PRIM_ACTUAL_G NUMBER

Revenue for item-org in Primary Currency
CNT_REV_PRIM_ACTUAL_G NUMBER

Dummy column to make materialized view fast refreshable
REV_SEC_ACTUAL_G NUMBER

Revenue for item-org in Secondary Currency
CNT_REV_SEC_ACTUAL_G NUMBER

Dummy column to make materialized view fast refreshable
PRIM_ACTUAL_G NUMBER

Other Expenses for item-org in Primary Currency
CNT_PRIM_ACTUAL_G NUMBER

Dummy column to make materialized view fast refreshable
SEC_ACTUAL_G NUMBER

Other Expenses for item-org in Secondary Currency
CNT_SEC_ACTUAL_G NUMBER

Dummy column to make materialized view fast refreshable
COGS_VALUE_G NUMBER

Cost Of Goods Sold for item-org in Primary Currency
CNT_COGS_VALUE_G NUMBER

Dummy column to make materialized view fast refreshable
COGS_VALUE_SG NUMBER

Cost Of Goods Sold for item-org in Secondary Currency
CNT_COGS_VALUE_SG NUMBER

Dummy column to make materialized view fast refreshable
INV_TOTAL_VALUE_G NUMBER

Total Inventory Value on Hand
CNT_TOTAL_VALUE_G NUMBER

Dummy column to make materialized view fast refreshable
COUNT(*) NUMBER

Dummy column to make materialized view fast refreshable
MARKER NUMBER

Used to distinguish between different summarizations

[top of page]

APPS.ENI_DBI_PRC_UNION_MV does not reference any database object

APPS.ENI_DBI_PRC_UNION_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_PRC_SUM1_MV
MATERIALIZED VIEW - ENI_DBI_PRC_UNION_MV

[top of page]

Table: ENI_DBI_TOB_MV

Description:
Indexes
Index Type Tablespace Column
ENI_DBI_TOB_MV_N1 NONUNIQUE APPS_TS_SUMMARY ITEM_CATEGORY_ID
ITEM_ID
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ID NUMBER

The Customer ID of the Customer for the Sales Order
RESOURCE_ID NUMBER

The Resource ID for Sales Order
SALES_GRP_ID NUMBER

The Group ID of the Sales group to which the Sales Person belongs
ORDER_NUMBER NUMBER

The Order Number of the Sales Order
LINE_NUMBER VARCHAR2 (240)
The Line Number of the current Order Number of the Sales Order
ITEM_CATEGORY_ID NUMBER

The ID of the Item Catalog Category to which the Item on which the Sales Order is logged belongs to
ITEM_ID VARCHAR2 (25)
The Id of the Item on which the Sales Order is logged
BOOKED_DATE DATE

The Date on which the Sales Order was Booked
SCHEDULE_DATE DATE

The Scheduled Date for the Sales Order
BOOKED_AMT_G NUMBER

The Sale Amount for the Current Line in the Current Sales Order in the Primary Currency
BOOKED_AMT_G1 NUMBER

The Sale Amount for the Current Line in the Current Sales Order in the Secondary Currency
RANK_PROD_ITEM NUMBER

The Column used to rank the Sales Order for every combination of Product Product Category
RANK_ALL NUMBER

The Column used to rank the Sales Order based on amount

[top of page]

APPS.ENI_DBI_TOB_MV does not reference any database object

APPS.ENI_DBI_TOB_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_TOB_MV

[top of page]

Table: ENI_DBI_TOO_MV

Description:
Indexes
Index Type Tablespace Column
ENI_DBI_TOO_MV_N1 NONUNIQUE APPS_TS_SUMMARY PRODUCT_CATEGORY_ID
ITEM_ID
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_ID NUMBER

The Customer ID of Customer on whom this Opportunity is logged
OPTY_ID NUMBER
Y The Opportunity ID
SALES_CREDIT_AMT NUMBER

The Amount of the Current Sales Opportunity in the Primary Currency
SALES_CREDIT_AMT_S NUMBER

The Amount of the Current Sales Opportunity in the Secondary Currency
WIN_PROBABILITY NUMBER

The Probability in percent of winning this Sale Opportunity
CLOSE_DATE DATE

The Date for the Sale Opportunity when it would get closed
PRODUCT_CATEGORY_ID NUMBER

The ID of the Item Catalog Category to which the Item on which the Sale Opportunity is logged belongs to
ITEM_ID VARCHAR2 (25)
The Id of the Item on which the Sale Opportunity is logged
SALESREP_ID NUMBER

The ID of the Sales person
SALES_GROUP_ID NUMBER

The Group ID of the Sales group to which the Sales Person belongs
RANK_PROD_ITEM NUMBER

The Column used to rank the Sale Opportunity for every combination of Product Product Category
RANK_ALL NUMBER

The Column used to rank the Sale Opportunity on Amount

[top of page]

APPS.ENI_DBI_TOO_MV does not reference any database object

APPS.ENI_DBI_TOO_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_DBI_TOO_MV

[top of page]

Table: ENI_RES_1_MV

Description:
Columns
Name Datatype Length Mandatory Comments
MARKER NUMBER

This indicates where the current record is coming from in the Union All
RESDEPT_ROWID ROWID (10)
Rowid of the current row in the BOM_DEPARTMENT_RESOURCES table
RES_ROWID ROWID (10)
Rowid of the current row in the BOM_RESOURCES table
DEPT_ROWID ROWID (10)
Rowid of the current row in the BOM_DEPARTMENTS table
RESOURCE_ID NUMBER

Manufacturing Resource Unique Identifier
RESOURCE_CODE VARCHAR2 (10)
Manufacturing Resource Code
BOM_RESOURCE_TYPE NUMBER

BOM Resource Type
ORGANIZATION_ID NUMBER

Manufacturing Organization Identifier
UNIT_OF_MEASURE VARCHAR2 (3)
Unit Of Measure
DEPARTMENT_ID NUMBER

Manufacturing Department Identifier
DEPARTMENT_CODE VARCHAR2 (10)
Manufacturing Department Code
RESOURCE_GROUP VARCHAR2 (30)
Manufacturing Resource Group Identifier
DISABLE_DATE DATE

Disable Date

[top of page]

APPS.ENI_RES_1_MV does not reference any database object

APPS.ENI_RES_1_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_RES_1_MV
MATERIALIZED VIEW - ENI_RES_2_MV
MATERIALIZED VIEW - ENI_RES_3_MV

[top of page]

Table: ENI_RES_2_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ENI_RES_2_MV UNIQUE APPS_TS_SUMMARY SYS_NC00003$
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER

The number of departments this resource is assigned to
NUMBER_RESOURCE NUMBER

Manufacturing Resource Unique Identifier

[top of page]

APPS.ENI_RES_2_MV does not reference any database object

APPS.ENI_RES_2_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_RES_2_MV
MATERIALIZED VIEW - ENI_RES_3_MV

[top of page]

Table: ENI_RES_3_MV

Description:
Indexes
Index Type Tablespace Column
I_SNAP$_ENI_RES_3_MV UNIQUE APPS_TS_SUMMARY SYS_NC00011$
SYS_NC00012$
SYS_NC00013$
SYS_NC00014$
SYS_NC00015$
SYS_NC00016$
SYS_NC00017$
SYS_NC00018$
SYS_NC00019$
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER

Manufacturing Resource Unique Identifier
RESOURCE_CODE VARCHAR2 (10)
Manufacturing Resource Code
BOM_RESOURCE_TYPE NUMBER

BOM Resource Type
ORGANIZATION_ID NUMBER

Manufacturing Organization Identifier
DEPARTMENT_ID NUMBER

Manufacturing Department Identifier
DEPARTMENT_CODE VARCHAR2 (10)
Manufacturing Department Code
RESOURCE_GROUP VARCHAR2 (30)
Manufacturing Resource Group Identifier
UNIT_OF_MEASURE VARCHAR2 (3)
Unit Of Measure
DISABLE_DATE DATE

Disable Date
CNT NUMBER

Dummy Column to make the MV Fast Refreshable

[top of page]

APPS.ENI_RES_3_MV does not reference any database object

APPS.ENI_RES_3_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_RES_3_MV
MATERIALIZED VIEW - ENI_RES_5_MV

[top of page]

Table: ENI_RES_4_MV

Description:
Columns
Name Datatype Length Mandatory Comments
MST_ROWID ROWID (10)
Rowid of the current row in the GMP.CR_RSRC_MST_B table
DTL_ROWID ROWID (10)
Rowid of the current row in the GMP.CR_RSRC_DTL table
RESOURCE_ID NUMBER (10) Y Manufacturing Resource Identifier
RESOURCE_CODE VARCHAR2 (16) Y Code for the resource
ORGANIZATION_ID NUMBER

Organization Identifier
UNIT_OF_MEASURE VARCHAR2 (3)
Unit Of Measure
DEPARTMENT_ID VARCHAR2 (8)
The Identifier of the Resource Class to which the Resource belongs
DEPARTMENT_CODE VARCHAR2 (10)
The Identifier of the Resource Class to which the Resource belongs
RESOURCE_GROUP VARCHAR2 (16) Y The Resource Group to which the Resource belongs
DISABLE_DATE DATE

Disable Date for the Resource

[top of page]

APPS.ENI_RES_4_MV does not reference any database object

APPS.ENI_RES_4_MV is referenced by following:

APPS
MATERIALIZED VIEW - ENI_RES_4_MV
MATERIALIZED VIEW - ENI_RES_5_MV

[top of page]

Table: ENI_RES_5_MV

Description:
Indexes
Index Type Tablespace Column
ENI_RES_5_MV_U1 UNIQUE APPS_TS_SUMMARY ID
ENI_RES_5_MV_N1 NONUNIQUE APPS_TS_SUMMARY ORGANIZATION_ID
DEPARTMENT_ID
RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCE_TYPE CHAR (3)
Marker column to distinguish BOM and OPM resources.
BOM_ROWID ROWID (10)
Rowid of the current row
ID VARCHAR2 (122)
Manufacturing Resource Department Identifier for the Organization
RESOURCE_ID NUMBER

Manufacturing Resource Identifier
RESOURCE_CODE VARCHAR2 (16)
Code for the resource
BOM_RESOURCE_TYPE NUMBER

BOM Resource Type
ORGANIZATION_ID NUMBER

Organization Identifier
DEPARTMENT_ID VARCHAR2 (40)
Manufacturing Department Identifier
DEPARTMENT_FK VARCHAR2 (42)
Manufacturing Department Identifier which takes the Unassigned Departments in consideration
DEPARTMENT_CODE VARCHAR2 (10)
The Identifier of the Resource Class to which the Resource belongs
RESOURCE_GROUP VARCHAR2 (30)
The Resource Group to which the Resource belongs
RESOURCE_GROUP_FK VARCHAR2 (32)
The Resource Group to which the Resource belongs. It identifies whether it is a BOM or an OPM resource Group
UNIT_OF_MEASURE VARCHAR2 (3)
Unit Of Measure
DISABLE_DATE DATE

Disable Date for the Resource

[top of page]

APPS.ENI_RES_5_MV does not reference any database object

APPS.ENI_RES_5_MV is referenced by following:

APPS
VIEW - ENI_RESOURCE_V
MATERIALIZED VIEW - ENI_RES_5_MV
MATERIALIZED VIEW - ISC_DBI_PM_0002_MV
MATERIALIZED VIEW - ISC_DBI_PM_0004_MV
MATERIALIZED VIEW - OPI_DBI_RES_UTL_MV
MATERIALIZED VIEW - OPI_DBI_RES_VAR_MV

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract