UFN_REVENUEBATCH_GETBENEFITS

CREATE function dbo.UFN_REVENUEBATCH_GETBENEFITS
(
  @BATCHREVENUEID uniqueidentifier
)
returns table
as
return
(
  select
    TOTALVALUEBENEFIT.ID,
    TOTALVALUEBENEFIT.BENEFITID,
    TOTALVALUEBENEFIT.QUANTITY,
    TOTALVALUEBENEFIT.UNITVALUE,
    TOTALVALUEBENEFIT.TOTALVALUE,
    TOTALVALUEBENEFIT.DETAILS,
    TOTALVALUEBENEFIT.SEQUENCE,
    TOTALVALUEBENEFIT.REVENUEBENEFITID,
    TOTALVALUEBENEFIT.BENEFITCURRENCYID,
    case
      when BATCHREVENUE.TRANSACTIONCURRENCYID <> BATCHREVENUE.BASECURRENCYID then
        dbo.UFN_CURRENCY_CONVERTINVERSE(TOTALVALUEBENEFIT.TOTALVALUE, BATCHREVENUE.BASEEXCHANGERATEID)
      else
        TOTALVALUEBENEFIT.TOTALVALUE
    end as TRANSACTIONTOTALVALUE
  from
    dbo.BATCHREVENUE
  inner join
    (
      select
        ID,
        BENEFITID,
        QUANTITY,
        UNITVALUE,
        QUANTITY * UNITVALUE as TOTALVALUE,
        DETAILS,
        SEQUENCE,
        REVENUEBENEFITID,
        BENEFITCURRENCYID,
        BATCHREVENUEID
      from
        dbo.BATCHREVENUEBENEFIT
    ) as TOTALVALUEBENEFIT on TOTALVALUEBENEFIT.BATCHREVENUEID = BATCHREVENUE.ID
  where
    BATCHREVENUE.ID = @BATCHREVENUEID
)