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 - OPI Tables and Views

TABLE - OPI.EDW_MTL_ILDM_LOCATOR_LSTG
TABLE - OPI.EDW_MTL_ILDM_LOCATOR_LTC
TABLE - OPI.EDW_MTL_ILDM_OU_LSTG
TABLE - OPI.EDW_MTL_ILDM_OU_LTC
TABLE - OPI.EDW_MTL_ILDM_PCMP_LSTG
TABLE - OPI.EDW_MTL_ILDM_PCMP_LTC
TABLE - OPI.EDW_MTL_ILDM_PLANT_LSTG
TABLE - OPI.EDW_MTL_ILDM_PLANT_LTC
TABLE - OPI.EDW_MTL_ILDM_PORG_LSTG
TABLE - OPI.EDW_MTL_ILDM_PORG_LTC
TABLE - OPI.EDW_MTL_ILDM_SUB_INV_LSTG
TABLE - OPI.EDW_MTL_ILDM_SUB_INV_LTC
TABLE - OPI.EDW_MTL_INVENTORY_LOC_A_LTC
TABLE - OPI.EDW_MTL_INVENTORY_LOC_M
TABLE - OPI.EDW_MTL_LOCAL_UOM_M
TABLE - OPI.EDW_MTL_UOMD_UOM_LTC
TABLE - OPI.EDW_MTL_UOM_A_LTC
TABLE - OPI.EDW_MTL_UOM_M
TABLE - OPI.EDW_OPI_ACTV_ACTV_LSTG
TABLE - OPI.EDW_OPI_ACTV_ACTV_LTC
TABLE - OPI.EDW_OPI_ACTV_A_LTC
TABLE - OPI.EDW_OPI_ACTV_M
TABLE - OPI.EDW_OPI_LOTD_LOT_LSTG
TABLE - OPI.EDW_OPI_LOTD_LOT_LTC
TABLE - OPI.EDW_OPI_LOT_A_LTC
TABLE - OPI.EDW_OPI_LOT_M
TABLE - OPI.EDW_OPI_OPRN_A_LTC
TABLE - OPI.EDW_OPI_OPRN_M
TABLE - OPI.EDW_OPI_OPRN_OPRC_LSTG
TABLE - OPI.EDW_OPI_OPRN_OPRC_LTC
TABLE - OPI.EDW_OPI_OPRN_OPRN_LSTG
TABLE - OPI.EDW_OPI_OPRN_OPRN_LTC
TABLE - OPI.EDW_OPI_PRDL_A_LTC
TABLE - OPI.EDW_OPI_PRDL_M
TABLE - OPI.EDW_OPI_PRDL_PRDL_LSTG
TABLE - OPI.EDW_OPI_PRDL_PRDL_LTC

Table: EDW_MTL_ILDM_LOCATOR_LSTG

Description: Staging Table for the LOCATOR level of the ILDM (Inventory Locator Dimension)
Comments

Staging Table for the LOCATOR level of the ILDM (Inventory Locator Dimension)

Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_LOCATOR_LSTG_N1 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
COLLECTION_STATUS VARCHAR2 (30)
Collection Status [EDW tracking attribute] of this row
CREATION_DATE DATE

Creation Date of Inventory Location record on OLTP
DESCRIPTION VARCHAR2 (500)
Description of Inventory Location
ENABLED_FLAG VARCHAR2 (20)
Indicates whether Locator is active
ERROR_CODE VARCHAR2 (2000)
No Longer Used
INSTANCE_CODE VARCHAR2 (40)
Instance from which this row was pushed
LAST_UPDATE_DATE DATE

Last Update Date of Inventory Location record on OLTP
LOCATOR_DP VARCHAR2 (240)
EDW-internal ID for Locator
LOCATOR_NAME VARCHAR2 (500)
Locator Name
LOCATOR_PK VARCHAR2 (320)
Primary Key for Location (unique across instances and source-types)
NAME VARCHAR2 (2000)
Locator Name
OPERATION_CODE VARCHAR2 (30)
EDW-internal Indicator for operation to perform
REQUEST_ID NUMBER

Standard Row WHO Column
ROW_ID VARCHAR2 (20)
EDW-internal key for processing row
STOCK_ROOM_FK VARCHAR2 (240)
Source System FK for SubInventory Level
STOCK_ROOM_FK_KEY NUMBER

EDW (Surrogate) key for the SubInventory Level
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Location record on OLTP

[top of page]

OPI.EDW_MTL_ILDM_LOCATOR_LSTG does not reference any database object

OPI.EDW_MTL_ILDM_LOCATOR_LSTG is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_LOCATOR_LSTG#

[top of page]

Table: EDW_MTL_ILDM_LOCATOR_LTC

Description: Level Table for the LOCATOR level of the ILDM (Inventory Locator Dimension)
Primary Key: EDW_MTL_ILDM_LOCATOR_LTC_U
  1. LOCATOR_PK
Primary Key: EDW_MTL_ILDM_LOCATOR_LTC_UKEY
  1. LOCATOR_PK_KEY
Comments

Level Table for the LOCATOR level of the ILDM (Inventory Locator Dimension)

Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_LOCATOR_LTC_U UNIQUE APPS_TS_SUMMARY LOCATOR_PK
EDW_MTL_ILDM_LOCATOR_LTC_UKEY UNIQUE APPS_TS_SUMMARY LOCATOR_PK_KEY
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Y Creation Date of Inventory Location record on OLTP
DESCRIPTION VARCHAR2 (240)
Description of Inventory Location
ENABLED_FLAG VARCHAR2 (20)
Indicates whether Locator is active
INSTANCE_CODE VARCHAR2 (40)
Instance from which this row was pushed
LAST_UPDATE_DATE DATE
Y Last Update Date of Inventory Location record on OLTP
LOCATOR_DP VARCHAR2 (240)
EDW-internal ID for Locator
LOCATOR_NAME VARCHAR2 (240)
Locator Name
LOCATOR_PK VARCHAR2 (320)
Primary Key for Location (unique across instances and source-types)
LOCATOR_PK_KEY NUMBER

EDW-assigned surrogate for Locator
NAME VARCHAR2 (2000)
Locator Name
STOCK_ROOM_FK VARCHAR2 (240)
Source System FK for SubInventory Level
STOCK_ROOM_FK_KEY NUMBER

EDW (Surrogate) key for the SubInventory Level
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Location record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Location record on OLTP

[top of page]

OPI.EDW_MTL_ILDM_LOCATOR_LTC does not reference any database object

OPI.EDW_MTL_ILDM_LOCATOR_LTC is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_LOCATOR_LTC#

[top of page]

Table: EDW_MTL_ILDM_OU_LSTG

Description: Staging Table for the OU (Operating Unit) level of the ILDM (Inventory Locator Dimension)
Comments

Staging Table for the OU (Operating Unit) level of the ILDM (Inventory Locator Dimension)

Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_OU_LSTG_N1 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
ALL_FK VARCHAR2 (40)
Foriegn Key to the All Level
ALL_FK_KEY NUMBER

EDW-assigned Surrogate Foreign Key to the All Level
BUSINESS_GROUP VARCHAR2 (500)
Business Group that Operating Unit belongs to
COLLECTION_STATUS VARCHAR2 (30)
Collection Status [EDW tracking attribute] of this row
CREATION_DATE DATE

Creation Date of Inventory Location record on OLTP
DATE_FROM DATE

Beginning validity date for Operating Unit
DATE_TO DATE

Ending validity date for Operating Unit
ERROR_CODE VARCHAR2 (2000)
No Longer Used
INSTANCE VARCHAR2 (40)
Instance from which this row was pushed
INT_EXT_FLAG VARCHAR2 (120)
Flag indicates if Operating Unit is Internal or External
LAST_UPDATE_DATE DATE

Last Update Date of Inventory Location record on OLTP
NAME VARCHAR2 (500)
Operating Unit Name
OPERATING_UNIT_DP VARCHAR2 (500)
EDW-internal ID for Operating Unit
OPERATING_UNIT_PK VARCHAR2 (240)
Primary Key of Operating Unit
OPERATING_UNIT_PK_KEY NUMBER

EDW-internal Surrogate Key for Operating Unit
OPERATION_CODE VARCHAR2 (30)
EDW-internal Indicator for operation to perform
ORG_CODE VARCHAR2 (120)
Operating Unit Code
ORG_TYPE VARCHAR2 (80)
Organization Type of Operating Unit
PRIMARY_CST_MTHD VARCHAR2 (120)
Cost Method for Operating Unit
REQUEST_ID NUMBER

Standard Row WHO Column
ROW_ID VARCHAR2 (40)
EDW-internal key for processing row
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Operating Unit record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Operating Unit record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Operating Unit record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Operating Unit record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Operating Unit record on OLTP

[top of page]

OPI.EDW_MTL_ILDM_OU_LSTG does not reference any database object

OPI.EDW_MTL_ILDM_OU_LSTG is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_OU_LSTG#

[top of page]

Table: EDW_MTL_ILDM_OU_LTC

Description: Level Table for the OU (Operating Unit) level of the ILDM (Inventory Locator Dimension)
Primary Key: EDW_MTL_ILDM_OU_LTC_U
  1. OPERATING_UNIT_PK
Primary Key: EDW_MTL_ILDM_OU_LTC_UK
  1. OPERATING_UNIT_PK_KEY
Comments

Level Table for the OU (Operating Unit) level of the ILDM (Inventory Locator Dimension)

Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_OU_LTC_U NONUNIQUE APPS_TS_SUMMARY OPERATING_UNIT_PK
EDW_MTL_ILDM_OU_LTC_UK NONUNIQUE APPS_TS_SUMMARY OPERATING_UNIT_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ALL_FK_KEY NUMBER

EDW-assigned Surrogate Foreign Key to the All Level
BUSINESS_GROUP VARCHAR2 (120)
Business Group that Operating Unit belongs to
CREATION_DATE DATE
Y Creation Date of Inventory Location record on OLTP
DATE_FROM DATE

Beginning validity date for Operating Unit
DATE_TO DATE

Ending validity date for Operating Unit
INSTANCE VARCHAR2 (40)
Instance from which this row was pushed
INT_EXT_FLAG VARCHAR2 (120)
Flag indicates if Operating Unit is Internal or External
LAST_UPDATE_DATE DATE
Y Last Update Date of Inventory Location record on OLTP
NAME VARCHAR2 (320)
Operating Unit Name
OPERATING_UNIT_DP VARCHAR2 (240)
EDW-internal ID for Operating Unit
OPERATING_UNIT_PK VARCHAR2 (240)
Primary Key of Operating Unit
OPERATING_UNIT_PK_KEY NUMBER
Y EDW-internal Surrogate Key for Operating Unit
ORG_CODE VARCHAR2 (120)
Operating Unit Code
ORG_TYPE VARCHAR2 (120)
Organization Type of Operating Unit
PRIMARY_CST_MTHD VARCHAR2 (120)
Cost Method for Operating Unit
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Operating Unit record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Operating Unit record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Operating Unit record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Operating Unit record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Operating Unit record on OLTP

[top of page]

OPI.EDW_MTL_ILDM_OU_LTC does not reference any database object

OPI.EDW_MTL_ILDM_OU_LTC is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_OU_LTC#

[top of page]

Table: EDW_MTL_ILDM_PCMP_LSTG

Description: Staging Table for the PCMP (Process Company) level of the ILDM (Inventory Locator Dimension)
Comments

Staging Table for the PCMP (Process Company) level of the ILDM (Inventory Locator Dimension)

Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_PCMP_LSTG_N1 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
COLLECTION_STATUS VARCHAR2 (30)
Collection Status [EDW tracking attribute] of this row
CREATION_DATE DATE

Creation Date of Inventory Location record on OLTP
DESCRIPTION VARCHAR2 (500)
Description of Inventory Organization Parent Group
ERROR_CODE VARCHAR2 (2000)
No Longer Used
INSTANCE_CODE VARCHAR2 (40)
Instance from which this row was pushed
LAST_UPDATE_DATE DATE

Last Update Date of Inventory Location record on OLTP
NAME VARCHAR2 (500)
Inventory Organization Parent Group Name
OPERATING_UNIT_FK VARCHAR2 (120)
Foreign Key to Operating Unit Level (next higher level in dimension)
OPERATING_UNIT_FK_KEY NUMBER

Surrogate Foreign key to Operating Unit level
OPERATION_CODE VARCHAR2 (30)
EDW-internal Indicator for operation to perform
OPM_COMPANY_CODE VARCHAR2 (120)
Organization Code of the Inventory Organization Parent Group
OPM_COMPANY_DP VARCHAR2 (240)
EDW-internal ID for Inventory Organization Parent Group
OPM_COMPANY_NAME VARCHAR2 (500)
Name of the Inventory Organization Parent Group
OPM_COMPANY_PK VARCHAR2 (120)
Primary Key of Inventory Organization Parent Group, unique across instances and system types
OPM_COMPANY_PK_KEY NUMBER

Surrogate Primary Key for Inventory Organization Parent Group, EDW-assigned
REQUEST_ID NUMBER

Standard Row WHO Column
ROW_ID VARCHAR2 (20)
EDW-internal ID for Inventory Organization Parent Group
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Org Parent Group record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Org Parent Group record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Org Parent Group record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Org Parent Group record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Org Parent Group record on OLTP

[top of page]

OPI.EDW_MTL_ILDM_PCMP_LSTG does not reference any database object

OPI.EDW_MTL_ILDM_PCMP_LSTG is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_PCMP_LSTG#

[top of page]

Table: EDW_MTL_ILDM_PCMP_LTC

Description: Level Table for the PCMP (Process Company) level of the ILDM (Inventory Locator Dimension)
Primary Key: EDW_MTL_ILDM_PCMP_P
  1. OPM_COMPANY_PK_KEY
Primary Key: EDW_MTL_ILDM_PCMP_U1
  1. OPM_COMPANY_PK
Comments

Level Table for the PCMP (Process Company) level of the ILDM (Inventory Locator Dimension)

Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_PCMP_P UNIQUE APPS_TS_SUMMARY OPM_COMPANY_PK_KEY
EDW_MTL_ILDM_PCMP_U1 UNIQUE APPS_TS_SUMMARY OPM_COMPANY_PK
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Y Creation Date of Inventory Location record on OLTP
DESCRIPTION VARCHAR2 (240)
Description of Inventory Organization Parent Group
INSTANCE_CODE VARCHAR2 (40)
Instance from which this row was pushed
LAST_UPDATE_DATE DATE
Y Last Update Date of Inventory Location record on OLTP
NAME VARCHAR2 (320)
Name of the Inventory Organization Parent Group
OPERATING_UNIT_FK_KEY NUMBER

Surrogate Foreign key to Operating Unit level
OPM_COMPANY_CODE VARCHAR2 (120)
Organization Code of the Inventory Organization Parent Group
OPM_COMPANY_DP VARCHAR2 (240)
EDW-internal ID for Inventory Organization Parent Group
OPM_COMPANY_NAME VARCHAR2 (500)
Name of the Inventory Organization Parent Group
OPM_COMPANY_PK VARCHAR2 (120)
Primary Key of Inventory Organization Parent Group, unique across instances and system types
OPM_COMPANY_PK_KEY NUMBER

Surrogate Primary Key for Inventory Organization Parent Group, EDW-assigned
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Organization Parent Group record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Organization Parent Group record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Organization Parent Group record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Organization Parent Group record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Organization Parent Group record on OLTP

[top of page]

OPI.EDW_MTL_ILDM_PCMP_LTC does not reference any database object

OPI.EDW_MTL_ILDM_PCMP_LTC is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_PCMP_LTC#

[top of page]

Table: EDW_MTL_ILDM_PLANT_LSTG

Description: Staging Table for the Inventory Org level of the ILDM (Inventory Locator Dimension)
Comments
Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_PLANT_LSTG_N1 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
COLLECTION_STATUS VARCHAR2 (30)
CREATION_DATE DATE

DESCRIPTION VARCHAR2 (500)
ERROR_CODE VARCHAR2 (2000)
INSTANCE_CODE VARCHAR2 (40)
LAST_UPDATE_DATE DATE

NAME VARCHAR2 (2000)
OPERATING_UNIT_FK VARCHAR2 (500)
OPERATING_UNIT_FK_KEY NUMBER

OPERATION_CODE VARCHAR2 (30)
OPM_ORGANIZATION_FK VARCHAR2 (200)
OPM_ORGANIZATION_FK_KEY NUMBER

ORGANIZATION_CODE VARCHAR2 (40)
ORGANIZATION_NAME VARCHAR2 (500)
PLANT_DP VARCHAR2 (240)
PLANT_PK VARCHAR2 (120)
REQUEST_ID NUMBER

ROW_ID NUMBER

USER_ATTRIBUTE1 VARCHAR2 (240)
USER_ATTRIBUTE2 VARCHAR2 (240)
USER_ATTRIBUTE3 VARCHAR2 (240)
USER_ATTRIBUTE4 VARCHAR2 (240)
USER_ATTRIBUTE5 VARCHAR2 (240)

[top of page]

OPI.EDW_MTL_ILDM_PLANT_LSTG does not reference any database object

OPI.EDW_MTL_ILDM_PLANT_LSTG is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_PLANT_LSTG#

[top of page]

Table: EDW_MTL_ILDM_PLANT_LTC

Description: Level Table for the Inventory Org level of the ILDM (Inventory Locator Dimension)
Primary Key: EDW_MTL_ILDM_PLANT_LTC_U
  1. PLANT_PK
Primary Key: EDW_MTL_ILDM_PLANT_LTC_UKEY
  1. PLANT_PK_KEY
Comments

Level Table for the Inventory Org level of the ILDM (Inventory Locator Dimension)

Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_PLANT_LTC_U UNIQUE APPS_TS_SUMMARY PLANT_PK
EDW_MTL_ILDM_PLANT_LTC_UKEY UNIQUE APPS_TS_SUMMARY PLANT_PK_KEY
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Y Creation Date of Inventory Organization record on OLTP
DESCRIPTION VARCHAR2 (240)
Description of Inventory Organization
INSTANCE_CODE VARCHAR2 (40)
Instance from which this row was pushed
LAST_UPDATE_DATE DATE
Y Last Update Date of Inventory Organization record on OLTP
NAME VARCHAR2 (2000)
Name of Inventory Organization
OPERATING_UNIT_FK_KEY NUMBER

EDW-Assigned Surrogate Foreign Key to Operating Unit Level
OPM_ORGANIZATION_FK_KEY NUMBER

EDW-Assigned Surrogate Foreign Key to Inventory Org Group Level
ORGANIZATION_CODE VARCHAR2 (40)
Organization Code of Inventory Organization
ORGANIZATION_NAME VARCHAR2 (240)
Organization Name of Inventory Organization
PLANT_DP VARCHAR2 (240)
EDW-Internal Key for Inventory Organization
PLANT_PK VARCHAR2 (120)
Primary Key for Inventory Organization (include Instance)
PLANT_PK_KEY NUMBER

EDW-Assigned Surrogate Primary Key for Inventory Organization
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Organization record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Organization record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Organization record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Organization record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Organization record on OLTP

[top of page]

OPI.EDW_MTL_ILDM_PLANT_LTC does not reference any database object

OPI.EDW_MTL_ILDM_PLANT_LTC is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_PLANT_LTC#

[top of page]

Table: EDW_MTL_ILDM_PORG_LSTG

Description: Staging Table for the Inventory Organization Group level of the ILDM (Inventory Locator Dimension)
Comments
Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_PORG_LSTG_N1 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
COLLECTION_STATUS VARCHAR2 (30)
CREATION_DATE DATE

DESCRIPTION VARCHAR2 (500)
ERROR_CODE VARCHAR2 (2000)
INSTANCE_CODE VARCHAR2 (40)
LAST_UPDATE_DATE DATE

NAME VARCHAR2 (500)
OPERATION_CODE VARCHAR2 (80)
OPM_COMPANY_FK VARCHAR2 (120)
OPM_COMPANY_FK_KEY NUMBER

OPM_ORGANIZATION_CODE VARCHAR2 (30)
OPM_ORGANIZATION_DP VARCHAR2 (240)
OPM_ORGANIZATION_NAME VARCHAR2 (500)
OPM_ORGANIZATION_PK VARCHAR2 (120)
OPM_ORGANIZATION_PK_KEY NUMBER

REQUEST_ID NUMBER

ROW_ID VARCHAR2 (20)
USER_ATTRIBUTE1 VARCHAR2 (240)
USER_ATTRIBUTE2 VARCHAR2 (240)
USER_ATTRIBUTE3 VARCHAR2 (240)
USER_ATTRIBUTE4 VARCHAR2 (240)
USER_ATTRIBUTE5 VARCHAR2 (240)

[top of page]

OPI.EDW_MTL_ILDM_PORG_LSTG does not reference any database object

OPI.EDW_MTL_ILDM_PORG_LSTG is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_PORG_LSTG#

[top of page]

Table: EDW_MTL_ILDM_PORG_LTC

Description: Level Table for the Inventory Organization Group level of the ILDM (Inventory Locator Dimension)
Primary Key: EDW_MTL_ILDM_PORG_LTC_P
  1. OPM_ORGANIZATION_PK_KEY
Primary Key: EDW_MTL_ILDM_PORG_LTC_U
  1. OPM_ORGANIZATION_PK
Comments

Level Table for the Inventory Organization Group level of the ILDM (Inventory Locator Dimension)

Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_PORG_LTC_P UNIQUE APPS_TS_SUMMARY OPM_ORGANIZATION_PK_KEY
EDW_MTL_ILDM_PORG_LTC_U UNIQUE APPS_TS_SUMMARY OPM_ORGANIZATION_PK
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Y Creation Date of Inventory Organization Group record on OLTP
DESCRIPTION VARCHAR2 (240)
Description of Inventory Organization Group in OLTP
INSTANCE_CODE VARCHAR2 (40)
Instance from which this row was pushed
LAST_UPDATE_DATE DATE
Y Last Update Date of Inventory Location record on OLTP
NAME VARCHAR2 (320)
Name of the Inventory Organization Group
OPM_COMPANY_FK_KEY NUMBER

EDW-internal surrogate key to Company Level
OPM_ORGANIZATION_CODE VARCHAR2 (80)
Inventory Organization Group Code
OPM_ORGANIZATION_DP VARCHAR2 (240)
EDW-internal ID for Organization Group
OPM_ORGANIZATION_NAME VARCHAR2 (240)
Name of the Inventory Organization Group
OPM_ORGANIZATION_PK VARCHAR2 (120)
Primary key of Organization Group (Includes Instance)
OPM_ORGANIZATION_PK_KEY NUMBER

EDW-internal ID for Organization Group
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Process Organization record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Process Organization record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Process Organization record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Process Organization record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Process Organization record on OLTP

[top of page]

OPI.EDW_MTL_ILDM_PORG_LTC does not reference any database object

OPI.EDW_MTL_ILDM_PORG_LTC is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_PORG_LTC#

[top of page]

Table: EDW_MTL_ILDM_SUB_INV_LSTG

Description: Staging Table for the SUB_INV (Sub Inventory) level of the ILDM (Inventory Locator Dimension)
Comments

Staging Table for the SUB_INVI (Sub Inventory) level of the ILDM (Inventory Locator Dimension)

Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_SUB_INV_LSTG_N1 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
COLLECTION_STATUS VARCHAR2 (30)
Collection Status [EDW tracking attribute] of this row
CREATION_DATE DATE

Creation Date of SubInventory record on OLTP
DESCRIPTION VARCHAR2 (500)
Description of SubInventory in OLTP
ERROR_CODE VARCHAR2 (2000)
No Longer Used
INSTANCE_CODE VARCHAR2 (40)
Instance from which this row was pushed
LAST_UPDATE_DATE DATE

Last Update Date of Inventory Location record on OLTP
NAME VARCHAR2 (2000)
SubInventory Name
OPERATION_CODE VARCHAR2 (30)
EDW-internal Indicator for operation to perform
PLANT_FK VARCHAR2 (120)
Foreign Key to Inventory Organization Level
PLANT_FK_KEY NUMBER

EDW-internal Foreign Key to Inventory Organization Level
REQUEST_ID NUMBER

Standard Row WHO Column
ROW_ID VARCHAR2 (20)
EDW-internal ID for Organization Group
STOCK_ROOM VARCHAR2 (80)
SubInventory Name
STOCK_ROOM_DP VARCHAR2 (240)
EDW-internal ID for SubInventory
STOCK_ROOM_PK VARCHAR2 (240)
Primary Key for SubInventory (Includes Instance)
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from SubInventory record on OLTP

[top of page]

OPI.EDW_MTL_ILDM_SUB_INV_LSTG does not reference any database object

OPI.EDW_MTL_ILDM_SUB_INV_LSTG is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_SUB_INV_LSTG#

[top of page]

Table: EDW_MTL_ILDM_SUB_INV_LTC

Description: Level Table for the SUB_INV (Sub Inventory) level of the ILDM (Inventory Locator Dimension)
Primary Key: EDW_MTL_ILDM_SUB_INV_LTC_U
  1. STOCK_ROOM_PK
Primary Key: EDW_MTL_ILDM_SUB_INV_LTC_UKEY
  1. STOCK_ROOM_PK_KEY
Comments

Level Table for the SUB_INV (Sub Inventory) level of the ILDM (Inventory Locator Dimension)

Indexes
Index Type Tablespace Column
EDW_MTL_ILDM_SUB_INV_LTC_U UNIQUE APPS_TS_SUMMARY STOCK_ROOM_PK
EDW_MTL_ILDM_SUB_INV_LTC_UKEY UNIQUE APPS_TS_SUMMARY STOCK_ROOM_PK_KEY
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Y Creation Date of SubInventory record on OLTP
DESCRIPTION VARCHAR2 (240)
Description of SubInventory in OLTP
INSTANCE_CODE VARCHAR2 (40)
Instance from which this row was pushed
LAST_UPDATE_DATE DATE
Y Last Update Date of Inventory Location record on OLTP
NAME VARCHAR2 (2000)
SubInventory Name
PLANT_FK_KEY NUMBER

EDW-internal Foreign Key to Inventory Organization Level
STOCK_ROOM VARCHAR2 (80)
SubInventory Name
STOCK_ROOM_DP VARCHAR2 (240)
EDW-internal ID for SubInventory
STOCK_ROOM_PK VARCHAR2 (240)
Primary Key for SubInventory (Includes Instance)
STOCK_ROOM_PK_KEY NUMBER

EDW-internal Surrogate Primary Key for SubInventory
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from SubInventory record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from SubInventory record on OLTP

[top of page]

OPI.EDW_MTL_ILDM_SUB_INV_LTC does not reference any database object

OPI.EDW_MTL_ILDM_SUB_INV_LTC is referenced by following:

OPI
VIEW - EDW_MTL_ILDM_SUB_INV_LTC#

[top of page]

Table: EDW_MTL_INVENTORY_LOC_A_LTC

Description: Level Table for the A (All) level of the (Inventory Locator Dimension
Primary Key: EDW_MTL_INVENTORY_LOC_A_LTC_U
  1. ALL_PK
Primary Key: EDW_MTL_INVNTRY_LOC_A_LTC_UKEY
  1. ALL_PK_KEY
Comments

Level Table for the A (All) level of the IInventory Locator Dimension

Indexes
Index Type Tablespace Column
EDW_MTL_INVENTORY_LOC_A_LTC_U UNIQUE APPS_TS_SUMMARY ALL_PK
EDW_MTL_INVNTRY_LOC_A_LTC_UKEY UNIQUE APPS_TS_SUMMARY ALL_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ALL_PK VARCHAR2 (40)
Primary Key of the All Level
ALL_PK_KEY NUMBER

EDW-Internal Surrogate Key to the All Level
NAME VARCHAR2 (320)
Name of the All Level
CREATION_DATE DATE
Y Creation Date
LAST_UPDATE_DATE DATE
Y Last Update Date

[top of page]

OPI.EDW_MTL_INVENTORY_LOC_A_LTC does not reference any database object

OPI.EDW_MTL_INVENTORY_LOC_A_LTC is referenced by following:

OPI
VIEW - EDW_MTL_INVENTORY_LOC_A_LTC#

[top of page]

Table: EDW_MTL_INVENTORY_LOC_M

Description: Dimension Table for the(Inventory Locator Dimension
Primary Key: EDW_MTL_INVENTORY_LOC_M_P
  1. INVL_LOCATOR_PK_KEY
Primary Key: EDW_MTL_INVENTORY_LOC_M_U
  1. INVL_LOCATOR_PK
Comments

Dimension Table for the Inventory Locator Dimension

Indexes
Index Type Tablespace Column
EDW_MTL_INVENTORY_LOC_M_P NONUNIQUE APPS_TS_SUMMARY INVL_LOCATOR_PK_KEY
EDW_MTL_INVENTORY_LOC_M_U NONUNIQUE APPS_TS_SUMMARY INVL_LOCATOR_PK
Columns
Name Datatype Length Mandatory Comments
ALL_NAME VARCHAR2 (80)
Name of the All Level
ALL_PK VARCHAR2 (40)
Primary Key of the All Level
ALL_PK_KEY NUMBER

EDW-Internal Surrogate key to the All Level
CREATION_DATE DATE
Y Creation Date
INVL_NAME VARCHAR2 (2000)
Locator Name
INVL_DESCRIPTION VARCHAR2 (240)
Description of Inventory Location
INVL_ENABLED_FLAG VARCHAR2 (20)
Indicates whether Locator is active
INVL_INSTANCE_CODE VARCHAR2 (40)
Instance from which this Locator was pushed
INVL_LOCATOR_DP VARCHAR2 (240)
EDW-internal ID for Locator
INVL_LOCATOR_NAME VARCHAR2 (240)
Locator Name
INVL_LOCATOR_PK VARCHAR2 (320)
Primary Key for Location (unique across instances and source-types)
INVL_LOCATOR_PK_KEY NUMBER
Y EDW-assigned surrogate for Locator
INVL_USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Location record on OLTP
INVL_USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Location record on OLTP
INVL_USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Location record on OLTP
INVL_USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Location record on OLTP
INVL_USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Location record on OLTP
LAST_UPDATE_DATE DATE
Y Last Update Date
OU_BUSINESS_GROUP VARCHAR2 (120)
Business Group attribute of Operating Unit Level
OU_DATE_FROM DATE

Beginning Effective Date for Operating Unit
OU_DATE_TO DATE

Ending Effective Date for Operating Unit
OU_INSTANCE_CODE VARCHAR2 (40)
Instance from which this Operating Unit was pushed
OU_INT_EXT_FLAG VARCHAR2 (120)
Flag indicates if Operating Unit is Internal or External
OU_NAME VARCHAR2 (320)
Operating Unit Name
OU_OPERATING_UNIT_DP VARCHAR2 (240)
EDW-internal ID for Operating Unit
OU_OPERATING_UNIT_PK VARCHAR2 (240)
Primary Key of Operating Unit
OU_OPERATING_UNIT_PK_KEY NUMBER

EDW-internal Surrogate Key for Operating Unit
OU_ORG_CODE VARCHAR2 (40)
Operating Unit Code
OU_ORG_TYPE VARCHAR2 (120)
Organization Type of Operating Unit
OU_PRIMARY_CST_MTHD VARCHAR2 (120)
Cost Method for Operating Unit
OU_USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Operating Unit record on OLTP
OU_USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Operating Unit record on OLTP
OU_USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Operating Unit record on OLTP
OU_USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Operating Unit record on OLTP
OU_USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Operating Unit record on OLTP
PCMP_DESCRIPTION VARCHAR2 (240)
Description of Inventory Organization Parent Group
PCMP_INSTANCE_CODE VARCHAR2 (40)
Instance from which this Parent Group was pushed
PCMP_NAME VARCHAR2 (320)
Name of Inventory Organization Parent Group
PCMP_OPM_COMPANY_PK VARCHAR2 (120)
Inventory Org Parent Group Primary Key (Includes Instance)
PCMP_OPM_COMPANY_CODE VARCHAR2 (40)
Organization Code of the Inventory Organization Parent Group
PCMP_OPM_COMPANY_DP VARCHAR2 (240)
EDW-internal ID for Parent Group
PCMP_OPM_COMPANY_NAME VARCHAR2 (120)
Name of Inventory Organization Parent Group
PCMP_OPM_COMPANY_PK_KEY NUMBER

Primary Key of Parent Group, unique across instances and system types
PCMP_USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Org Parent Group record on OLTP
PCMP_USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Org Parent Group record on OLTP
PCMP_USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Org Parent Group record on OLTP
PCMP_USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Org Parent Group record on OLTP
PCMP_USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Org Parent Group record on OLTP
PLNT_NAME VARCHAR2 (2000)
Name of Inventory Organization
PLNT_ORGANIZATION_NAME VARCHAR2 (240)
Name of Inventory Organization
PLNT_DESCRIPTION VARCHAR2 (240)
Description of Inventory Organization
PLNT_INSTANCE_CODE VARCHAR2 (40)
Instance from which this Inventory Organization was pushed
PLNT_ORGANIZATION_CODE VARCHAR2 (40)
Organization Code of the Inventory Organization
PLNT_PLANT_DP VARCHAR2 (240)
EDW-internal ID for Inventory Organization
PLNT_PLANT_PK VARCHAR2 (120)
Primary Key of Inventory Organization, unique across instances and system types
PLNT_PLANT_PK_KEY NUMBER

EDW-internal Surrogate Key for Inventory Organization
PLNT_USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Organization record on OLTP
PLNT_USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Organization record on OLTP
PLNT_USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Organization record on OLTP
PLNT_USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Organization record on OLTP
PLNT_USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Organization record on OLTP
PORG_DESCRIPTION VARCHAR2 (240)
Description of Inventory Organization Group
PORG_INSTANCE_CODE VARCHAR2 (40)
Instance from which this Inventory Organization Group was pushed
PORG_NAME VARCHAR2 (320)
Name of Inventory Organization Group
PORG_OPM_ORGANIZATION_CODE VARCHAR2 (80)
Organization Code of Inventory Organization Group
PORG_OPM_ORGANIZATION_DP VARCHAR2 (240)
EDW-internal ID for Inventory Organization Group
PORG_OPM_ORGANIZATION_NAME VARCHAR2 (240)
Name of the Inventory Organization Group
PORG_OPM_ORGANIZATION_PK VARCHAR2 (120)
Primary Key of Inventory Organization Group, unique across instances and system types
PORG_OPM_ORGANIZATION_PK_KEY NUMBER

EDW-internal ID for Inventory Organization Group
PORG_USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Inventory Organization Group record on OLTP
PORG_USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Inventory Organization Group record on OLTP
PORG_USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Inventory Organization Group record on OLTP
PORG_USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Inventory Organization Group record on OLTP
PORG_USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Inventory Organization Group record on OLTP
SUBI_NAME VARCHAR2 (2000)
Name of SubInventory
SUBI_DESCRIPTION VARCHAR2 (240)
Description of SubInventory
SUBI_INSTANCE_CODE VARCHAR2 (40)
Instance from which this SubInventory was pushed
SUBI_STOCK_ROOM VARCHAR2 (80)
SubInventory Name
SUBI_STOCK_ROOM_DP VARCHAR2 (240)
EDW-internal ID for SubInventory
SUBI_STOCK_ROOM_PK VARCHAR2 (240)
Primary Key of SubInventory, unique across instances and system types
SUBI_STOCK_ROOM_PK_KEY NUMBER

EDW-internal ID for SubInventory
SUBI_USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from SubInventory record on OLTP
SUBI_USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from SubInventory record on OLTP
SUBI_USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from SubInventory record on OLTP
SUBI_USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from SubInventory record on OLTP
SUBI_USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from SubInventory record on OLTP

[top of page]

OPI.EDW_MTL_INVENTORY_LOC_M does not reference any database object

OPI.EDW_MTL_INVENTORY_LOC_M is referenced by following:

OPI
VIEW - EDW_MTL_INVENTORY_LOC_M#

[top of page]

Table: EDW_MTL_LOCAL_UOM_M

Description: Local Table of EDW_MTL_UOM_M (Unit Of Measure) Dimension within a source system
Comments

Local Table of EDW_MTL_UOM_M (Unit Of Measure) Dimension within a source system. This works as a local copy of warehouse UOM data to allow better performance for the UOM APIs.

Indexes
Index Type Tablespace Column
EDW_MTL_LOCAL_UOM_M_N1 NONUNIQUE APPS_TS_SUMMARY UOM_EDW_UOM_PK
Columns
Name Datatype Length Mandatory Comments
UOM_EDW_UOM_PK VARCHAR2 (40)
Unique identifier
UOM_GLOBAL_FLAG VARCHAR2 (20)
Flag to determine if the conversion is global across EDW or if it is specific to a particular instance
UOM_EDW_BASE_UOM VARCHAR2 (20)
Unit of Measure code of the Base Unit of Measure
UOM_CONVERSION_RATE NUMBER

Conversion rate between the Unit of Measure and its Base Unit of Measure
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER
Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column

[top of page]

OPI.EDW_MTL_LOCAL_UOM_M does not reference any database object

OPI.EDW_MTL_LOCAL_UOM_M is referenced by following:

OPI
VIEW - EDW_MTL_LOCAL_UOM_M#

[top of page]

Table: EDW_MTL_UOMD_UOM_LTC

Description: This is the Unit Of Measure level table in the Unit Of Measure Dimension.
Comments

This is the Unit Of Measure level table in the Unit Of Measure Dimension.

Columns
Name Datatype Length Mandatory Comments
EDW_UOM_PK_KEY NUMBER

System generated unique identifier
ALL_FK_KEY NUMBER

System generated foreign key to the top level of the Unit Of Measure Dimension
CONVERSION_RATE NUMBER

Conversion rate between the Unit Of Measure and Base Unit Of Measure
EDW_BASE_UOM VARCHAR2 (20)
Unit Of Measure code for Base Unit Of Measure
DESCRIPTION VARCHAR2 (240)
Description of Unit Of Measure
ALL_FK VARCHAR2 (40)
Foreign key to the top level of the Unit Of Measure Dimension
NAME VARCHAR2 (2000)
Unit Of Measure name
UNIT_MEASURE_NAME VARCHAR2 (80)
Unit Of Measure name
GLOBAL_FLAG VARCHAR2 (20)
Flag to determine Global/Instance specific conversion
EDW_UOM_DP VARCHAR2 (240)
Unique Unit Of Measure name
EDW_UOM_PK VARCHAR2 (80)
Unique identifier. Represents the Unit Of Measure code.
USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column

[top of page]

OPI.EDW_MTL_UOMD_UOM_LTC does not reference any database object

OPI.EDW_MTL_UOMD_UOM_LTC is referenced by following:

OPI
VIEW - EDW_MTL_UOMD_UOM_LTC#

[top of page]

Table: EDW_MTL_UOM_A_LTC

Description: Top level table for Unit Of Measure dimension
Comments

This is the top level table for the Unit Of Measure dimension

Columns
Name Datatype Length Mandatory Comments
ALL_PK_KEY NUMBER

System generated unique identifier in the top level of the Unit Of Measure dimension
ALL_PK VARCHAR2 (40)
Unique identifier in the top level of the Unit Of Measure dimension
NAME VARCHAR2 (80)
Unit Of Measure name
CREATION_DATE DATE
Y Row Who Column
LAST_UPDATE_DATE DATE
Y Row Who Column

[top of page]

OPI.EDW_MTL_UOM_A_LTC does not reference any database object

OPI.EDW_MTL_UOM_A_LTC is referenced by following:

OPI
VIEW - EDW_MTL_UOM_A_LTC#

[top of page]

Table: EDW_MTL_UOM_M

Description: Unit Of Measure dimension
Primary Key: EDW_MTL_UOM_M_PK
  1. UOM_EDW_UOM_PK_KEY
Comments

This is the denormalized star table for the Unit Of Measure dimension. It contains records for the lowest level of the Unit Of Measure dimension and their parentage up to the top level, across all hierarchies.

Columns
Name Datatype Length Mandatory Comments
ALL_ALL_PK_KEY NUMBER

System generated unique identifier in the top level of the Unit Of Measure dimension
UOM_CONVERSION_RATE NUMBER

Conversion rate between the EDW Unit Of Measure and EDW Base Unit Of Measure
UOM_EDW_UOM_PK_KEY NUMBER
Y System generated unique identifier
UOM_EDW_BASE_UOM VARCHAR2 (20)
Unit Of Measure code user key
UOM_DESCRIPTION VARCHAR2 (240)
Description of the Unit Of Measure
ALL_NAME VARCHAR2 (80)
Unit Of Measure Name in the top level
UOM_NAME VARCHAR2 (80)
Unit Of Measure name
UOM_UNIT_MEASURE_NAME VARCHAR2 (80)
Unit Of Measure name
UOM_GLOBAL_FLAG VARCHAR2 (20)
Flag to determine Global/Instance specific conversion
ALL_ALL_PK VARCHAR2 (40)
Unique identifier in the top level of the Unit Of Measure dimension
UOM_EDW_UOM_DP VARCHAR2 (240)
Unique Unit Of Measure name
UOM_EDW_UOM_PK VARCHAR2 (40)
Unique identifier in the Unit Of Measure level
UOM_USER_ATTRIBUTE1 VARCHAR2 (240)
User attribute
UOM_USER_ATTRIBUTE2 VARCHAR2 (240)
User attribute
UOM_USER_ATTRIBUTE3 VARCHAR2 (240)
User attribute
UOM_USER_ATTRIBUTE4 VARCHAR2 (240)
User attribute
UOM_USER_ATTRIBUTE5 VARCHAR2 (240)
User attribute
CREATION_DATE DATE
Y Row Who Column
LAST_UPDATE_DATE DATE
Y Row Who Column

[top of page]

OPI.EDW_MTL_UOM_M does not reference any database object

OPI.EDW_MTL_UOM_M is referenced by following:

OPI
VIEW - EDW_MTL_UOM_M#

[top of page]

Table: EDW_OPI_ACTV_ACTV_LSTG

Description: Activity DimensionStaging Table
Comments

Activity DimensionStaging Table

Columns
Name Datatype Length Mandatory Comments
ACTV_CODE VARCHAR2 (80)
Activity Code
ACTV_DP VARCHAR2 (240)
Discoverer displayed column
ACTV_NAME VARCHAR2 (80)
Activity name
ACTV_PK VARCHAR2 (40)
Activity user key. This is a combination of Activity , Instance and Product-Tag
ACTV_PK_KEY NUMBER

Surrogate key, PK for the level. Overrides the ID column generated by OWB
ALL_FK VARCHAR2 (40)
All FK
ALL_FK_KEY NUMBER

Surrogate key, PK for the level. Overrides the ID column generated by OWB
COLLECTION_STATUS VARCHAR2 (30)
EDW Collection Status
COST_ANALYSIS_CODE VARCHAR2 (10)
Cost Analysis Code for this activity, for example, this is a value added or non-value added activity
CREATION_DATE DATE

Who Column
DESCRIPTION VARCHAR2 (240)
Activity Description
EDW_COLLECTION_DATE DATE

EDW Collection Date
ERROR_CODE VARCHAR2 (2000)
EDW Error Code
LAST_UPDATE_DATE DATE

Who Column
NAME VARCHAR2 (80)
Activity name
REQUEST_ID NUMBER

Concurrent Request ID
ROW_ID VARCHAR2 (20)
EDW Column
USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute1
USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute2
USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute3
USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute4
USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute5
VALUE_ADDED NUMBER

This Filed indicated whether the Activity is value added or Not 0-Indicated Non Value added1- Indicated Value Added
OPERATION_CODE VARCHAR2 (30)
EDW Collection Operation Code

[top of page]

OPI.EDW_OPI_ACTV_ACTV_LSTG does not reference any database object

OPI.EDW_OPI_ACTV_ACTV_LSTG is referenced by following:

OPI
VIEW - EDW_OPI_ACTV_ACTV_LSTG#

[top of page]

Table: EDW_OPI_ACTV_ACTV_LTC

Description: Activity Dimension Level Table
Comments

Activity Dimension Level Table

Indexes
Index Type Tablespace Column
EDW_OPI_ACTV_ACTV_LTC_U UNIQUE APPS_TS_SUMMARY ACTV_PK
ACTV_PK_KEY
EDW_OPI_ACTV_ATCV_LTC_P UNIQUE APPS_TS_SUMMARY ACTV_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ACTV_CODE VARCHAR2 (80)
Activity Code
ACTV_DP VARCHAR2 (240)
Discoverer displayed column
ACTV_NAME VARCHAR2 (80)
Activity name
ACTV_PK VARCHAR2 (40)
Activity user key. This is a combination of Activity , Instance and Product-Tag
ACTV_PK_KEY NUMBER

Surrogate key, PK for the level. Overrides the ID column generated by OWB
ALL_FK_KEY NUMBER

Surrogate Key.
COST_ANALYSIS_CODE VARCHAR2 (10)
Cost Analysis Code for this activity, for example, this is a value added or non-value added activity
CREATION_DATE DATE

Who Column
DESCRIPTION VARCHAR2 (240)
Activity Description
LAST_UPDATE_DATE DATE

Who Column
NAME VARCHAR2 (80)
Displayed name
USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute1
USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute2
USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute3
USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute4
USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute5
VALUE_ADDED NUMBER

This Filed indicated whether the Activity is value added or Not 0-Indicated Non Value added1- Indicated Value Added

[top of page]

OPI.EDW_OPI_ACTV_ACTV_LTC does not reference any database object

OPI.EDW_OPI_ACTV_ACTV_LTC is referenced by following:

OPI
VIEW - EDW_OPI_ACTV_ACTV_LTC#

[top of page]

Table: EDW_OPI_ACTV_A_LTC

Description: Activity Dimension All Level Table
Comments

Activity Dimension All Level Table

Indexes
Index Type Tablespace Column
EDW_OPI_ACTV_A_LTC_P UNIQUE APPS_TS_SUMMARY ALL_PK
ALL_PK_KEY
EDW_OPI_ACTV_A_LTC_U UNIQUE APPS_TS_SUMMARY ALL_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ALL_PK VARCHAR2 (40)
All PK
ALL_PK_KEY NUMBER

ALL PK Surrogate Key
CREATION_DATE DATE

Who Column
LAST_UPDATE_DATE DATE

Who Column
NAME VARCHAR2 (80)
All Level Name

[top of page]

OPI.EDW_OPI_ACTV_A_LTC does not reference any database object

OPI.EDW_OPI_ACTV_A_LTC is referenced by following:

OPI
VIEW - EDW_OPI_ACTV_A_LTC#

[top of page]

Table: EDW_OPI_ACTV_M

Description: Activity Dimensiom contains all the Activities of Discrete and Process Manufacturing.
Comments

Activity Dimensiom contains all the Activities of Discrete and Process Manufacturing.

Indexes
Index Type Tablespace Column
EDW_OPI_ACTV_M_P UNIQUE APPS_TS_SUMMARY ACTV_ACTV_PK
ACTV_ACTV_PK_KEY
EDW_OPI_ACTV_M_U UNIQUE APPS_TS_SUMMARY ACTV_ACTV_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ACTV_ACTV_CODE VARCHAR2 (80)
Activity Code
ACTV_ACTV_DP VARCHAR2 (240)
Discoverer displayed column
ACTV_ACTV_NAME VARCHAR2 (80)
Activity name
ACTV_ACTV_PK VARCHAR2 (40)
Activity user key. This is a combination of Activity , Instance and Product-Tag
ACTV_ACTV_PK_KEY NUMBER

Surrogate key, PK for the level. Overrides the ID column generated by OWB
ACTV_COST_ANALYSIS_CODE VARCHAR2 (10)
Cost Analysis Code for this activity, for example, this is a value added or non-value added activity
ACTV_DESCRIPTION VARCHAR2 (240)
Activity Description
ACTV_NAME VARCHAR2 (80)
Activity name
ACTV_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute1
ACTV_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute2
ACTV_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute3
ACTV_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute4
ACTV_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute5
ACTV_VALUE_ADDED NUMBER

This Filed indicated whether the Activity is value added or Not 0-Indicated Non Value added1- Indicated Value Added
ALL_ALL_PK VARCHAR2 (40)
All PK
ALL_ALL_PK_KEY NUMBER

Surrogate key, PK for the level. Overrides the ID column generated by OWB
ALL_NAME VARCHAR2 (80)
All Level Name
CREATION_DATE DATE

Who Columns
LAST_UPDATE_DATE DATE

Who Columns

[top of page]

OPI.EDW_OPI_ACTV_M does not reference any database object

OPI.EDW_OPI_ACTV_M is referenced by following:

OPI
VIEW - EDW_OPI_ACTV_M#

[top of page]

Table: EDW_OPI_LOTD_LOT_LSTG

Description: Staging Table for the LOT level of the LOTD (Lot Dimension)
Comments

Staging Table for the LOT level of the LOTD (Lot Dimension)

Indexes
Index Type Tablespace Column
EDW_OPI_LOTD_LOT_LSTG_N1 NONUNIQUE APPS_TS_INTERFACE COLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
ALL_FK VARCHAR2 (40)
Foreign Key to the All Level
ALL_FK_KEY NUMBER

EDW-Assigned Surrogate Foreign Key to the All Level
COLLECTION_STATUS VARCHAR2 (30)
Collection Status [EDW tracking attribute] of this row
CREATION_DATE DATE
Y Creation Date of Lot
DESCRIPTION VARCHAR2 (120)
Description of Lot
EDW_LOT_DP VARCHAR2 (240)
EDW-Internal Key for Lot
EDW_LOT_PK VARCHAR2 (130)
Primary Kty to Lot (includes Instance)
EDW_LOT_PK_KEY NUMBER

EDW-Assigned Surrogate Key to Lot
ERROR_CODE VARCHAR2 (2000)
No Longer Used
EXPIRATION_DATE DATE

Expiration Date of Lot
INVENTORY_ITEM_ID NUMBER

Inventory Item ID of Lot
ITEM_REVISION VARCHAR2 (40)
Item Revision of Lot
LAST_UPDATE_DATE DATE
Y Last Update Date of Lot Record on Source System
LOT VARCHAR2 (80)
Lot Number
LOT_NAME VARCHAR2 (130)
Lot Name
NAME VARCHAR2 (120)
Lot Name
NETTABLE_FLAG VARCHAR2 (15)
For future use, Nettable Indicator (for Planning)
OPERATION_CODE VARCHAR2 (30)
EDW-internal Indicator for operation to perform
ORGANIZATION_ID NUMBER

Organization ID of Lot Item Organization
PARENT_LOT VARCHAR2 (80)
Parent Lot, Applicable if Lot is a Sublot
REQUEST_ID NUMBER

Standard Row WHO Column
ROW_ID VARCHAR2 (20)
EDW-internal key for processing row
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Lot record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Lot record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Lot record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Lot record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Lot record on OLTP

[top of page]

OPI.EDW_OPI_LOTD_LOT_LSTG does not reference any database object

OPI.EDW_OPI_LOTD_LOT_LSTG is referenced by following:

OPI
VIEW - EDW_OPI_LOTD_LOT_LSTG#

[top of page]

Table: EDW_OPI_LOTD_LOT_LTC

Description: Level Table for the LOT level of the LOTD (Lot Dimension)
Primary Key: EDW_OPI_LOTD_LOT_LTC_U
  1. EDW_LOT_PK
Primary Key: EDW_OPI_LOTD_LOT_LTC_UK
  1. EDW_LOT_PK_KEY
Comments

Level Table for the LOT level of the LOTD (Lot Dimension)

Indexes
Index Type Tablespace Column
EDW_OPI_LOTD_LOT_LTC_U UNIQUE APPS_TS_SUMMARY EDW_LOT_PK
EDW_OPI_LOTD_LOT_LTC_UK UNIQUE APPS_TS_SUMMARY EDW_LOT_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ALL_FK_KEY NUMBER

EDW-Assigned Surrogate Foreign Key to the All Level
CREATION_DATE DATE
Y Creation Date of Lot
DESCRIPTION VARCHAR2 (80)
Description of Lot
EDW_LOT_DP VARCHAR2 (240)
EDW-Internal Key for Lot
EDW_LOT_PK VARCHAR2 (130)
Primary Key to Lot (includes Instance)
EDW_LOT_PK_KEY NUMBER

EDW-Assigned Surrogate Key to Lot
EXPIRATION_DATE DATE

Expiration Date of Lot
INVENTORY_ITEM_ID NUMBER

Inventory Item ID of Lot
ITEM_REVISION VARCHAR2 (40)
Item Revision of Lot
LAST_UPDATE_DATE DATE
Y Last Update Date of Lot Record on Source System
LOT VARCHAR2 (80)
Lot Number
LOT_NAME VARCHAR2 (80)
Lot Name
NAME VARCHAR2 (120)
Lot Name
NETTABLE_FLAG VARCHAR2 (15)
For future use, Nettable Indicator (for Planning)
ORGANIZATION_ID NUMBER

Organization ID of Lot Item Organization
PARENT_LOT VARCHAR2 (80)
Parent Lot, Applicable if Lot is a Sublot
USER_ATTRIBUTE1 VARCHAR2 (240)
1st Flexfield from Lot record on OLTP
USER_ATTRIBUTE2 VARCHAR2 (240)
2nd Flexfield from Lot record on OLTP
USER_ATTRIBUTE3 VARCHAR2 (240)
3rd Flexfield from Lot record on OLTP
USER_ATTRIBUTE4 VARCHAR2 (240)
4th Flexfield from Lot record on OLTP
USER_ATTRIBUTE5 VARCHAR2 (240)
5th Flexfield from Lot record on OLTP

[top of page]

OPI.EDW_OPI_LOTD_LOT_LTC does not reference any database object

OPI.EDW_OPI_LOTD_LOT_LTC is referenced by following:

OPI
VIEW - EDW_OPI_LOTD_LOT_LTC#

[top of page]

Table: EDW_OPI_LOT_A_LTC

Description: Level Table for the A (All) level of the LOT Dimension
Primary Key: EDW_OPI_LOT_A_LTC_U
  1. ALL_PK
Primary Key: EDW_OPI_LOT_A_LTC_UK
  1. ALL_PK_KEY
Comments

Level Table for the A (All) level of the LOT Dimension

Indexes
Index Type Tablespace Column
EDW_OPI_LOT_A_LTC_U UNIQUE APPS_TS_SUMMARY ALL_PK
EDW_OPI_LOT_A_LTC_UK UNIQUE APPS_TS_SUMMARY ALL_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ALL_PK VARCHAR2 (40)
Primary Key of All Level
ALL_PK_KEY NUMBER
Y EDW-Assigned Surrogate Primary key of All Level
NAME VARCHAR2 (40)
Name of All Level
CREATION_DATE DATE
Y Creation Date
LAST_UPDATE_DATE DATE
Y Last Update Date

[top of page]

OPI.EDW_OPI_LOT_A_LTC does not reference any database object

OPI.EDW_OPI_LOT_A_LTC is referenced by following:

OPI
VIEW - EDW_OPI_LOT_A_LTC#

[top of page]

Table: EDW_OPI_LOT_M

Description: Dimension Table for the LOT Dimension
Primary Key: EDW_OPI_LOT_M_P
  1. LOT_EDW_LOT_PK_KEY
Primary Key: LOTD_EDW_MTL_LOTD_LOT_U
  1. LOT_EDW_LOT_PK
Comments

Dimension Table for the LOT Dimension

Indexes
Index Type Tablespace Column
EDW_OPI_LOT_M_P UNIQUE APPS_TS_SUMMARY LOT_EDW_LOT_PK_KEY
LOTD_EDW_MTL_LOTD_LOT_U UNIQUE APPS_TS_SUMMARY LOT_EDW_LOT_PK
Columns
Name Datatype Length Mandatory Comments
ALL_ALL_PK VARCHAR2 (40)
Primary Key of the All Level
ALL_ALL_PK_KEY NUMBER

EDW-Assigned Surrogate Primary Key for the All Level
ALL_NAME VARCHAR2 (80)
EDW-Internal Key for Name Level
LOT_DESCRIPTION VARCHAR2 (120)
Description of Lot
LOT_EDW_LOT_DP VARCHAR2 (240)
EDW-Internal Key for Lot
LOT_EDW_LOT_PK VARCHAR2 (130)
Primary Key of Lot (Includes Instance)
LOT_EDW_LOT_PK_KEY NUMBER
Y EDW-Assigned Surrogate Primary Key for Lot
LOT_EXPIRATION_DATE DATE

Lot Expiration Date
LOT_INVENTORY_ITEM_ID NUMBER

Inventory Item ID of Lot
LOT_ITEM_REVISION VARCHAR2 (40)
Item Revision of Lot Item
LOT_LOT VARCHAR2 (80)
Lot Number
LOT_LOT_NAME VARCHAR2 (80)
Lot Name
LOT_NAME VARCHAR2 (130)
Lot Name
LOT_NETTABLE_FLAG VARCHAR2 (15)
For Future Use - Nettable (for Planning) Indicator for Lot
LOT_ORGANIZATION_ID NUMBER

Organization ID of Lot Item
LOT_PARENT_LOT VARCHAR2 (80)
Parent Lot, Applicable if Lot is a Sublot
CREATION_DATE DATE
Y Creation Date of Lot
LAST_UPDATE_DATE DATE
Y Last Update Date of Lot Record on Source System
LOT_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute 1
LOT_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute 2
LOT_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute 3
LOT_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute 4
LOT_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute 5

[top of page]

OPI.EDW_OPI_LOT_M does not reference any database object

OPI.EDW_OPI_LOT_M is referenced by following:

OPI
VIEW - EDW_OPI_LOT_M#

[top of page]

Table: EDW_OPI_OPRN_A_LTC

Description: Operation Dimension All Level Table
Comments

Operation Dimension All Level Table

Indexes
Index Type Tablespace Column
EDW_OPI_OPRN_A_LTC_P UNIQUE APPS_TS_SUMMARY ALL_PK
ALL_PK_KEY
EDW_OPI_OPRN_A_LTC_U UNIQUE APPS_TS_SUMMARY ALL_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ALL_PK VARCHAR2 (40)
All PK
ALL_PK_KEY NUMBER

ALL PK Surrogate Key
CREATION_DATE DATE

Who Column
LAST_UPDATE_DATE DATE

Who Column
NAME VARCHAR2 (80)
All Level Name

[top of page]

OPI.EDW_OPI_OPRN_A_LTC does not reference any database object

OPI.EDW_OPI_OPRN_A_LTC is referenced by following:

OPI
VIEW - EDW_OPI_OPRN_A_LTC#

[top of page]

Table: EDW_OPI_OPRN_M

Description: Operations Dimension Table
Comments

Operations Dimension Table

Indexes
Index Type Tablespace Column
EDW_OPI_OPRN_M_P UNIQUE APPS_TS_SUMMARY OPRN_OPRN_PK
OPRN_OPRN_PK_KEY
EDW_OPI_OPRN_M_U UNIQUE APPS_TS_SUMMARY OPRN_OPRN_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ALL_ALL_PK VARCHAR2 (40)
All PK
ALL_ALL_PK_KEY NUMBER

All PK Surrogate Key
ALL_NAME VARCHAR2 (80)
All Name
CREATION_DATE DATE

Who Column
LAST_UPDATE_DATE DATE

Who Column
OPRC_DESCRIPTION VARCHAR2 (80)
Operation Class Description
OPRC_NAME VARCHAR2 (80)
Operation Class Name
OPRC_OPRC_DP VARCHAR2 (240)
Operation Class Discoverer Name
OPRC_OPRC_PK VARCHAR2 (40)
Operation Class PK
OPRC_OPRC_PK_KEY NUMBER

Opeation Class PK Key. Owb Generated
OPRC_USER_ATTRIBUTE1 VARCHAR2 (240)
Operation Class User Attribute1
OPRC_USER_ATTRIBUTE2 VARCHAR2 (240)
Operation Class User Attribute2
OPRC_USER_ATTRIBUTE3 VARCHAR2 (240)
Operation Class User Attribute3
OPRC_USER_ATTRIBUTE4 VARCHAR2 (240)
Operation Class User Attribute4
OPRC_USER_ATTRIBUTE5 VARCHAR2 (240)
Operation Class User Attribute5
OPRN_DEPARTMENT VARCHAR2 (80)
Operation Department
OPRN_DESCRIPTION VARCHAR2 (240)
Opeation Description
OPRN_NAME VARCHAR2 (80)
Operation Name
OPRN_OPRN_DP VARCHAR2 (240)
Operation Discoverer Name
OPRN_OPRN_NAME VARCHAR2 (80)
Operation Name
OPRN_OPRN_PK VARCHAR2 (40)
Operation PK
OPRN_OPRN_PK_KEY NUMBER

Operation PK Key
OPRN_ORGN_CODE VARCHAR2 (80)
Operation Organization Code
OPRN_PROCESS_QTY_UOM VARCHAR2 (40)
UOM in which Opeartion will Process the Qty
OPRN_USER_ATTRIBUTE1 VARCHAR2 (240)
Operation User Attribute1
OPRN_USER_ATTRIBUTE2 VARCHAR2 (240)
Operation User Attribute2
OPRN_USER_ATTRIBUTE3 VARCHAR2 (240)
Operation User Attribute3
OPRN_USER_ATTRIBUTE4 VARCHAR2 (240)
Operation User Attribute4
OPRN_USER_ATTRIBUTE5 VARCHAR2 (240)
Operation User Attribute5

[top of page]

OPI.EDW_OPI_OPRN_M does not reference any database object

OPI.EDW_OPI_OPRN_M is referenced by following:

OPI
VIEW - EDW_OPI_OPRN_M#

[top of page]

Table: EDW_OPI_OPRN_OPRC_LSTG

Description: Operations Class Staging Table
Comments

Operations Class Staging Table

Columns
Name Datatype Length Mandatory Comments
ALL_FK VARCHAR2 (40)
All FK
ALL_FK_KEY NUMBER

All FK Surrogate Key Generated by OWB
COLLECTION_STATUS VARCHAR2 (30)
EDW Collection Status
CREATION_DATE DATE

Who column
DESCRIPTION VARCHAR2 (80)
Operation Class Description
EDW_COLLECTION_DATE DATE

EDW Collection Date
ERROR_CODE VARCHAR2 (2000)
EDW Error Code
LAST_UPDATE_DATE DATE

Who column
NAME VARCHAR2 (80)
Operation Class Name
OPERATION_CODE VARCHAR2 (30)
EDW Operation Code (not Related to Operation Dimension)
OPRC_DP VARCHAR2 (240)
Discovere Operation Class Name
OPRC_PK VARCHAR2 (40)
Operation Class Pk
OPRC_PK_KEY NUMBER

Operation Class PK Key
REQUEST_ID NUMBER

EDW Request ID
ROW_ID VARCHAR2 (20)
EDW Row-Id
USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute1
USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute2
USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute3
USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute4
USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute5

[top of page]

OPI.EDW_OPI_OPRN_OPRC_LSTG does not reference any database object

OPI.EDW_OPI_OPRN_OPRC_LSTG is referenced by following:

OPI
VIEW - EDW_OPI_OPRN_OPRC_LSTG#

[top of page]

Table: EDW_OPI_OPRN_OPRC_LTC

Description: Operation Class Level Table
Comments

Operation Class Level Table

Indexes
Index Type Tablespace Column
EDW_OPI_OPRN_OPRC_LTC_P UNIQUE APPS_TS_SUMMARY OPRC_PK
OPRC_PK_KEY
EDW_OPI_OPRN_OPRC_LTC_U UNIQUE APPS_TS_SUMMARY OPRC_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ALL_FK_KEY NUMBER

All FK Key Surrogate Key
CREATION_DATE DATE

Who Column
DESCRIPTION VARCHAR2 (80)
Operation Class Description
LAST_UPDATE_DATE DATE

Who Column
NAME VARCHAR2 (80)
Operation Class Name
OPRC_DP VARCHAR2 (240)
Discovere Operation Class Name
OPRC_PK VARCHAR2 (40)
Operation Class PK
OPRC_PK_KEY NUMBER

Operation PK Key Generated by OWB
USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute1
USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute2
USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute3
USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute4
USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute5

[top of page]

OPI.EDW_OPI_OPRN_OPRC_LTC does not reference any database object

OPI.EDW_OPI_OPRN_OPRC_LTC is referenced by following:

OPI
VIEW - EDW_OPI_OPRN_OPRC_LTC#

[top of page]

Table: EDW_OPI_OPRN_OPRN_LSTG

Description: Operations Staging Table
Comments

Operations Staging Table

Columns
Name Datatype Length Mandatory Comments
COLLECTION_STATUS VARCHAR2 (30)
EDW Collection Status
CREATION_DATE DATE

Who Column
DEPARTMENT VARCHAR2 (80)
Derpatment to which Operation Belong
DESCRIPTION VARCHAR2 (240)
Operation Description
EDW_COLLECTION_DATE DATE

EDW Collection Date
ERROR_CODE VARCHAR2 (2000)
EDW Error Code
LAST_UPDATE_DATE DATE

Who Column
NAME VARCHAR2 (80)
Operation Name
OPERATION_CODE VARCHAR2 (30)
EDW Operation Code (Not Related to Operation Dimension)
OPRC_FK VARCHAR2 (40)
Operation Class FK
OPRC_FK_KEY NUMBER

Operation Class FK Key
OPRN_DP VARCHAR2 (240)
Discoverer Display Name
OPRN_NAME VARCHAR2 (80)
Operation Name
OPRN_PK VARCHAR2 (40)
Operation PK
OPRN_PK_KEY NUMBER

Operation Primary Key Generated by OWB
ORGN_CODE VARCHAR2 (80)
Organization to which Operation Belong
PROCESS_QTY_UOM VARCHAR2 (40)
UOM in which Operation Process the Qty
REQUEST_ID VARCHAR2 (20)
EDW Request ID
ROW_ID NUMBER

EDW Row ID
USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute1
USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute2
USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute3
USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute4
USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute5

[top of page]

OPI.EDW_OPI_OPRN_OPRN_LSTG does not reference any database object

OPI.EDW_OPI_OPRN_OPRN_LSTG is referenced by following:

OPI
VIEW - EDW_OPI_OPRN_OPRN_LSTG#

[top of page]

Table: EDW_OPI_OPRN_OPRN_LTC

Description: Operations Level Table
Comments

Operations Level Table

Indexes
Index Type Tablespace Column
EDW_OPI_OPRN_OPRN_LTC_P UNIQUE APPS_TS_SUMMARY OPRN_PK
OPRN_PK_KEY
EDW_OPI_OPRN_OPRN_LTC_U UNIQUE APPS_TS_SUMMARY OPRN_PK_KEY
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE

Who Column
DEPARTMENT VARCHAR2 (80)
Department Description
DESCRIPTION VARCHAR2 (240)
Operation Descrioption
LAST_UPDATE_DATE DATE

Who Column
NAME VARCHAR2 (80)
Operation Name
OPRC_FK_KEY NUMBER

OWB Generated Operation Surrogate Key
OPRN_DP VARCHAR2 (240)
Discoverer Operation Name
OPRN_NAME VARCHAR2 (80)
Operation Name
OPRN_PK VARCHAR2 (40)
Operation Primary Key
OPRN_PK_KEY NUMBER

Operation Primary Key Generated by OWB
ORGN_CODE VARCHAR2 (80)
Organization Code to which Operation Belong
PROCESS_QTY_UOM VARCHAR2 (40)
UOM in which Operation can Process the Qty
USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute1
USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute2
USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute3
USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute4
USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute5

[top of page]

OPI.EDW_OPI_OPRN_OPRN_LTC does not reference any database object

OPI.EDW_OPI_OPRN_OPRN_LTC is referenced by following:

OPI
VIEW - EDW_OPI_OPRN_OPRN_LTC#

[top of page]

Table: EDW_OPI_PRDL_A_LTC

Description: Level table for the A(All) level of the Production line dimension.
Comments

Level table for the A(All) level of the Production line dimension.

Indexes
Index Type Tablespace Column
EDW_OPI_PRDL_A_LTC_P UNIQUE APPS_TS_SUMMARY ALL_PK
ALL_PK_KEY
EDW_OPI_PRDL_A_LTC_U UNIQUE APPS_TS_SUMMARY ALL_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ALL_PK VARCHAR2 (40)
User key for all level
ALL_PK_KEY NUMBER

Surrogate Key
CREATION_DATE DATE

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
NAME VARCHAR2 (80)
Displayed name

[top of page]

OPI.EDW_OPI_PRDL_A_LTC does not reference any database object

OPI.EDW_OPI_PRDL_A_LTC is referenced by following:

OPI
VIEW - EDW_OPI_PRDL_A_LTC#

[top of page]

Table: EDW_OPI_PRDL_M

Description: Dimension table for Production Line that is used in Production Analysis. In Discrete Mfg., Assembly lines can be treated as production lines. As of now Process manufacturing does not have any concept of Production line.
Comments

Dimension table for Production Line that is used in Production Analysis. In Discrete Mfg., Assembly lines can be treated as production lines. As of now Process manufacturing does not have any concept of Production line.

Indexes
Index Type Tablespace Column
EDW_OPI_PRDL_M_P UNIQUE APPS_TS_SUMMARY PRDL_PRDL_PK
PRDL_PRDL_PK_KEY
EDW_OPI_PRDL_M_U UNIQUE APPS_TS_SUMMARY PRDL_PRDL_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ALL_ALL_PK VARCHAR2 (40)
User key for all level
ALL_ALL_PK_KEY NUMBER

Surrogate Key
ALL_NAME VARCHAR2 (80)
Displayed name
CREATION_DATE DATE

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
PRDL_DESCRIPTION VARCHAR2 (240)
Production line Description
PRDL_NAME VARCHAR2 (80)
Production line name
PRDL_ORGN_CODE VARCHAR2 (80)
Organization code
PRDL_PRDL_DP VARCHAR2 (240)
Discoverer displayed column
PRDL_PRDL_NAME VARCHAR2 (80)
Displayed name
PRDL_PRDL_PK VARCHAR2 (40)
Production line user key. This is a combination of Production line Id, Organization Id , Instance and Product-Tag
PRDL_PRDL_PK_KEY NUMBER

Surrogate key, PK for the level. Override the ID column generated by OWB
PRDL_PRODUCTION_LINE_CODE VARCHAR2 (30)
Production Line Code
PRDL_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute column
PRDL_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute column
PRDL_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute column
PRDL_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute column
PRDL_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute column

[top of page]

OPI.EDW_OPI_PRDL_M does not reference any database object

OPI.EDW_OPI_PRDL_M is referenced by following:

OPI
VIEW - EDW_OPI_PRDL_M#

[top of page]

Table: EDW_OPI_PRDL_PRDL_LSTG

Description: Level staging table for the Production Line level of the Production Line dimension.
Comments

Level staging table for the Production Line level of the Production Line dimension.

Columns
Name Datatype Length Mandatory Comments
ALL_FK VARCHAR2 (40)
Foreign Key to All Level
ALL_FK_KEY NUMBER

Surrogate Key
COLLECTION_STATUS VARCHAR2 (30)
Loading Status (e.g. READY, COLLECT, COLLECTED, DANGLING, etc.)
CREATION_DATE DATE

Standard who column
DESCRIPTION VARCHAR2 (240)
Production line Description
EDW_COLLECTION_DATE DATE

Loading Time stamp
ERROR_CODE VARCHAR2 (2000)
Loading error code
LAST_UPDATE_DATE DATE

Standard who column
NAME VARCHAR2 (80)
Displayed name
ORGN_CODE VARCHAR2 (80)
Organization code
PRDL_DP VARCHAR2 (240)
Discoverer displayed column
PRDL_NAME VARCHAR2 (80)
Production line name
PRDL_PK VARCHAR2 (40)
Production line user key. This is a combination of Production line Id, Organization Id , Instance and Product-Tag
PRDL_PK_KEY NUMBER

Surrogate key, PK for the level. Override the ID column generated by OWB
PRODUCTION_LINE_CODE VARCHAR2 (30)
Production Line Code
REQUEST_ID NUMBER

concurrent request id
ROW_ID VARCHAR2 (20)
Row id
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute column
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute column
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute column
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute column
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute column
OPERATION_CODE VARCHAR2 (30)
Operation code

[top of page]

OPI.EDW_OPI_PRDL_PRDL_LSTG does not reference any database object

OPI.EDW_OPI_PRDL_PRDL_LSTG is referenced by following:

OPI
VIEW - EDW_OPI_PRDL_PRDL_LSTG#

[top of page]

Table: EDW_OPI_PRDL_PRDL_LTC

Description: Level table for the Production Line level of the Production Line dimension.
Comments

Level table for the Production Line level of the Production Line dimension.

Indexes
Index Type Tablespace Column
EDW_OPI_PRDL_PRDL_LTC_P UNIQUE APPS_TS_SUMMARY PRDL_PK
PRDL_PK_KEY
EDW_OPI_PRDL_PRDL_LTC_U UNIQUE APPS_TS_SUMMARY PRDL_PK_KEY
Columns
Name Datatype Length Mandatory Comments
ALL_FK VARCHAR2 (40)
Foreign Key to All Level
ALL_FK_KEY NUMBER

Surrogate Key
CREATION_DATE DATE

Standard who column
DESCRIPTION VARCHAR2 (240)
Production line Description
LAST_UPDATE_DATE DATE

Standard who column
NAME VARCHAR2 (80)
Displayed name
ORGN_CODE VARCHAR2 (80)
Organization code
PRDL_DP VARCHAR2 (240)
Discoverer displayed column
PRDL_NAME VARCHAR2 (80)
Production line name
PRDL_PK VARCHAR2 (40)
Production line user key. This is a combination of Production line Id, Organization Id , Instance and Product-Tag
PRDL_PK_KEY NUMBER

Surrogate key, PK for the level. Override the ID column generated by OWB
PRODUCTION_LINE_CODE VARCHAR2 (30)
Production Line Code
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute column
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute column
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute column
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute column
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute column

[top of page]

OPI.EDW_OPI_PRDL_PRDL_LTC does not reference any database object

OPI.EDW_OPI_PRDL_PRDL_LTC is referenced by following:

OPI
VIEW - EDW_OPI_PRDL_PRDL_LTC#

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