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