DBA Data[Home] [Help]

VIEW: APPS.INVFV_UNITS_OF_MEASURE

Source

View Text - Preformatted

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
View Text - HTML Formatted

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