UFN_MKTPLANSOURCECODEPART_GETITEMLIST

CREATE function dbo.UFN_MKTPLANSOURCECODEPART_GETITEMLIST
(
  @MARKETINGPLANITEMID uniqueidentifier
)
/*
Returns a table of all of the source code items that have been assigned to the given segmentation
*/
returns table
as
return 
(
  select
      [PART].[ID],
      [PART].[CODE],
      [PART].[SOURCECODEITEMID],
      [PART].[PARTDEFINITIONVALUESID],
      [MKTSOURCECODEPARTDEFINITION].[ITEMTYPECODE] as [SOURCECODEPARTTYPE],
      [MKTSOURCECODEPARTDEFINITION].[ID] as [PARTDEFINITIONID],
      [MKTSOURCECODEPARTDEFINITION].[NAME] as [PARTDEFINITIONNAME],
      [MKTSOURCECODEPARTDEFINITIONVALUES].[REGEX] as [CODEREGEX],
      [MKTSOURCECODEITEM].[SEQUENCE]
    from dbo.[MKTSOURCECODEPART] [PART]
    inner join dbo.[MKTSOURCECODEITEM] on [MKTSOURCECODEITEM].[ID] = [PART].[SOURCECODEITEMID]
    inner join dbo.[MKTSOURCECODEPARTDEFINITION] on [MKTSOURCECODEPARTDEFINITION].[ID] = [MKTSOURCECODEITEM].[MKTSOURCECODEPARTDEFINITIONID]
    inner join dbo.[MKTSOURCECODEPARTDEFINITIONVALUES] on [MKTSOURCECODEPARTDEFINITIONVALUES].[ID] = [PART].[PARTDEFINITIONVALUESID]
  where [PART].[MARKETINGPLANITEMID] = @MARKETINGPLANITEMID
)