[Home] [Help] [Dependency Information]
Object Name: | EDW_MTL_LOCAL_UOM_M |
---|---|
Object Type: | TABLE |
Owner: | OPI |
FND Design Data: | OPI.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.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_MTL_LOCAL_UOM_M_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | UOM_EDW_UOM_PK |
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 |
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;
OPI.EDW_MTL_LOCAL_UOM_M does not reference any database object
OPI.EDW_MTL_LOCAL_UOM_M is referenced by following:
|
|
|