INV - Unit of Measure

SELECT 
     iuctl.uom_class_tl, 
     iuctl.description 
 FROM 
     INV_UOM_CLASSES_B iucb, 
     INV_UOM_CLASSES_TL iuctl 
 WHERE 
     iucb.uom_class = iuctl.uom_class 
     AND iuctl.language = 'US'; 
  
 SELECT 
     iuomb.uom_code, 
     iuomb.uom_class, 
     iuomb.BASE_UOM_FLAG, 
     iuomtl.unit_of_measure, 
     iuomtl.description, 
     iuctl.uom_class_tl, 
     iuctl.description 
 FROM 
     INV_UNITS_OF_MEASURE_B iuomb, 
     INV_UNITS_OF_MEASURE_TL iuomtl, 
     INV_UOM_CLASSES_B iucb, 
     INV_UOM_CLASSES_TL iuctl 
 WHERE 
     iuomb.unit_of_measure_id = iuomtl.unit_of_measure_id 
     AND iuomtl.language = 'US' 
     AND iucb.uom_class = iuomb.uom_class 
     AND iucb.uom_class = iuctl.uom_class 
     AND iuctl.language = 'US' 
 ORDER BY 
     iuomb.uom_class, 
     iuomb.uom_code; 
  
 SELECT * FROM INV_UOM_CLASS_CONVERSIONS; 
 SELECT * FROM INV_UOM_CONVERSIONS;