404: Select 'x' dummy
405: From dual
406: where not exists(
407: select null
408: from mtl_uom_conversions a,
409: mtl_uom_conversions b
410: where a.uom_code = l_ResUomCode
411: and a.uom_class = l_ResUomClass
412: and a.inventory_item_id = 0
405: From dual
406: where not exists(
407: select null
408: from mtl_uom_conversions a,
409: mtl_uom_conversions b
410: where a.uom_code = l_ResUomCode
411: and a.uom_class = l_ResUomClass
412: and a.inventory_item_id = 0
413: and nvl(a.disable_date, sysdate + 1) > sysdate