186: ======================================*/
187:
188: CURSOR get_item_uom IS
189: SELECT primary_uom_code
190: FROM mtl_system_items
191: WHERE organization_id = p_lot_uom_conv_rec.organization_id
192: AND inventory_item_id = p_lot_uom_conv_rec.inventory_item_id;
193:
194: l_item_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;
190: FROM mtl_system_items
191: WHERE organization_id = p_lot_uom_conv_rec.organization_id
192: AND inventory_item_id = p_lot_uom_conv_rec.inventory_item_id;
193:
194: l_item_uom_code MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;
195:
196:
197: /*======================================
198: Cursor to get uom_class for a given