UFN_SALESORDER_GETPAYMENTMETHODLIST

CREATE function dbo.UFN_SALESORDER_GETPAYMENTMETHODLIST
(
    @SALESORDERID uniqueidentifier
)
returns nvarchar(max)
with execute as caller
as begin
    declare @LIST nvarchar(max) = null;

    select
        @LIST = dbo.UDA_BUILDLISTWITHDELIMITER(
            distinct case REVENUEPAYMENTMETHOD.PAYMENTMETHODCODE
                when 10 then dbo.UFN_OTHERPAYMENTMETHODCODE_GETDESCRIPTION(OTHERPAYMENTMETHODDETAIL.OTHERPAYMENTMETHODCODEID)
                else REVENUEPAYMENTMETHOD.PAYMENTMETHOD
            end
        , ', ')
    from
        dbo.SALESORDERPAYMENT
    inner join
        dbo.REVENUEPAYMENTMETHOD on SALESORDERPAYMENT.PAYMENTID = REVENUEPAYMENTMETHOD.REVENUEID
    left outer join
        dbo.OTHERPAYMENTMETHODDETAIL on REVENUEPAYMENTMETHOD.ID = OTHERPAYMENTMETHODDETAIL.ID
    where
        SALESORDERPAYMENT.SALESORDERID = @SALESORDERID;

    return @LIST;
end