USP_DATALIST_NOTIFICATION

CREATE procedure dbo.USP_DATALIST_NOTIFICATION
(
    @INCLUDESYSTEMGENERATED bit = 0
) 
as
    set nocount on;

    select
        NOTIFICATION.ID,                            
        NOTIFICATION.NAME,    
        RECORDTYPE.NAME as RECORDTYPE,
        NOTIFICATION.VALIDUNTIL,
        NOTIFICATION.APPLYTO,                            
        NOTIFICATION.MESSAGE,
        NOTIFICATION.ISSYSTEMGENERATED
    from
        dbo.NOTIFICATION
        inner join dbo.RECORDTYPE on NOTIFICATION.RECORDTYPEID = RECORDTYPE.ID
        left join dbo.IDSETREGISTER on NOTIFICATION.RECORDIDSETREGISTERID = IDSETREGISTER.ID
    where
        (NOTIFICATION.ISSYSTEMGENERATED = 0 or @INCLUDESYSTEMGENERATED = 1)
        and (
            (select dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('6F77D512-D0D1-444F-9B46-B8603A6FE5F1')) = 1
            or coalesce(IDSETREGISTER.DBOBJECTNAME, '') not in (
                'UFN_WEALTHPOINT_PENDINGRESEARCHGROUPS',
                'UFN_PROSPECTRESEARCHREQUEST_OPENRESEARCHGROUPS',
                'UFN_PROSPECTRESEARCHREQUEST_OPENCONSTITUENTS',
                'UFN_PROSPECTRESEARCHREQUEST_OPENEVENTS',
                'UFN_WEALTHPOINT_PENDINGCONSTITUENTS'
            )
        )
    order by
        NOTIFICATION.NAME