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