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
)