Index: openacs-4/packages/acs-admin/lib/service-parameters-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/lib/Attic/service-parameters-oracle.xql,v
diff -u -N -r1.5 -r1.6
--- openacs-4/packages/acs-admin/lib/service-parameters-oracle.xql	23 Jan 2004 14:29:25 -0000	1.5
+++ openacs-4/packages/acs-admin/lib/service-parameters-oracle.xql	7 Aug 2017 23:47:45 -0000	1.6
@@ -7,13 +7,14 @@
         <querytext>
                     select package_id,
                            ap.package_key,
-                           acs_object.name(package_id) as instance_name,
+                           --acs_object.name(package_id) as instance_name,
+			   pretty_name as instance_name,
                            apm_package_type.num_parameters(ap.package_key) as parameter_count
                     from apm_packages ap,
                          apm_package_types
                     where ap.package_key = apm_package_types.package_key
                     and package_type = 'apm_service'
-                    and   (ap.package_key != 'acs-subsite' or (select parent_id from site_nodes where object_id = package_id) is null)
+                    and   (ap.package_key != 'acs-subsite')
                     order by instance_name
         </querytext>
     </fullquery>