USP_DATALIST_MKTFINDERFILE_SEGMENTATION

Display information about finder files for a marketing effort.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTFINDERFILE_SEGMENTATION]
(
  @SEGMENTATIONID uniqueidentifier = null,
  @CURRENTAPPUSERID uniqueidentifier = null
)
as
  set nocount on;

  select 
    [MKTFINDERFILEIMPORTPROCESS].[ID],
    [CONSTITUENT].[ID] as [VENDORID],
    [CONSTITUENT].[KEYNAME] as [VENDORNAME],
    [MKTFINDERFILECATEGORYCODE].[DESCRIPTION] as [CATEGORY],
    [MKTFINDERFILEIMPORTPROCESS].[ORDERDATE],
    [MKTFINDERFILEIMPORTPROCESS].[EXPIRATIONDATE],
    [MKTFINDERFILEIMPORTPROCESS].[DATEADDED] as [IMPORTDATE],
    [MKTFINDERFILEIMPORTPROCESS].[QUANTITY],
    [MKTFINDERFILEIMPORTPROCESS].[STATUSCODE],
    [MKTFINDERFILEIMPORTPROCESS].[STATUS]
  from dbo.[MKTFINDERFILEIMPORTPROCESS]
  inner join dbo.[CONSTITUENT] on [CONSTITUENT].[ID] = [MKTFINDERFILEIMPORTPROCESS].[VENDORID]  
  left join dbo.[MKTFINDERFILECATEGORYCODE] on [MKTFINDERFILECATEGORYCODE].[ID] = [MKTFINDERFILEIMPORTPROCESS].[CATEGORYCODEID]
  where [MKTFINDERFILEIMPORTPROCESS].[SEGMENTATIONID] = @SEGMENTATIONID
  order by [MKTFINDERFILEIMPORTPROCESS].[DATEADDED] asc;

  return 0;