Index: openacs-4/packages/acs-admin/www/apm/version-dependencies-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/version-dependencies-oracle.xql,v diff -u -N -r1.3 -r1.3.4.1 --- openacs-4/packages/acs-admin/www/apm/version-dependencies-oracle.xql 27 Oct 2014 16:38:53 -0000 1.3 +++ openacs-4/packages/acs-admin/www/apm/version-dependencies-oracle.xql 3 Apr 2021 14:10:06 -0000 1.3.4.1 @@ -2,41 +2,41 @@ oracle8.1.6 - - - - select package_key, pretty_name, version_name, installed_p - from apm_package_version_info + + + + select package_key, pretty_name, version_name, installed_p + from apm_package_version_info where version_id = :version_id - + - - - - - select dependency_id, service_uri, service_version - from apm_package_dependencies - where version_id = :version_id - and dependency_type = :dependency_type_prep - order by service_uri - - + + + + + select dependency_id, service_uri, service_version + from apm_package_dependencies + where version_id = :version_id + and dependency_type = :dependency_type_prep + order by service_uri + + - - + + select t.pretty_name dep_pretty_name, v.version_name dep_version_name, v.version_id dep_version_id, d.dependency_type as dep_type from apm_package_versions v, apm_package_dependencies d, apm_package_types t where d.service_uri = :service_uri and d.dependency_type in ($other_dependency_in) and d.version_id = v.version_id - and t.package_key = v.package_key + and t.package_key = v.package_key and apm_package_version.sortable_version_name(d.service_version) $sign apm_package_version.sortable_version_name(:service_version) - +