UFN_MKTSOURCECODEPART_WHITEMAILSEGMENT_GETITEMLIST
Returns a table of all of the source code items that have been assigned to the given white mail segment.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @WHITEMAILSEGMENTID | uniqueidentifier | IN |
Definition
Copy
create function dbo.[UFN_MKTSOURCECODEPART_WHITEMAILSEGMENT_GETITEMLIST]
(
@WHITEMAILSEGMENTID uniqueidentifier
)
returns table
as
return
(
select
[PART].[ID],
[PART].[CODE],
[PART].[SOURCECODEITEMID],
[PART].[PARTDEFINITIONVALUESID]
from dbo.[MKTSOURCECODEPART] as [PART]
where [PART].[WHITEMAILSEGMENTID] = @WHITEMAILSEGMENTID
)