Stored procedure to be used to get the vendors based data...