DBA Data[Home] [Help] [Dependency Information]

TABLE: OPI.EDW_MTL_LOCAL_UOM_M

Object Details
Object Name: EDW_MTL_LOCAL_UOM_M
Object Type: TABLE
Owner: OPI
FND Design Data: TableOPI.EDW_MTL_LOCAL_UOM_M
Subobject Name:
Status: VALID


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.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_MTL_LOCAL_UOM_M_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnUOM_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
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT UOM_EDW_UOM_PK
,      UOM_GLOBAL_FLAG
,      UOM_EDW_BASE_UOM
,      UOM_CONVERSION_RATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM OPI.EDW_MTL_LOCAL_UOM_M;

Dependencies

[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:

SchemaOPI
ViewEDW_MTL_LOCAL_UOM_M#