DBA Data[Home] [Help]

APPS.INV_GMI_MIGRATION dependencies on MTL_UNITS_OF_MEASURE

Line 1652: mtl_units_of_measure iu,

1648: INTO l_from_unit_of_measure,
1649: l_from_uom_code,
1650: l_from_uom_class
1651: FROM mtl_system_items_b i,
1652: mtl_units_of_measure iu,
1653: mtl_units_of_measure bu
1654: WHERE
1655: i.organization_id = c.organization_id
1656: AND i.inventory_item_id = l_inventory_item_id

Line 1653: mtl_units_of_measure bu

1649: l_from_uom_code,
1650: l_from_uom_class
1651: FROM mtl_system_items_b i,
1652: mtl_units_of_measure iu,
1653: mtl_units_of_measure bu
1654: WHERE
1655: i.organization_id = c.organization_id
1656: AND i.inventory_item_id = l_inventory_item_id
1657: AND i.primary_uom_code = iu.uom_Code

Line 1665: FROM mtl_units_of_measure

1661: l_field_name := 'To UOM data';
1662: l_field_value := 'UM Type = '||c.um_type;
1663: SELECT unit_of_measure, uom_code
1664: INTO l_to_unit_of_measure, l_to_uom_code
1665: FROM mtl_units_of_measure
1666: WHERE
1667: uom_class = c.um_type AND
1668: base_uom_flag = 'Y';
1669: