USP_DATALIST_FENXTSYNCPROCESS

            CREATE procedure dbo.USP_DATALIST_FENXTSYNCPROCESS
                as
                set nocount on;

                select 
                    FENXTSYNCPROCESS.ID,
                    FENXTSYNCPROCESS.NAME,
                    FENXTSYNCPROCESS.DESCRIPTION,
                    PDACCOUNTSYSTEM.NAME as PDACCOUNTSYSTEMNAME
                from dbo.FENXTSYNCPROCESS
                inner join dbo.FENXTINTEGRATION on FENXTSYNCPROCESS.FENXTINTEGRATIONID = FENXTINTEGRATION.ID
                inner join dbo.PDACCOUNTSYSTEM on FENXTINTEGRATION.PDACCOUNTSYSTEMID = PDACCOUNTSYSTEM.ID;