APPS.INV_GMI_MIGRATION dependencies on MTL_UNITS_OF_MEASURE

Line 1744: mtl_units_of_measure iu,

1740: INTO l_from_unit_of_measure,
1741: l_from_uom_code,
1742: l_from_uom_class
1743: FROM mtl_system_items_b i,
1744: mtl_units_of_measure iu,
1745: mtl_units_of_measure bu
1746: WHERE
1747: i.organization_id = c.organization_id
1748: AND i.inventory_item_id = l_inventory_item_id

Line 1745: mtl_units_of_measure bu

1741: l_from_uom_code,
1742: l_from_uom_class
1743: FROM mtl_system_items_b i,
1744: mtl_units_of_measure iu,
1745: mtl_units_of_measure bu
1746: WHERE
1747: i.organization_id = c.organization_id
1748: AND i.inventory_item_id = l_inventory_item_id
1749: AND i.primary_uom_code = iu.uom_Code

Line 1757: FROM mtl_units_of_measure

1753: l_field_name := 'To UOM data';
1754: l_field_value := 'UM Type = '||c.um_type;
1755: SELECT unit_of_measure, uom_code
1756: INTO l_to_unit_of_measure, l_to_uom_code
1757: FROM mtl_units_of_measure
1758: WHERE
1759: uom_class = c.um_type AND
1760: base_uom_flag = 'Y';
1761: