APPS.INV_SERIAL_PICK_PKG dependencies on MTL_LOT_NUMBERS
Line 316: FROM mtl_lot_numbers
312: -- check lot expiration date. if it is already expired, can't pick it
313: if (l_lot_number is not null ) then
314: BEGIN
315: SELECT expiration_date INTO l_lot_expiration_date 316: FROM mtl_lot_numbers 317: WHERE inventory_item_id = p_inventory_item_id
318: AND organization_id = p_organization_id
319: AND lot_number = l_lot_number;
320: --