UOM Tables Relationship
Units Of Measure Form
Form:INVSDUOM.fmb
Table:MTL_UNITS_OF_MEASURE
MTL_UNITS_OF_MEASUREisthedefinitiontableforboththe25-character andthe3-characterunitsofmeasure.
Thebase_uom_flagindicatesiftheunitofmeasureistheprimaryunit ofmeasurefortheuom_class.
OracleInventoryusesthistablekeeptrackoftheunitsofmeasure thancanbeusedtotransactanitem.Thistableisalsousedby OraclePurchasing,andOracleOrderEntry/Shipping.
Unit Of Measure Classes
Form:INVSDOCL.fmbTable:MTL_UOM_CLASSES
MTL_UOM_CLASSESisthedefinitionoftheunitofmeasureclasses.A classisacategorytowhichunitsofmeasureareassigned.
OracleInventorydefinesthistable,anditisusedbyOracle PurchasingandOracleOrderEntry/Shipping.
Unit Of Measure Conversions
Form:INVSDOUC.fmbTable1:MTL_UOM_CONVERSIONS
MTL_UOM_CONVERSIONSstoresconversionratesbetweennon-baseunitsof measureandtheirbaseunit.Thenon-baseunitsofmeasureare storedinthetable.
Thedefault_conversion_flagindicatesthattheconversionbeing definedis
1)associatedwithaspecificitemand
2)theconversion betweenunitsofmeasurehasalreadybeendefinedasastandard conversionwiththesameconversionrate.
Table2:MTL_UOM_CLASS_CONVERSIONS
MTL_UOM_CLASS_CONVERSIONSiswhereconversionsbetweenbaseunitsof measurearedefinedforanitem.Abaseunitofmeasureistheprimary unitforaclass.
Intra-Class VS Inter-Class
Under Intra-class And Standard Tab,User can only define conversation within same class;Under Inter-class tab, you can define conversation between different base uom which in different UOM class;