V_REVENUE_WITHNULLSITESECURITY

create view BBDW.[V_REVENUE_WITHNULLSITESECURITY]
as

    select distinct
        [FACT_FINANCIALTRANSACTION].[FINANCIALTRANSACTIONSYSTEMID] as [ID]
    from BBDW.[FACT_FINANCIALTRANSACTION]    
  left join BBDW.[FACT_FINANCIALTRANSACTIONLINEITEM] on [FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONFACTID] = [FACT_FINANCIALTRANSACTION].[FINANCIALTRANSACTIONFACTID]
    cross apply BBDW.[UFN_SITEID_MAPFROM_REVENUESPLITID]([FACT_FINANCIALTRANSACTIONLINEITEM].[FINANCIALTRANSACTIONLINEITEMSYSTEMID]) [SITES]
     where [SITES].[SITEID] = '00000000-0000-0000-0000-000000000000';