UFN_MKTSOURCECODEPARTDEFINITIONVALUES_VALUEISVALID

Returns whether or not a value is valid for a given source code.

Return

Return Type
bit

Parameters

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

Definition

Copy



CREATE function dbo.[UFN_MKTSOURCECODEPARTDEFINITIONVALUES_VALUEISVALID]
(
  @SOURCECODEID uniqueidentifier = null,
  @CODEVALUEID uniqueidentifier,
  @ITEMTYPECODE tinyint = null
)
returns bit
as
begin
  return (
    select
      (case when exists(select 1
                        from dbo.[MKTSOURCECODEITEM]
                        inner join dbo.[MKTSOURCECODEVALIDPARTVALUES] on [MKTSOURCECODEVALIDPARTVALUES].[MKTSOURCECODEITEMID] = [MKTSOURCECODEITEM].[ID]
                        inner join dbo.[MKTSOURCECODEPARTDEFINITIONVALUES] on [MKTSOURCECODEPARTDEFINITIONVALUES].[ID] = [MKTSOURCECODEVALIDPARTVALUES].[MKTSOURCECODEPARTDEFINITIONVALUESID]
                        inner join dbo.[MKTSOURCECODEPARTDEFINITION] on [MKTSOURCECODEPARTDEFINITION].[ID] = [MKTSOURCECODEPARTDEFINITIONVALUES].[MKTSOURCECODEPARTDEFINITIONID]
                        where [MKTSOURCECODEVALIDPARTVALUES].[MKTSOURCECODEPARTDEFINITIONVALUESID] = @CODEVALUEID
                        and (@SOURCECODEID is null or [MKTSOURCECODEITEM].[SOURCECODEID] = @SOURCECODEID)
                        and (@ITEMTYPECODE is null or [MKTSOURCECODEPARTDEFINITION].[ITEMTYPECODE] = @ITEMTYPECODE))
       then 1
       else 0
       end)
  );
end