USP_DATALIST_ALTRUNOTIFICATIONS

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

    select
        NOTIFICATION.ID,
        NOTIFICATION.NAME,
        RECORDTYPE.NAME as RECORDTYPE,
        NOTIFICATION.VALIDUNTIL,
        NOTIFICATION.APPLYTO,
        NOTIFICATION.MESSAGE,
        ALTRUNOTIFICATION.DISPLAYINDAILYSALES,
        NOTIFICATION.ISSYSTEMGENERATED
    from
        dbo.NOTIFICATION
        inner join dbo.RECORDTYPE on NOTIFICATION.RECORDTYPEID = RECORDTYPE.ID
        inner join dbo.ALTRUNOTIFICATION on NOTIFICATION.ID = ALTRUNOTIFICATION.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