CREATE PROCEDURE [dbo].[MssWebGetOrderThirdPartyServices]
@iOrdPriKey int
AS
BEGIN
    SELECT
        t.OrdThirdPartyPriKey,
        t.OrdPriKey,
        t.VendorID,
        t.Amount,
        t.PONumber,
        t.InvoiceNumber,
        t.Description,
        rtrim( v.[Name] ) as VendName,
        t.Date,
        t.InvoiceReceivedDate,
        t.InvoiceApprovedDate
    FROM OrderThirdPartysVendor_Synonym t
    LEFT OUTER JOIN Vendor_Synonym v on (v.VendorJoinField = t.VendorJoinField)
    WHERE t.OrdPriKey = @iOrdPriKey
    ORDER BY v.[Name]
END
GO
GRANT EXECUTE ON  [dbo].[MssWebGetOrderThirdPartyServices] TO [MssExec]
GO