USP_CURRENCYEXCHANGERATEDOWNLOADPROCESS_DATALIST

Lists all currency exchange rate download processes in the system.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.[USP_CURRENCYEXCHANGERATEDOWNLOADPROCESS_DATALIST]
(
  @CURRENTAPPUSERID uniqueidentifier = null
)
as
  begin
    set nocount on;

    select
      [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[ID],
      [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[NAME],
      [CURRENCYEXCHANGERATEPROVIDER].[NAME] as [PROVIDER],
      [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[TYPE],
      (select count([ID]) from dbo.[CURRENCYEXCHANGERATEDOWNLOADPROCESSRATE] where [CURRENCYEXCHANGERATEDOWNLOADPROCESSID] = [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[ID]) as [RATES],
      (select max([STARTEDON]) 
       from dbo.[BUSINESSPROCESSSTATUS]
       inner join dbo.[CURRENCYEXCHANGERATEDOWNLOADPROCESSSTATUS] on [CURRENCYEXCHANGERATEDOWNLOADPROCESSSTATUS].[ID] = [BUSINESSPROCESSSTATUS].[ID]
       where [BUSINESSPROCESSSTATUS].[STATUSCODE] = 0
       and [CURRENCYEXCHANGERATEDOWNLOADPROCESSSTATUS].[PARAMETERSETID] = [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[ID]) as [LASTRUN],
      [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[DESCRIPTION],
      [CURRENCYEXCHANGERATEPROVIDER].[ID] as [PROVIDERID]
    from dbo.[CURRENCYEXCHANGERATEDOWNLOADPROCESS]
      inner join dbo.[CURRENCYEXCHANGERATEPROVIDER] on [CURRENCYEXCHANGERATEPROVIDER].[ID] = [CURRENCYEXCHANGERATEDOWNLOADPROCESS].[CURRENCYEXCHANGERATEPROVIDERID]
    where
      dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, CURRENCYEXCHANGERATEDOWNLOADPROCESS.ID) = 1

    return 0;
  end