oracle8.1.6 select object_type as ancestor_rel_type from acs_object_types where supertype = 'relationship' and object_type in ( select object_type from acs_object_types start with object_type = :rel_type connect by object_type = prior supertype ) select r.rel_id, party_names.party_name as element_name from (select /*+ ORDERED */ DISTINCT rels.rel_id, object_id_two from $extra_tables acs_rels rels, acs_object_party_privilege_map perm where perm.object_id = rels.rel_id and perm.party_id = :user_id and perm.privilege = 'read' and rels.rel_type = :rel_type and rels.object_id_one = :group_id $extra_where_clauses) r, party_names where r.object_id_two = party_names.party_id order by lower(element_name)