USP_DATALIST_ADDOPPORTUNITIESPROCESS

                    CREATE procedure dbo.USP_DATALIST_ADDOPPORTUNITIESPROCESS
                    (
                        @CURRENTAPPUSERID uniqueidentifier = null
                    )
                    as
                        set nocount on;

                        select
                            PROCESS.ID,
                            PROCESS.NAME,
                            PROCESS.DESCRIPTION,
                            IDSETREGISTER.NAME as [IDSETREGISTER],
                            CODE.DESCRIPTION [OPPORTUNITYTYPE],
                            dbo.UFN_ADDOPPORTUNITIESPROCESS_OPPORTUNITYSTATUSCODE_GETDESCRIPTION(PROCESS.OPPORTUNITYSTATUSCODE) OPPORTUNITYSTATUS,
                            PROCESS.EXPECTEDASKAMOUNT,
                            PROCESS.TRANSACTIONCURRENCYID,
                            BPI.OWNERID as OWNERID,
                            PROCESS.EXPECTEDASKDATE,
                            PROCESS.ASKAMOUNT,
                            PROCESS.ASKDATE,
                            dbo.UFN_LIKELIHOODTYPECODE_GETDESCRIPTION(PROCESS.LIKELIHOODTYPECODEID) LIKELIHOODTYPECODEID,
                            PROCESS.RESPONSEDATE,
                            PROCESS.COMMENT
                        from
                            dbo.ADDOPPORTUNITIESPROCESS [PROCESS]
                            left join dbo.BUSINESSPROCESSINSTANCE BPI on PROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                            left join dbo.OPPORTUNITYTYPECODE CODE on PROCESS.OPPORTUNITYTYPECODEID = CODE.ID
                            left join dbo.IDSETREGISTER on IDSETREGISTER.ID = PROCESS.IDSETREGISTERID
                        where 
                            dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, PROCESS.ID) = 1
                        order by PROCESS.NAME