DBA Data[Home] [Help]

APPS.INV_RESERVATION_VALIDATE_PVT dependencies on MTL_LOT_NUMBERS

Line 2358: FROM mtl_lot_numbers

2354: -- Expired lots custom hook
2355: IF p_lot_number IS NOT NULL AND NOT inv_pick_release_pub.g_pick_expired_lots THEN
2356: BEGIN
2357: SELECT expiration_date INTO l_lot_expiration_date
2358: FROM mtl_lot_numbers
2359: WHERE inventory_item_id = p_inventory_item_id
2360: AND organization_id = p_organization_id
2361: AND lot_number = p_lot_number;
2362: --