UFN_MKTSOURCECODEVALIDPARTVALUES_GETITEMLIST

Returns a table of all of the valid source code part definition value IDs that have been assigned to the source code.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@MKTSOURCECODEITEMID uniqueidentifier IN

Definition

Copy


create function dbo.[UFN_MKTSOURCECODEVALIDPARTVALUES_GETITEMLIST]
(
  @MKTSOURCECODEITEMID uniqueidentifier
)
/*
Returns a table of all of the valid source code part definition value IDs that have been assigned to the source code.
*/
returns table
as
  return 
  (
    select 
      M.[ID],
      M.[MKTSOURCECODEPARTDEFINITIONVALUESID]
    from dbo.[MKTSOURCECODEVALIDPARTVALUES] M
    where M.[MKTSOURCECODEITEMID] = @MKTSOURCECODEITEMID
  )