USP_MKTACKNOWLEDGEMENTMAILINGPROCESS_GETOPTIONS

CREATE procedure dbo.[USP_MKTACKNOWLEDGEMENTMAILINGPROCESS_GETOPTIONS]
(
  @ID uniqueidentifier
)
as
  set nocount on;

  declare @TEMPLATEID uniqueidentifier;

  select
    @TEMPLATEID = [ACKNOWLEDGEMENTMAILINGTEMPLATEID]
  from dbo.[MKTACKNOWLEDGEMENTMAILINGPROCESS]
  where [ID] = @ID;

  select
    @TEMPLATEID as [ACKNOWLEDGEMENTMAILINGTEMPLATEID],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[SITEID],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[MARKLETTERSACKNOWLEDGED],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ACKNOWLEDGEDATETYPECODE],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ACKNOWLEDGEDATE],
    isnull([BUSINESSPROCESSCOMMPREF].[DATETYPECODE], 0) as [EXCLUSIONDATETYPECODE],
    [BUSINESSPROCESSCOMMPREF].[ASOFDATE] as [EXCLUSIONASOFDATE],
    isnull([BUSINESSPROCESSCOMMPREF].[EXCLUDEDECEASED], 0) as [EXCLUDEDECEASED],
    isnull([BUSINESSPROCESSCOMMPREF].[EXCLUDEINACTIVE], 0) as [EXCLUDEINACTIVE],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[USEADDRESSPROCESSING],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ADDRESSPROCESSINGOPTIONID],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ADDRESSPROCESSINGOPTIONSEASONALASOFDATE],
    [ADDRESSPROCESSINGOPTION].[INDUSESEASONALADDRESS],
    [ADDRESSPROCESSINGOPTION].[ORGMAILINGPREFERENCE],
    [ADDRESSPROCESSINGOPTION].[INDALTADDRESS1TYPECODEID],
    [ADDRESSPROCESSINGOPTION].[INDALTADDRESS1ISPRIMARY],
    [ADDRESSPROCESSINGOPTION].[INDALTADDRESS2TYPECODEID],
    [ADDRESSPROCESSINGOPTION].[INDALTADDRESS2ISPRIMARY],
    [ADDRESSPROCESSINGOPTION].[ORGALTADDRESS1TYPECODEID],
    [ADDRESSPROCESSINGOPTION].[ORGALTADDRESS1ISPRIMARY],
    [ADDRESSPROCESSINGOPTION].[ORGALTADDRESS2TYPECODEID],
    [ADDRESSPROCESSINGOPTION].[ORGALTADDRESS2ISPRIMARY],
    [ADDRESSPROCESSINGOPTION].[INDINCLUDEWITHNOADDRESS],
    [ADDRESSPROCESSINGOPTION].[ORGINCLUDEWITHNOADDRESS],
    [ADDRESSPROCESSINGOPTION].[ORGINCLUDEWITHNOCONTACT],
    [ADDRESSPROCESSINGOPTION].[ORGSENDTOALLCONTACTS],
    [ADDRESSPROCESSINGOPTION].[INDUSECONSTITUENTPREFS],
    [ADDRESSPROCESSINGOPTION].[ORGUSECONSTITUENTPREFS],
    [ADDRESSPROCESSINGOPTION].[GROUPALTADDRESS1TYPECODEID],
    [ADDRESSPROCESSINGOPTION].[GROUPALTADDRESS1ISPRIMARY],
    [ADDRESSPROCESSINGOPTION].[GROUPALTADDRESS2TYPECODEID],
    [ADDRESSPROCESSINGOPTION].[GROUPALTADDRESS2ISPRIMARY],
    [ADDRESSPROCESSINGOPTION].[GROUPINCLUDEWITHNOADDRESS],
    [ADDRESSPROCESSINGOPTION].[GROUPUSECONSTITUENTPREFS],
    [ADDRESSPROCESSINGOPTION].[ORGCONTACTALSOINDACTION],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[MULTIPLELETTERSPERREVENUE],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[RUNACTIVATEANDEXPORT]
  from dbo.[MKTACKNOWLEDGEMENTMAILINGPROCESS]
  inner join dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATE] on [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ID] = [MKTACKNOWLEDGEMENTMAILINGPROCESS].[ACKNOWLEDGEMENTMAILINGTEMPLATEID]
  left outer join dbo.[BUSINESSPROCESSCOMMPREF] on [BUSINESSPROCESSCOMMPREF].[BUSINESSPROCESSPARAMETERSETID] = [MKTACKNOWLEDGEMENTMAILINGPROCESS].[ID]
  left outer join dbo.[ADDRESSPROCESSINGOPTION] on [ADDRESSPROCESSINGOPTION].[ID] = [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ADDRESSPROCESSINGOPTIONID]
  where [MKTACKNOWLEDGEMENTMAILINGPROCESS].[ID] = @ID;

  return 0;