1048: SELECT 'Unable to convert'
1049: FROM SYS.DUAL
1050: WHERE NOT EXISTS(
1051: SELECT NULL
1052: FROM MTL_UOM_CONVERSIONS muc1,
1053: MTL_UOM_CONVERSIONS muc2
1054: WHERE muc1.uom_code = p_res_uom_code
1055: AND muc1.uom_class = p_res_uom_class
1056: AND muc1.inventory_item_id = 0
1049: FROM SYS.DUAL
1050: WHERE NOT EXISTS(
1051: SELECT NULL
1052: FROM MTL_UOM_CONVERSIONS muc1,
1053: MTL_UOM_CONVERSIONS muc2
1054: WHERE muc1.uom_code = p_res_uom_code
1055: AND muc1.uom_class = p_res_uom_class
1056: AND muc1.inventory_item_id = 0
1057: AND NVL(muc1.disable_date, SYSDATE + 1) > SYSDATE