USP_DATALIST_ACKNOWLEDGEMENTANDRECEIPTPROCESS

                create procedure dbo.USP_DATALIST_ACKNOWLEDGEMENTANDRECEIPTPROCESS
                as
                    set nocount on;

                    select
                        PROCESS.ID,
                        PROCESSTYPE = 0,
                        'Acknowledgement processes' as NAME,
                        PROCESS.NAME as PROCESSNAME,
                        PROCESS.DESCRIPTION as DESCRIPTION,
                        convert(nvarchar(10), max(BPSTATUS.STARTEDON), 101) + right(convert(nvarchar(20), max(BPSTATUS.STARTEDON), 0), 8) 

                    from
                        dbo.ACKNOWLEDGEMENTPROCESS PROCESS
                    left join
                        dbo.ACKNOWLEDGEMENTPROCESSSTATUS STATUS on PROCESS.ID = STATUS.PARAMETERSETID
                    left join
                        dbo.BUSINESSPROCESSSTATUS BPSTATUS on STATUS.ID = BPSTATUS.ID
                    group by
                        PROCESS.ID, PROCESS.NAME, PROCESS.DESCRIPTION

                    union all

                    select
                        PROCESS.ID,
                        PROCESSTYPE = 1,
                        'Receipting processes' as NAME,
                        PROCESS.NAME as PROCESSNAME,
                        PROCESS.DESCRIPTION as DESCRIPTION,
                        convert(nvarchar(10), max(BPSTATUS.STARTEDON), 101) + right(convert(nvarchar(20), max(BPSTATUS.STARTEDON), 0), 8) 

                    from
                        dbo.RECEIPTINGPROCESS PROCESS
                    left join
                        dbo.RECEIPTINGPROCESSSTATUS STATUS on PROCESS.ID = STATUS.PARAMETERSETID
                    left join
                        dbo.BUSINESSPROCESSSTATUS BPSTATUS on STATUS.ID = BPSTATUS.ID
                    group by
                        PROCESS.ID, PROCESS.NAME, PROCESS.DESCRIPTION;