USP_MKTFINDERFILEIMPORTPROCESS_GETOPTIONS

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

  select
    [MKTFINDERFILEIMPORTPROCESS].[ID],
    [MKTFINDERFILEIMPORTPROCESS].[SEGMENTATIONID],
    [MKTFINDERFILEIMPORTPROCESS].[LISTLAYOUTID],
    [MKTFINDERFILEIMPORTPROCESS].[QUANTITY],
    [MKTFINDERFILEIMPORTPROCESS].[VENDORID],
    [QUERYVIEWCATALOG].[OBJECTNAME] as [BASETABLENAME],
    [QUERYVIEWCATALOG].[PRIMARYKEYFIELD] as [BASETABLEIDFIELDNAME],
    [QUERYVIEWCATALOG].[PRIMARYKEYTYPENAME] as [BASETABLEIDTYPENAME],
    [MKTLISTLAYOUT].[RECORDSOURCEID],
    [MKTLISTLAYOUT].[ADDNEWCODETABLEENTRIES]
  from dbo.[MKTFINDERFILEIMPORTPROCESS]
  inner join dbo.[MKTLISTLAYOUT] on [MKTLISTLAYOUT].[ID] = [MKTFINDERFILEIMPORTPROCESS].[LISTLAYOUTID]
  inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTLISTLAYOUT].[RECORDSOURCEID]
  where [MKTFINDERFILEIMPORTPROCESS].[ID] = @ID;

  return 0;