[Home] [Help] [Dependency Information]
Object Name: | EDW_MTL_UOM_M |
---|---|
Object Type: | TABLE |
Owner: | OPI |
FND Design Data: | OPI.EDW_MTL_UOM_M |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
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 | Yes | 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 | Yes | Row Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Row Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT ALL_ALL_PK_KEY
, UOM_CONVERSION_RATE
, UOM_EDW_UOM_PK_KEY
, UOM_EDW_BASE_UOM
, UOM_DESCRIPTION
, ALL_NAME
, UOM_NAME
, UOM_UNIT_MEASURE_NAME
, UOM_GLOBAL_FLAG
, ALL_ALL_PK
, UOM_EDW_UOM_DP
, UOM_EDW_UOM_PK
, UOM_USER_ATTRIBUTE1
, UOM_USER_ATTRIBUTE2
, UOM_USER_ATTRIBUTE3
, UOM_USER_ATTRIBUTE4
, UOM_USER_ATTRIBUTE5
, CREATION_DATE
, LAST_UPDATE_DATE
FROM OPI.EDW_MTL_UOM_M;
OPI.EDW_MTL_UOM_M does not reference any database object
OPI.EDW_MTL_UOM_M is referenced by following:
|
|
|