oracle8.1.6 select o.object_id, acs_object.name(o.object_id) as name, context_id, object_type, (case when o.object_id = :root then 0 else 1 end) as child from acs_objects o where exists ( SELECT 1 FROM all_object_party_privilege_map map WHERE map.object_id = o.object_id and map.party_id = :user_id and map.privilege = 'admin') and (o.object_id = :root or o.context_id = :root) order by child, object_type, name