172:
173: Cursor C9 (lot_number_in varchar2, org_id_in number, item_id_in number,
174: from_uom_in varchar2, to_uom_in varchar2) is
175: select conversion_id
176: from MTL_LOT_UOM_CLASS_CONVERSIONS
177: where inventory_item_id = item_id_in
178: and organization_id = org_id_in
179: and lot_number = lot_number_in
180: and from_uom_code = from_uom_in
179: and lot_number = lot_number_in
180: and from_uom_code = from_uom_in
181: and to_uom_code = to_uom_in;
182:
183: l_conversion_id mtl_lot_uom_class_conversions.conversion_id%TYPE;
184: -- JD changed query above to get exact conversion.
185:
186: -- SCHANDRU INVCONV END
187: