USP_DATALIST_MKTRECORDSOURCEINCLUDINGMEMBERSHIP

CREATE procedure dbo.[USP_DATALIST_MKTRECORDSOURCEINCLUDINGMEMBERSHIP]
as
  set nocount on;

  select
    [MKTRECORDSOURCE].[ID] as [QUERYVIEWCATALOGID],
    'RES:Query_large' as [IMAGEKEY],
    [QUERYVIEWCATALOG].[DISPLAYNAME] as [NAME],
    [MKTRECORDSOURCE].[CODE],
    [RECORDTYPE].[NAME] as [RECORDTYPE],
    [QUERYVIEWCATALOG].[DESCRIPTION],
    (case when dbo.UFN_MKTRECORDSOURCE_GETREQUIREDFIELDSSET([MKTRECORDSOURCE].[ID], 1) = 1 then 'true' else 'false' end) as [RECORDSOURCEFIELDMAPPINGSDEFINED],
    (case when dbo.UFN_MKTRECORDSOURCE_GETREQUIREDFIELDSSET([MKTRECORDSOURCE].[ID], 2) = 1 then 'true' else 'false' end) as [GIFTSOURCEDEFINED],
    (case when dbo.UFN_MKTRECORDSOURCE_GETREQUIREDFIELDSSET([MKTRECORDSOURCE].[ID], 3) = 1 then 'true' else 'false' end) as [APPEALSOURCEDEFINED],
    (case when dbo.UFN_MKTRECORDSOURCE_GETREQUIREDFIELDSSET([MKTRECORDSOURCE].[ID], 4) = 1 then 'true' else 'false' end) as [MEMBERSHIPSOURCEDEFINED],
    (select case when exists(select [MKTDUPLICATE].[ID] from dbo.[MKTDUPLICATE] inner join dbo.[MKTDUPLICATEFIELD] on [MKTDUPLICATEFIELD].[DUPLICATEID] = [MKTDUPLICATE].[ID] where [MKTDUPLICATE].[QUERYVIEWCATALOGID] = [MKTRECORDSOURCE].[ID]) then 'true' else 'false' end) as [DUPLICATECRITERIADEFINED],
    (select [ID] from dbo.[MKTDUPLICATE] where [QUERYVIEWCATALOGID] = [MKTRECORDSOURCE].[ID]) as [DUPLICATEID],
    (case when dbo.[UFN_MKTSELECTION_SMARTQUERIESEXIST](1) = 1 then 'true' else 'false' end) as [SMARTQUERIESEXIST],
    dbo.[UFN_MKTRECORDSOURCE_GETCONSOLIDATEDQUERYVIEWID]([MKTRECORDSOURCE].[ID]) as [CONSOLIDATEDQUERYVIEWID],
    [MKTSOURCEANALYSISRULES].[ID] as [SOURCEANALYSISRULEID]
  from dbo.[MKTRECORDSOURCE]
  inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTRECORDSOURCE].[ID]
  inner join dbo.[RECORDTYPE] on [RECORDTYPE].[ID] = [QUERYVIEWCATALOG].[RECORDTYPEID]
  left outer join dbo.[MKTDUPLICATE] on [MKTDUPLICATE].[QUERYVIEWCATALOGID] = [MKTRECORDSOURCE].[ID]
  left outer join dbo.[MKTSOURCEANALYSISRULES] on [MKTSOURCEANALYSISRULES].[RECORDSOURCEID] = [MKTRECORDSOURCE].[ID]
  where dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([MKTRECORDSOURCE].[ID]) = 1
  order by [QUERYVIEWCATALOG].[DISPLAYNAME];

  return 0;