select p.package_key, p.package_uri, p.pretty_name, v.version_name from apm_package_types p, apm_package_versions v where v.version_id = :version_id and v.package_key = p.package_key