Items vendors error

using stored procedure parameters to solve ' issue