UFN_ORDERDELIVERYMETHOD_GETFEESBYSALESMETHOD

CREATE function dbo.UFN_ORDERDELIVERYMETHOD_GETFEESBYSALESMETHOD
(
    @SALESMETHODTYPECODE tinyint
) 
returns table 
as
    return 
        select
            DM.ID,
            FEE.NAME,
            FEE.APPLIESTO,
            FEE.TYPECODE,
            FEE.AMOUNT,
            FEE.[PERCENT]
        from dbo.FEE
        inner join 
            dbo.DELIVERYMETHODFEE as DMF on FEE.ID = DMF.FEEID
        inner join 
            dbo.DELIVERYMETHOD as DM on DMF.DELIVERYMETHODID = DM.ID
        inner join 
            dbo.SALESMETHODDELIVERYMETHOD as SMDM on SMDM.DELIVERYMETHODID = DM.ID
        inner join 
            dbo.SALESMETHOD on SALESMETHOD.ID = SMDM.SALESMETHODID
        left join 
            dbo.FEETAX as FT on FT.FEEID = FEE.ID
        left join 
            dbo.TAX on FT.TAXID = TAX.ID
        where
            SALESMETHOD.TYPECODE = @SALESMETHODTYPECODE and
            DM.ISACTIVE = 1 and
            FEE.ISACTIVE = 1
        group by
            DM.ID, FEE.NAME, FEE.APPLIESTO, FEE.TYPECODE, FEE.AMOUNT, FEE.[PERCENT]