CREATE PROCEDURE [dbo].[MssWebGetOrderThirdPartyServices]
@iOrdPriKey int
AS
BEGIN
    SELECT
        t.OrdThirdPartyPriKey,
        t.OrdPriKey,
        t.VendorID,
        t.Amount,
        t.PONumber,
        t.InvoiceNumber,
        t.Description,
        p.VendName,
        t.Date,
        t.InvoiceReceivedDate,
        t.InvoiceApprovedDate
    FROM OrderThirdPartys t
    LEFT OUTER JOIN PM00200_Synonym p ON(p.VendorID = t.VendorID)
    WHERE t.OrdPriKey = @iOrdPriKey
    ORDER BY p.VendName
END
GO
GRANT EXECUTE ON  [dbo].[MssWebGetOrderThirdPartyServices] TO [MssExec]
GO