[Home] [Help]
View: INVFV_UNITS_OF_MEASURE
View Text
SELECT UN.UNIT_OF_MEASURE
, UN.UOM_CODE
, UN.UOM_CLASS
, '_LA:UN.BASE_UOM_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, UN.DISABLE_DATE
, UN.DESCRIPTION
, '_DF:INV:MTL_UNITS_OF_MEASURE:UN'
, UN.LAST_UPDATE_DATE
, UN.LAST_UPDATED_BY
, UN.CREATION_DATE
, UN.CREATED_BY
FROM MTL_UOM_CLASSES UO
, MTL_UNITS_OF_MEASURE UN
WHERE UN.UOM_CLASS = UO.UOM_CLASS WITH READ ONLY
Columns
Name |
UNIT_OF_MEASURE_NAME |
UOM_CODE |
UOM_CLASS |
"_LA:BASE_UNIT_FLAG" |
END_EFFECTIVE_DATE |
DESCRIPTION |
"_DF" |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |