UFN_ALL_UNACKNOWLEDGED_REGISTRATIONS

CREATE function dbo.UFN_ALL_UNACKNOWLEDGED_REGISTRATIONS()
    returns table
    as return

    select 
        REVENUE.ID 
      from 
        dbo.REVENUE              
        inner join dbo.REVENUESPLIT on REVENUESPLIT.REVENUEID = REVENUE.ID
            where 
        REVENUE.ID not in (select REVENUELETTER.REVENUEID from dbo.REVENUELETTER) and 
        REVENUESPLIT.TYPECODE = 1