USP_SIMPLEDATALIST_MKTSOURCECODEPARTDEFINITIONVALUES_FORBATCH

List of source code part definition values for built-in part types, excluding user-defined, for use in batch.

Parameters

Parameter	Parameter Type	Mode	Description
@ITEMTYPECODE	tinyint	IN
@SOURCECODEID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.[USP_SIMPLEDATALIST_MKTSOURCECODEPARTDEFINITIONVALUES_FORBATCH]
(
  @ITEMTYPECODE tinyint,
  @SOURCECODEID uniqueidentifier = null
)
as
  set nocount on;

  select distinct
    [MKTSOURCECODEPARTDEFINITIONVALUES].[ID] as [VALUE],
    [MKTSOURCECODEPARTDEFINITIONVALUES].[DESCRIPTION] as [LABEL]
  from dbo.[MKTSOURCECODEPARTDEFINITION]
  inner join dbo.[MKTSOURCECODEPARTDEFINITIONVALUES] on [MKTSOURCECODEPARTDEFINITIONVALUES].[MKTSOURCECODEPARTDEFINITIONID] = [MKTSOURCECODEPARTDEFINITION].[ID]
  left join dbo.[MKTSOURCECODEVALIDPARTVALUES] on [MKTSOURCECODEVALIDPARTVALUES].[MKTSOURCECODEPARTDEFINITIONVALUESID] = [MKTSOURCECODEPARTDEFINITIONVALUES].[ID]
  left join dbo.[MKTSOURCECODEITEM] on [MKTSOURCECODEITEM].[ID] = [MKTSOURCECODEVALIDPARTVALUES].[MKTSOURCECODEITEMID]
  where [MKTSOURCECODEPARTDEFINITION].[ITEMTYPECODE] = @ITEMTYPECODE
  and (@SOURCECODEID is null or [MKTSOURCECODEITEM].[SOURCECODEID] = @SOURCECODEID or not exists(select 1 from dbo.[MKTSOURCECODEITEM] as [SCI] inner join dbo.[MKTSOURCECODEPARTDEFINITION] as [SCPD] on [SCPD].[ID] = [SCI].[MKTSOURCECODEPARTDEFINITIONID] where [SCI].[SOURCECODEID] = @SOURCECODEID and [SCPD].[ITEMTYPECODE] = @ITEMTYPECODE));

  return 0;