EXEMPLO_1212310 Database

Parameters

Name	Type	Mode
@CODCOLLAN	smallint	IN
@IDLAN	int	IN
@CODTIPOCOMPN	int	IN
@ACAOCOMPN	int	IN
@IDHISTORICO	int	IN

Definition

CREATE FUNCTION XVALORPARCELACOMPONENTEHST(
  @CODCOLLAN SMALLINT,
  @IDLAN INT,
  @CODTIPOCOMPN INT,
  @ACAOCOMPN INT,
  @IDHISTORICO INT
)
RETURNS NUMERIC(15,4)
AS
BEGIN
  DECLARE @RETORNO NUMERIC(15,4)
  SET @RETORNO = CONVERT(NUMERIC(15,4), (SELECT ISNULL(SUM(XLANINTEGRACAOHST.VALOR), 0)
                                         FROM FLANHST (NOLOCK)
                                                JOIN XLANINTEGRACAOHST (NOLOCK)
                                                     JOIN FLANINTEGRACAODEF (NOLOCK)
                                                          JOIN XCOMPONENTEVRINTEGRACAO (NOLOCK)
                                                               JOIN XCOMPONENTE (NOLOCK)
                                                               ON XCOMPONENTE.COD_COMPN = XCOMPONENTEVRINTEGRACAO.CODCOMPN AND
                                                                  XCOMPONENTE.COD_TIPO_COMPN = @CODTIPOCOMPN AND
                                                                  XCOMPONENTE.TIPOENTREGACORRECAO = @ACAOCOMPN
                                                          ON XCOMPONENTEVRINTEGRACAO.CODCOLIGADA = FLANINTEGRACAODEF.CODCOLIGADA AND
                                                             XCOMPONENTEVRINTEGRACAO.IDCAMPO = FLANINTEGRACAODEF.IDCAMPO
                                                     ON FLANINTEGRACAODEF.CODCOLIGADA = XLANINTEGRACAOHST.CODCOLIGADA AND
                                                        FLANINTEGRACAODEF.IDCAMPO = XLANINTEGRACAOHST.IDCAMPO
                                                ON XLANINTEGRACAOHST.CODCOLIGADA = FLANHST.CODCOLIGADA AND
                                                   XLANINTEGRACAOHST.IDLAN = FLANHST.IDLAN AND
                                                   XLANINTEGRACAOHST.IDHISTORICO = FLANHST.IDHISTORICO
                                           WHERE FLANHST.CODCOLIGADA = @CODCOLLAN AND
                                                 FLANHST.IDLAN = @IDLAN AND
                                                 FLANHST.IDHISTORICO = @IDHISTORICO AND
                                                 FLANHST.CODAPLICACAO = 'X'))
  RETURN @RETORNO
END