219: Select decode(length(uom.unit_of_measure), 1, uom.unit_of_measure,
220: 2, uom.unit_of_measure, 3, uom.unit_of_measure,
221: 4, uom.unit_of_measure, uom.uom_code)
222: Into l_rma_lot_opm_uom
223: From oe_order_lines_all , mtl_units_of_measure uom
224: Where header_id = p_oe_header_id
225: And line_id = p_oe_line_id
226: And uom_code = ORDER_QUANTITY_UOM;
227:
244: Select decode(length(uom.unit_of_measure), 1, uom.unit_of_measure,
245: 2, uom.unit_of_measure, 3, uom.unit_of_measure,
246: 4, uom.unit_of_measure, uom.uom_code)
247: Into l_rma_lot_opm_uom
248: From mtl_units_of_measure uom
249: Where uom_code = p_rma_lot_uom;
250:
251: EXCEPTION
252: WHEN OTHERS THEN