[Home] [Help]
View: EDW_MTL_UOMD_UOM_LCV
| Product: | OPI - Operations Intelligence (Obsolete) |
|---|
| Description: | Source View for the UOM level of the UOM Dimension |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT UOM.UOM_CODE||'-'||INST.INSTANCE_CODE
, INST.INSTANCE_CODE
, UOM.UOM_CLASS
, UOM.UNIT_OF_MEASURE
, UOM.UOM_CODE
, UOM.BASE_UOM_FLAG
, UOM.DESCRIPTION
, UOM.DISABLE_DATE
, 'UNIT_OF_MEASURE'
, 'UNIT_OF_MEASURE'
, UOM.CREATION_DATE
, UOM.LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MTL_UNITS_OF_MEASURE UOM
, EDW_LOCAL_INSTANCE INST
Columns
| Name |
| UOM_PK |
| INSTANCE_CODE |
| UOM_CLASS |
| UNIT_MEASURE_NAME |
| UOM_CODE |
| BASE_UNIT_FLAG |
| DESCRIPTION |
| END_EFFECT_DATE |
| UOM_DP |
| NAME |
| CREATION_DATE |
| LAST_UPDATE_DATE |
| USER_ATTRIBUTE1 |
| USER_ATTRIBUTE2 |
| USER_ATTRIBUTE3 |
| USER_ATTRIBUTE4 |
| USER_ATTRIBUTE5 |