UFN_MEMBERSHIPDUESBATCH_GETADDONSFORCONTEXTVIEW

CREATE function dbo.UFN_MEMBERSHIPDUESBATCH_GETADDONSFORCONTEXTVIEW
(
    @BATCHMEMBERSHIPDUESID uniqueidentifier
)
returns table
as
return (
    select 
        ADDON.NAME,
        BATCHMEMBERSHIPDUESMEMBERSHIPROGRAMADDON.NUMBEROFADDONS as [QUANTITY],
        MEMBERSHIPPROGRAMADDON.PRICE * BATCHMEMBERSHIPDUESMEMBERSHIPROGRAMADDON.NUMBEROFADDONS as [TOTALVALUE],
        BATCHMEMBERSHIPDUES.TRANSACTIONCURRENCYID
    from dbo.BATCHMEMBERSHIPDUES
    inner join dbo.BATCHMEMBERSHIPDUESMEMBERSHIPROGRAMADDON
        on BATCHMEMBERSHIPDUESMEMBERSHIPROGRAMADDON.BATCHMEMBERSHIPDUESID = @BATCHMEMBERSHIPDUESID
    inner join dbo.ADDON 
        on dbo.BATCHMEMBERSHIPDUESMEMBERSHIPROGRAMADDON.ADDONID = ADDON.ID
    inner join dbo.MEMBERSHIPPROGRAMADDON
        on MEMBERSHIPPROGRAMADDON.MEMBERSHIPPROGRAMID = BATCHMEMBERSHIPDUES.MEMBERSHIPPROGRAMID
    where BATCHMEMBERSHIPDUES.ID = @BATCHMEMBERSHIPDUESID
)