UFN_MEMBERSHIPDUESBATCH_GETDISCOUNTSFORCONTEXTVIEW

create function dbo.UFN_MEMBERSHIPDUESBATCH_GETDISCOUNTSFORCONTEXTVIEW
(
    @BATCHMEMBERSHIPDUESID uniqueidentifier
)
returns table
as return
    select
        case
            when BMD.MEMBERSHIPPROMOID is not null
                then 'Promo code'
            else MP.[NAME]
            end as [NAME]
        , MP.PROMOTIONTYPECODE
        , MP.DISCOUNTCALCULATIONTYPECODE
        , MP.[AMOUNT]
        , MP.[PERCENT]
        , MP.EXTENSIONCALCULATIONTYPECODE
        , MP.EXTENSIONVALUE
        , BMD.TRANSACTIONCURRENCYID
    from dbo.BATCHMEMBERSHIPDUES BMD
        inner join dbo.MEMBERSHIPPROMO MP
            on coalesce (BMD.MEMBERSHIPPROMOID, BMD.APPLIEDDISCOUNTID) = MP.ID 
    where
        BMD.USEDISCOUNT = 1