1965: CURSOR uom(from_uom VARCHAR2)
1966: IS
1967: SELECT muom.unit_of_measure
1968: , NULL
1969: FROM mtl_units_of_measure muom
1970: , mtl_units_of_measure tuom
1971: WHERE tuom.unit_of_measure = from_uom
1972: AND tuom.uom_class = muom.uom_class
1973: AND muom.base_uom_flag = 'Y';
1966: IS
1967: SELECT muom.unit_of_measure
1968: , NULL
1969: FROM mtl_units_of_measure muom
1970: , mtl_units_of_measure tuom
1971: WHERE tuom.unit_of_measure = from_uom
1972: AND tuom.uom_class = muom.uom_class
1973: AND muom.base_uom_flag = 'Y';
1974: