USP_DATALIST_PERSONALACCESSTOKEN

                CREATE procedure dbo.USP_DATALIST_PERSONALACCESSTOKEN
                (
                    @APPUSERID uniqueidentifier,
                    @INCLUDEINACTIVE bit = 0
                )
                as
                    set nocount on;

                    select 
                           PERSONALACCESSTOKEN.ID,
                           PERSONALACCESSTOKEN.NAME,
                           PERSONALACCESSTOKEN.ENABLED,
                           PERSONALACCESSTOKEN.DATEADDED,
                           PERSONALACCESSTOKEN.EXPIRATIONDATE,
                           PERSONALACCESSTOKENREVOKECODE.DESCRIPTION,
                           PERSONALACCESSTOKENREVOKEDETAIL.DETAILS
                    from 
                           dbo.PERSONALACCESSTOKEN
                           left join dbo.PERSONALACCESSTOKENREVOKEDETAIL on PERSONALACCESSTOKEN.ID = PERSONALACCESSTOKENREVOKEDETAIL.ID
                           left join dbo.PERSONALACCESSTOKENREVOKECODE on PERSONALACCESSTOKENREVOKEDETAIL.PERSONALACCESSTOKENREVOKECODEID = PERSONALACCESSTOKENREVOKECODE.ID
                    where 
                           PROXYUSERID = @APPUSERID 
                           and (PERSONALACCESSTOKEN.ENABLED = 1 or @INCLUDEINACTIVE = 1)
                   order by 
                           ENABLED, PERSONALACCESSTOKEN.NAME