V_QUERY_BBDW_REVENUEAPPLICATIONOTHER

create view BBDW.[V_QUERY_BBDW_REVENUEAPPLICATIONOTHER] as 

        select
          li.FINANCIALTRANSACTIONLINEITEMFACTID [FINANCIALTRANSACTIONLINEITEMFACTID],
          rotc.OTHERREVENUETYPEDIMID [OTHERREVENUETYPEDIMID],
          rotc.OTHERREVENUETYPESYSTEMID [OTHERREVENUETYPESYSTEMID],
          rotc.OTHERREVENUETYPE [OTHERREVENUETYPE]
        from
          bbdw.FACT_FINANCIALTRANSACTIONLINEITEM li
          inner join bbdw.DIM_REVENUEOTHERTYPECODE rotc on li.OTHERREVENUETYPEDIMID = rotc.OTHERREVENUETYPEDIMID
        where
          li.OTHERREVENUETYPEDIMID <> 0