UFN_REVENUELIFECYCLE_GETVALIDREVENUE

CREATE function dbo.UFN_REVENUELIFECYCLE_GETVALIDREVENUE()  
returns table as   return (    
select     
    REVENUE.ID as REVENUEID,     
    REVENUE.CONSTITUENTID,     
    REVENUESPLIT.ID as REVENUESPLITID,     
    REVENUE.[DATE],     
    REVENUE.TYPECODE as TRANSACTIONTYPECODE,     
    RSE.APPLICATIONCODE,     
    REVENUESPLIT.ORGAMOUNT - 
      case when REVENUE.TYPECODE in (1,6) 
      then (coalesce((select sum(INSTALLMENTSPLITWRITEOFF.ORGANIZATIONAMOUNT) 
                      from dbo.INSTALLMENTSPLITWRITEOFF 
                      inner join dbo.INSTALLMENTSPLIT on INSTALLMENTSPLITWRITEOFF.INSTALLMENTSPLITID = INSTALLMENTSPLIT.ID 
                      where INSTALLMENTSPLIT.PLEDGEID = REVENUE.ID), 0)) else 0 end as AMOUNT    
from        
    dbo.FINANCIALTRANSACTION as REVENUE with (nolock)        
    inner join dbo.FINANCIALTRANSACTIONLINEITEM as REVENUESPLIT with (nolock) on REVENUE.ID = REVENUESPLIT.FINANCIALTRANSACTIONID
    inner join dbo.REVENUESPLIT_EXT as RSE on RSE.ID = REVENUESPLIT.ID
    inner join dbo.UFN_REVENUEFILTER_DEFAULT() as REVENUEFILTER on REVENUEFILTER.ID = REVENUESPLIT.ID    
)