USP_DATALIST_TRIBUTEACKNOWLEDGEMENTPROCESS

                create procedure dbo.USP_DATALIST_TRIBUTEACKNOWLEDGEMENTPROCESS
                as 
                begin
                    set nocount on

                    select 
                        TAP.ID, 
                        TAP.NAME as PROCESSNAME,
                        TAP.DESCRIPTION, 
                        TRIBUTELETTERCODE.NAME,
                        case TAP.MARKLETTERSACKNOWLEDGED
                            when 0 then null
                            else
                                case TAP.ACKNOWLEDGEDATETYPECODE
                                    when 0 then getdate()
                                    else TAP.ACKNOWLEDGEDATE 
                                end 
                        end    as ACKNOWLEDGEDATE,
                        BPI.OWNERID as OWNERID
                    from dbo.TRIBUTEACKNOWLEDGEMENTPROCESS TAP
                        inner join dbo.TRIBUTELETTERCODE on TAP.TRIBUTELETTERCODEID = TRIBUTELETTERCODE.ID
                        left join dbo.BUSINESSPROCESSINSTANCE BPI on TAP.ID = BPI.BUSINESSPROCESSPARAMETERSETID                                            
                    order by PROCESSNAME;
                end