SELECT vr.role_id, r.name, s.str_value, r.DESCRIPTION
FROM vo_role vr, ROLE r, vehicle_owner vo, str s, str k, GUI_USERS g
WHERE vr.vehicle_owner_id=vo.vehicle_owner_id
AND vr.role_id=r.role_id
AND r.name_str_id=s.str_id(+)
AND r.description_str_id=k.str_id(+)
AND vo.vehicle_owner_id = 100658
AND s.LANGUAGE = g.LANGUAGE
AND g.GUI_USER_ID = 101887;