Index: openacs-4/packages/acs-subsite/tcl/subsite-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/tcl/subsite-procs-oracle.xql,v diff -u -N -r1.9 -r1.10 --- openacs-4/packages/acs-subsite/tcl/subsite-procs-oracle.xql 17 Mar 2009 01:11:07 -0000 1.9 +++ openacs-4/packages/acs-subsite/tcl/subsite-procs-oracle.xql 2 Feb 2010 23:35:28 -0000 1.10 @@ -67,6 +67,7 @@ where not (apm_package.singleton_p(package_key) = 1 and apm_package.num_instances(package_key) >= 1) and implements_subsite_p = 'f' + and package_type = 'apm_application' order by upper(pretty_name)