create procedure [dbo].[MssWebGetGroupedLineItemsByQuoteId]
    @inQuoteId int
as
begin
    set nocount on;

    select
        QuoteGroup.QuoteGroupID as GroupId,
        QuoteGroup.Description as GroupDescription,
        QuoteGroup.Charge as GroupTotalCharge,
        ISNULL(QuoteGroup.SortOrder, 0) as GroupSortOrder,
        QuoteDetail.QuoteDetailID as LineItemId,
        QuoteDetail.ItemCodeFID as ItemCodeId,
        QuoteDetail.Description as Description,
        QuoteDetail.RateTypeFID as RateTypeId,
        QuoteDetail.LaborRatingTypeFID as RateAsId,
        QuoteDetail.Quantity2 as Quantity2,
        QuoteDetail.Quantity as Quantity1,
        QuoteDetail.Rate as Rate,
        QuoteDetail.Charge as Charge,
        QuoteDetail.NoteText as AccountingNote,
        QuoteDetail.QuoteServiceProviderBillToFID as ThirdPartyPayableQuoteServiceProviderBillToId,
        QuoteDetail.QuoteServiceProviderTypeFID as ThirdPartyPayableQuoteServiceProviderTypeId,
        QuoteDetail.VendorID as ThirdPartyPayableVendorId,
        QuoteDetail.VendorQuotedCharge as ThirdPartyPayableVendorQuotedCharge,
        QuoteDetail.VendorActualCharge as ThirdPartyPayableVendorActualCharge,
        QuoteDetail.PONumber as ThirdPartyPayablePONumber,
        QuoteDetail.InvoiceNumber as ThirdPartyPayableInvoiceNumber,
        QuoteDetail.ServiceDate as ThirdPartyPayableServiceDate,
        
        -- Is Revenue Imported?
        CAST(
            case
                when exists(select 1 from QuoteRevenueImport where QuoteDetailFID = QuoteDetail.QuoteDetailID) then 1 else 0
            end
        as bit) as IsRevenueImported,
        
        ISNULL(QuoteDetail.SortOrder, 0) as SortOrder
    from dbo.QuoteDetail
    inner join dbo.QuoteGroup
        on QuoteGroup.QuoteGroupID = QuoteDetail.QuoteGroupFID
       and QuoteGroup.QuoteHeaderFID = @inQuoteId
    order by SortOrder;
end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetGroupedLineItemsByQuoteId] TO [MssExec]
GO