USP_SIMPLEDATALIST_MKTSOURCECODE

Returns a list of all active source codes

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@INCLUDEALL	bit	IN
@INCLUDECODESWITHLISTPARTS	bit	IN
@INCLUDECODESWITHTESTSEGMENTPARTS	bit	IN
@SECURITYFEATUREID	uniqueidentifier	IN
@SECURITYFEATURETYPE	tinyint	IN

Definition

Copy



CREATE procedure dbo.[USP_SIMPLEDATALIST_MKTSOURCECODE]
(
  @CURRENTAPPUSERID uniqueidentifier,
  @INCLUDEALL bit = 0,
  @INCLUDECODESWITHLISTPARTS bit = 1,
  @INCLUDECODESWITHTESTSEGMENTPARTS bit = 1,
  @SECURITYFEATUREID uniqueidentifier = null,
  @SECURITYFEATURETYPE tinyint = null
)
as
begin
  set nocount on;

  select 
    [MKTSOURCECODE].[ID] as [VALUE], 
    [MKTSOURCECODE].[NAME] as [LABEL] 
  from dbo.[MKTSOURCECODE]
  where exists (select top 1 1 from dbo.[MKTSOURCECODEITEM] where [MKTSOURCECODEITEM].[SOURCECODEID] = [MKTSOURCECODE].[ID]) -- do not display empty source code layouts

  and (@INCLUDEALL = 1 or [MKTSOURCECODE].[ISACTIVE] <> 0)
  and (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[MKTSOURCECODE].[SITEID] or (SITEID is null and [MKTSOURCECODE].[SITEID] is null)))
  and (@INCLUDECODESWITHLISTPARTS = 1 or not exists(select top 1 1 from dbo.[MKTSOURCECODEITEM] as [I] inner join dbo.[MKTSOURCECODEPARTDEFINITION] as [PD] on [PD].[ID] = [I].[MKTSOURCECODEPARTDEFINITIONID] where [I].[SOURCECODEID] = [MKTSOURCECODE].[ID] and [PD].[ITEMTYPECODE] = 6))
  and (@INCLUDECODESWITHTESTSEGMENTPARTS = 1 or not exists(select top 1 1 from dbo.[MKTSOURCECODEITEM] as [I] inner join dbo.[MKTSOURCECODEPARTDEFINITION] as [PD] on [PD].[ID] = [I].[MKTSOURCECODEPARTDEFINITIONID] where [I].[SOURCECODEID] = [MKTSOURCECODE].[ID] and [PD].[ITEMTYPECODE] = 7))
  order by [MKTSOURCECODE].[NAME];

  return 0;
end