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

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