V_REVENUE_WITHNULLSITESECURITY

create view V_REVENUE_WITHNULLSITESECURITY
as
    select distinct
        REVENUE.ID
    from
        dbo.REVENUE
        left join dbo.FINANCIALTRANSACTIONLINEITEM
            on FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID = REVENUE.ID
        cross apply dbo.UFN_SITEID_MAPFROM_REVENUESPLITID(FINANCIALTRANSACTIONLINEITEM.ID) SITES
    where
        SITES.SITEID is null