[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 |
APPS.INVFV_UNITS_OF_MEASURE