USP_MKTACKNOWLEDGEMENTMAILINGPROCESS_GETTEMPLATERULES

CREATE procedure dbo.[USP_MKTACKNOWLEDGEMENTMAILINGPROCESS_GETTEMPLATERULES]
(
  @TEMPLATEID uniqueidentifier
)
as
  set nocount on;

  select
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[ID] as [TEMPLATERULEID],
    [MKTSEGMENT].[ID] as [SEGMENTID],
    [MKTSEGMENT].[NAME] as [SEGMENTNAME],
    dbo.[UFN_MKTREVENUELETTER_MAKETABLENAME]([MKTGIFTRECORDSOURCE].[ID]) as [REVENUELETTERTABLENAME],
    dbo.[UFN_MKTREVENUERECEIPT_MAKETABLENAME]([MKTGIFTRECORDSOURCE].[ID]) as [REVENUERECEIPTTABLENAME],
    dbo.[UFN_MKTSELECTION_GETFUNCTIONNAME]([MKTSEGMENT].[IDSETREGISTERID]) as [IDSETTABLENAME],
    [MKTPACKAGE].[CHANNELCODE],
    [MKTPACKAGE].[LETTERCODEID],
    cast(isnull([LETTERCODE].[INCLUDESRECEIPT], 0) as bit) as [INCLUDESRECEIPT],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[MAXDAYSCHECKED],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[MAXDAYS],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[MINQUANTITYCHECKED],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[MINQUANTITY],
    [MKTGIFTRECORDSOURCE].[ID] as [RECORDSOURCEID],
    [QUERYVIEWCATALOG].[OBJECTNAME] as [GIFTRECORDSOURCEVIEWNAME],
    [QUERYVIEWCATALOG].[PRIMARYKEYFIELD],
    [MKTGIFTRECORDSOURCE].[DONORIDFIELD],
    [MKTGIFTRECORDSOURCE].[DONOTACKNOWLEDGEFIELD],
    [MKTGIFTRECORDSOURCE].[DONOTRECEIPTFIELD],
    [MKTGIFTRECORDSOURCE].[DATEADDEDFIELD],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[EXCLUDE],
    [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[PACKAGEID]
  from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE]
  inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[SEGMENTID]
  inner join dbo.[MKTGIFTRECORDSOURCE] on [MKTGIFTRECORDSOURCE].[ID] = [MKTSEGMENT].[QUERYVIEWCATALOGID]
  inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTGIFTRECORDSOURCE].[QUERYVIEWCATALOGID]
  left outer join dbo.[MKTPACKAGE] on [MKTPACKAGE].[ID] = [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[PACKAGEID]
  left join dbo.[LETTERCODE] on [LETTERCODE].[ID] = [MKTPACKAGE].[LETTERCODEID]
  where [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[ACKNOWLEDGEMENTMAILINGTEMPLATEID] = @TEMPLATEID
  order by [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[SEQUENCE];

  return 0;