UFN_MKTACKNOWLEDGEMENTMAILINGTEMPLATESOURCECODEPART_GETITEMLIST
Returns a table of all of the source code items that have been assigned to the given marketing acknowledgement template template.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ACKNOWLEDGEMENTMAILINGTEMPLATEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_MKTACKNOWLEDGEMENTMAILINGTEMPLATESOURCECODEPART_GETITEMLIST
(
@ACKNOWLEDGEMENTMAILINGTEMPLATEID uniqueidentifier
)
returns table
as
return
(
select
[PART].[ID],
[PART].[CODE],
[PART].[SOURCECODEITEMID],
[PART].[CHANNELCODE],
[PART].[PARTDEFINITIONVALUESID]
from dbo.[MKTSOURCECODEPART] as [PART]
where [ACKNOWLEDGEMENTMAILINGTEMPLATEID] = @ACKNOWLEDGEMENTMAILINGTEMPLATEID
);