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: --