USP_DATALIST_GENERATETRANSACTIONSPROCESS

                CREATE procedure dbo.USP_DATALIST_GENERATETRANSACTIONSPROCESS
                (
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @SITEFILTERMODE tinyint = 0,
                    @SITESSELECTED xml = null,
                    @SECURITYFEATUREID uniqueidentifier = null,
                    @SECURITYFEATURETYPE tinyint = null
                )
                as
                begin
                set nocount on;

                declare @BASICGL bit
                set @BASICGL = dbo.UFN_VALID_BASICGL_INSTALLED()

                select
                    [PROCESS].ID,
                    [PROCESS].TRANSACTIONTYPE,
                    [PROCESS].NAME,
                    [PROCESS].DESCRIPTION,
                    coalesce(IDSETREGISTER.NAME, ''),
                    [PROCESS].CUTOFFDATE,
                    [BATCH].NAME,
                    [PROCESS].BATCHNUMBER,
                    BPI.OWNERID as OWNERID,
                    PAS.NAME as ACCOUNTSYSTEM,
                    coalesce(SITE.NAME,'All Sites') SITES
                from dbo.GENERATETRANSACTIONSPROCESS as [PROCESS]
                inner join dbo.BATCHTEMPLATE as [BATCH] on [BATCH].ID = [PROCESS].BATCHTEMPLATEID
                left join dbo.IDSETREGISTER on IDSETREGISTER.ID = [PROCESS].IDSETREGISTERID
                left join dbo.BUSINESSPROCESSINSTANCE BPI on [PROCESS].ID = BPI.BUSINESSPROCESSPARAMETERSETID
                left join dbo.PDACCOUNTSYSTEM as PAS on PAS.ID = [PROCESS].PDACCOUNTSYSTEMID 
                left join dbo.SITE on SITE.ID = BPI.SITEID
                where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, [PROCESS].ID) = 1)
                    and (@BASICGL=0 or [PROCESS].PDACCOUNTSYSTEMID in (select ID from dbo.UFN_PDACCOUNTSYSTEM_GETSYSTEMIDSFORUSER(@CurrentAppUserID)))
                    and (
                                        (
                                             (--Check site security

                                                         select count(1) 
                                                         from dbo.UFN_BUSINESSPROCESSPARAMETERSET_GETSITES([PROCESS].ID) as GENERATETRANSACTIONPROCESSSITE 
                                                         where (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 or exists (select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@SECURITYFEATUREID,@SECURITYFEATURETYPE) where SITEID=[GENERATETRANSACTIONPROCESSSITE].[SITEID] or (SITEID is null and [GENERATETRANSACTIONPROCESSSITE].[SITEID] is null)))
                                        ) > 0
                                )
                                and (--Apply site filter

                                        @SITEFILTERMODE = 0
                                                or BPI.SITEID in (
                                                        select SITEID
                                                        from dbo.UFN_SITE_BUILDDATALISTSITEFILTER (@CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED) 
                                                )
                                )
                        )
                order by [PROCESS].NAME;
                end