USP_DATALIST_ACTION_ITEM_MEDIA_TARGET

Returns all Action Item Media Target records.

Parameters

Parameter	Parameter Type	Mode	Description
@ACTIONITEMID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_ACTION_ITEM_MEDIA_TARGET
(
        @ACTIONITEMID uniqueidentifier
)
as
    set nocount on;

    select 
        ACTIONITEMMEDIATARGET.[ID],
        ACTIONITEMMEDIATARGET.[ACTIONITEMID],
        ACTIONITEMMEDIATARGET.[CATEGORY],
        ACTIONITEMMEDIATARGET.[SENDTYPECODE]
    from 
        dbo.ACTIONITEMMEDIATARGET
    where
        ACTIONITEMID = @ACTIONITEMID