CREATE procedure [dbo].[MssWebGetGroupedLineItemsByQuoteId]
    @inOrderId int,
    @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,
        ItemCode.Description as ItemCodeDescription,
        ItemCode.ItemCode as ItemCodeValue,
        QuoteDetail.Description as Description,
        QuoteDetail.RateTypeFID as RateTypeId,
        LaborRatingType.TypeName as RateAs,
        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,
        QuoteServiceProviderType.TypeName as ThirdPartyPayableQuoteServiceProviderTypeName,
        dbo.GetQuoteServiceProvider( @inOrderId, QuoteServiceProviderType.TypeName ) as ThirdPartyPayableQuoteServiceProviderName,
        QuoteServiceProviderType.InternationalProviderFlag as ThirdPartyPayableQuoteServiceProviderInternationalFlag,
        QuoteDetail.VendorID as ThirdPartyPayableVendorId,
        Vendor_Synonym.Name as ThirdPartyPayableVendorName,
        Vendor_Synonym.City as ThirdPartyPayableVendorCity,
        Vendor_Synonym.State as ThirdPartyPayableVendorState,
        CAST(
            case
                when exists(select 1 from Vendor_Synonym where Vendor_Synonym.Hold = 'On Hold') then 1 else 0
            end
        as bit)  as ThirdPartyPayableVendorOnHold,


        QuoteDetail.VendorQuotedCharge as ThirdPartyPayableVendorQuotedCharge,
        QuoteDetail.VendorActualCharge as ThirdPartyPayableVendorActualCharge,
        QuoteDetail.PONumber as ThirdPartyPayablePONumber,
        QuoteDetail.InvoiceNumber as ThirdPartyPayableInvoiceNumber,
        QuoteDetail.ServiceDate as ThirdPartyPayableServiceDate,
        QuoteDetail.RateSource as RateSourceType,
        QuoteDetail.RateSourceRecord as RateSourceRecordId,
        
        -- 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
    left outer join LaborRatingType on
        LaborRatingType.LaborRatingTypeID = QuoteDetail.LaborRatingTypeFID
    left outer join ItemCode on
        ItemCode.ICPriKey = QuoteDetail.ItemCodeFID
    left outer join QuoteServiceProviderType on
        QuoteServiceProviderType.QuoteServiceProviderTypeID = QuoteDetail.QuoteServiceProviderTypeFID
    left outer join Vendor_Synonym on
        Vendor_Synonym.VendorID = QuoteDetail.VendorID
    order by SortOrder;
end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetGroupedLineItemsByQuoteId] TO [MssExec]
GO