list o branches

SELECT DISTINCT full_name,
                listagg(segment2, '; ') within GROUP (ORDER BY segment2) branch_list
FROM (SELECT DISTINCT rt.segment2,
            (SELECT ppv_s.full_name
            FROM per_people_v7 ppv_s
            WHERE ppv_s.person_id = ppv.attribute2) full_name
        FROM hz_cust_site_uses_all hcsua
        left join ra_territories rt ON rt.territory_id = hcsua.territory_id
        INNER JOIN jtf_rs_salesreps jrs ON jrs.salesrep_id = hcsua.primary_salesrep_id
        INNER JOIN jtf_rs_resource_extns_vl jrrev ON jrrev.resource_id = jrs.resource_id
        left join per_people_v7 ppv ON ppv.person_id = jrs.person_id
        WHERE 1=1
        AND ppv.attribute2 IS NOT NULL)
GROUP BY full_name;