SELECT p.person_id, gp.person_id , pc.vo_person_category_id , p.first_name||' '||p.last_name FULL_NAME, vo.company_name, listagg(vg.name, ', ')
WITHIN GROUP (ORDER BY vg.name ) GROUP_NAME
FROM GU_PERSON gp, PERSON p, VO_PERSON_CATEGORY pc, VEHICLE_OWNER vo, VO_GROUP vg, VO_GROUP_PERSON vgp
WHERE p.vo_person_category_id=pc.vo_person_category_id
AND pc.vehicle_owner_id=vo.vehicle_owner_id
AND p.person_id=gp.person_id
AND  p.person_id =vgp.person_id(+)
AND vgp.vo_group_id= vg.vo_group_id(+)
AND gp.gui_user_id = 101541
AND p.person_id = 108315
GROUP BY p.person_id , gp.person_id , pc.vo_person_category_id , p.first_name||' '||p.last_name, vo.company_name;