USP_MKTSEGMENTWHITEMAILREFRESHPROCESS_GETOPTIONS

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

  select 
    [MKTSEGMENTWHITEMAILREFRESHPROCESS].[SEGMENTID],
    [MKTSEGMENT].[NAME] as [SEGMENTNAME],
    dbo.[UFN_MKTSOURCECODE_BUILDCODE]([MKTSEGMENTWHITEMAIL].[ID], null, null) as [SOURCECODE],
    [MKTSEGMENT].[QUERYVIEWCATALOGID] as [RECORDSOURCEID],
    [MKTSEGMENTWHITEMAIL].[SEGMENTATIONID],
    [MKTSEGMENTWHITEMAILREFRESHPROCESS].[GIFTIDSETREGISTERID],
    (select [DBOBJECTNAME] from dbo.[IDSETREGISTER] where [ID] = [MKTSEGMENTWHITEMAILREFRESHPROCESS].[GIFTIDSETREGISTERID]) as [GIFTIDSETREGISTEROBJECTNAME],
    [QUERYVIEWCATALOG].[PRIMARYKEYTYPENAME] as [DONORIDDATATYPE],
    [MKTSEGMENT].[BASECURRENCYID]
  from dbo.[MKTSEGMENTWHITEMAILREFRESHPROCESS]
  inner join dbo.[MKTSEGMENTWHITEMAIL] on [MKTSEGMENTWHITEMAIL].[ID] = [MKTSEGMENTWHITEMAILREFRESHPROCESS].[SEGMENTID]
  inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTSEGMENTWHITEMAIL].[ID]
  inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTSEGMENT].[QUERYVIEWCATALOGID]
  where [MKTSEGMENTWHITEMAILREFRESHPROCESS].[ID] = @ID;

  return 0;