USP_DATALIST_LISTPROFILE

CREATE procedure dbo.[USP_DATALIST_LISTPROFILE]
(
  @ID uniqueidentifier,
  @CURRENCYCODE tinyint = null
)
as
  set nocount on;

    declare @SELECTEDCURRENCYID uniqueidentifier;
    if isnull(@CURRENCYCODE, 0) = 1
    begin
        set @SELECTEDCURRENCYID = dbo.[UFN_CURRENCY_GETORGANIZATIONCURRENCY]();
    end

  select
    [MKTLIST].[NAME],
    [MKTLIST].[DESCRIPTION],
    [MKTLIST].[CODE],
    [MKTLISTCATEGORYCODE].[DESCRIPTION] as [LISTCATEGORYCODE],
    [CONSTITUENT].[NAME] as [VENDOR],
        case @CURRENCYCODE
        when 1 then [MKTLIST].[ORGANIZATIONBASERENTALCOST]
        else [MKTLIST].[BASERENTALCOST] end [BASERENTALCOST],
    [MKTLIST].[BASERENTALCOSTBASISCODE],
        case @CURRENCYCODE
        when 1 then [MKTLIST].[ORGANIZATIONBASEEXCHANGECOST]
        else [MKTLIST].[BASEEXCHANGECOST] end [BASEEXCHANGECOST],
    [MKTLIST].[BASEEXCHANGECOSTBASISCODE],
    [MKTLIST].[ISINACTIVE],
    [QUERYVIEWCATALOG].[DISPLAYNAME] as [RECORDSOURCE],
    [CURRENCYPROPERTIES].[ISO4217] [ISOCURRENCYCODE],
    [CURRENCYPROPERTIES].[CURRENCYSYMBOL],
    [CURRENCYPROPERTIES].[SYMBOLDISPLAYSETTINGCODE] [CURRENCYSYMBOLDISPLAYSETTINGCODE],
    [CURRENCYPROPERTIES].[DECIMALDIGITS]
  from dbo.[MKTLIST]
  left outer join dbo.[CONSTITUENT] on [CONSTITUENT].[ID] = [MKTLIST].[VENDORID]
  left outer join dbo.[MKTLISTCATEGORYCODE] on [MKTLISTCATEGORYCODE].[ID] = [MKTLIST].[LISTCATEGORYCODEID]
  left outer join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTLIST].[RECORDSOURCEID]
    outer apply dbo.[UFN_CURRENCY_GETPROPERTIES](isnull(@SELECTEDCURRENCYID, [MKTLIST].[BASECURRENCYID])) [CURRENCYPROPERTIES]
  where [MKTLIST].[ID] = @ID;

  return 0;