create procedure [dbo].[MssWebGetQuoteHeadersByOrderId]
    @inOrderId int
as
begin
    set nocount on;

    select
        QuoteHeader.QuoteHeaderID as Id,
        CONCAT('Q-', QuoteHeader.QuoteHeaderID) as Code,
        QuoteHeader.Description as Description,
        dbo.FormatFirstNameLastName(Sysuser.FIRSTNAME, Sysuser.LASTNAME) as  CreatedBy,
        QuoteHeader.CreatedDate as CreationDate,
        QuoteStatus.Description as Status
    from QuoteHeader
    inner join QuoteStatus on QuoteStatus.QuoteStatusID = QuoteHeader.QuoteStatusFID
    inner join Sysuser on Sysuser.SysUserID = QuoteHeader.CreatedBySysuserFID
    where QuoteHeader.OrdersFID = @inOrderId
end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetQuoteHeadersByOrderId] TO [MssExec]
GO