1410: or
1411: (uom.uom_class <> hr_uom_class)
1412: or
1413: (not exists (select 'No conversion exists'
1414: from mtl_uom_conversions a,
1415: mtl_uom_conversions b
1416: where a.uom_code = uom.uom_code
1417: and a.uom_class = uom.uom_class
1418: and a.inventory_item_id = 0
1411: (uom.uom_class <> hr_uom_class)
1412: or
1413: (not exists (select 'No conversion exists'
1414: from mtl_uom_conversions a,
1415: mtl_uom_conversions b
1416: where a.uom_code = uom.uom_code
1417: and a.uom_class = uom.uom_class
1418: and a.inventory_item_id = 0
1419: and nvl(a.disable_date, sysdate + 1) > sysdate