USP_DATALIST_TRIBUTEACKNOWLEDGEE

                CREATE procedure dbo.USP_DATALIST_TRIBUTEACKNOWLEDGEE
                (
                    @TRIBUTEID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        ACK.ID,
                        NF.NAME as ACKNOWLEDGEE,
                        CONSTITUENT.ID as ACKNOWLEDGEEID,
                        CONSTITUENT.LOOKUPID,
                        TRIBUTELETTERCODE.NAME,
                        ACK.TRIBUTELETTERCODEID,
                        ACK.CONSTITUENTID,
                        (select TRIBUTETEXT from dbo.TRIBUTE where TRIBUTE.ID = ACK.TRIBUTEID) as TRIBUTETEXT
                    from 
                        dbo.TRIBUTEACKNOWLEDGEE ACK
                    inner join
                        dbo.CONSTITUENT on ACK.CONSTITUENTID = CONSTITUENT.ID
                    left join
                        dbo.TRIBUTELETTERCODE on ACK.TRIBUTELETTERCODEID = TRIBUTELETTERCODE.ID
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
                    where 
                        ACK.TRIBUTEID = @TRIBUTEID
                    order by
                        CONSTITUENT.KEYNAME, CONSTITUENT.FIRSTNAME;