UFN_FENXT_INTEGRATEDPDACCOUNTSYSTEMS_TOITEMLISTXML

        create function dbo.UFN_FENXT_INTEGRATEDPDACCOUNTSYSTEMS_TOITEMLISTXML()
        returns xml
        with execute as caller
        as
            begin
                declare @ACCOUNTSYSTEMS xml;

                set @ACCOUNTSYSTEMS = (select PDACCOUNTSYSTEMID
                                        from dbo.FENXTINTEGRATION inner join dbo.FENXTTOKEN on FENXTINTEGRATION.ENVIRONMENTID = FENXTTOKEN.ENVIRONMENTID
                                        where FENXTTOKEN.REFRESHTOKEN is not null
                                        for xml raw('ITEM'),type,elements,root('INTEGRATEDSYSTEMS'),BINARY BASE64);

                return (@ACCOUNTSYSTEMS);
            end