USP_DATALIST_SALESDEPOSITPROCESS_SALESDEPOSITTEMPLATE_2

CREATE procedure dbo.USP_DATALIST_SALESDEPOSITPROCESS_SALESDEPOSITTEMPLATE_2
(
  @SALESDEPOSITPROCESSID uniqueidentifier = null
)
as
    set nocount on;

    select 
        [SALESDEPOSITTEMPLATE].[ID],
        [SALESDEPOSITTEMPLATE].[NAME],
        dbo.UFN_BANKACCOUNT_GETACCOUNTNAME([SALESDEPOSITTEMPLATE].[BANKACCOUNTID]) as [ACCOUNTNAME],
        (case when [SALESDEPOSITTEMPLATE].SALESCHANNELOPTIONCODE = 0 then [SALESDEPOSITTEMPLATE].SALESCHANNELOPTION
            else (select dbo.UDA_BUILDLIST([SDTSC].[SALESMETHODTYPE]) 
                from (select distinct [SALESMETHODTYPE], [SALESDEPOSITTEMPLATEID] from dbo.[SALESDEPOSITTEMPLATESALESCHANNEL]) as [SDTSC]
                where [SDTSC].[SALESDEPOSITTEMPLATEID] = [SALESDEPOSITTEMPLATE].[ID]) end) as [SALESCHANNELS],
        (case when [SALESDEPOSITTEMPLATE].PAYMENTMETHODOPTIONCODE = 0 then [SALESDEPOSITTEMPLATE].PAYMENTMETHODOPTION
            else (select dbo.UDA_BUILDLIST([SDTPM].[PAYMENTMETHOD])
                from (select distinct [PAYMENTMETHOD], [SALESDEPOSITTEMPLATEID] from dbo.[SALESDEPOSITTEMPLATEPAYMENTMETHOD]) as [SDTPM]
                where [SDTPM].[SALESDEPOSITTEMPLATEID] = [SALESDEPOSITTEMPLATE].[ID]) end) as [PAYMENTMETHODS],
        [SALESDEPOSITTEMPLATE].[REFERENCE],
    (case when [SALESDEPOSITTEMPLATE].CURRENCYOPTIONCODE = 0 then [SALESDEPOSITTEMPLATE].CURRENCYOPTION
      else (select dbo.UDA_BUILDLIST(dbo.UFN_CURRENCY_GETDESCRIPTION(SDTC.ID))
        from (select distinct [CURRENCY].[ID], [SALESDEPOSITTEMPLATEID] from dbo.[SALESDEPOSITTEMPLATECURRENCY]
          inner join dbo.[CURRENCY] on [CURRENCY].ID = [SALESDEPOSITTEMPLATECURRENCY].CURRENCYID) as [SDTC]
          where [SDTC].[SALESDEPOSITTEMPLATEID] = [SALESDEPOSITTEMPLATE].ID) end) as [CURRENCIES]
    from dbo.[SALESDEPOSITTEMPLATE]
  where 
    [SALESDEPOSITTEMPLATE].[SALESDEPOSITPROCESSID] = @SALESDEPOSITPROCESSID or @SALESDEPOSITPROCESSID is null