select t.package_key, t.package_uri, t.pretty_name, t.pretty_plural, t.package_type, t.initial_install_p, t.singleton_p, t.implements_subsite_p, t.inherit_templates_p, v.* from apm_package_versions v, apm_package_types t where v.version_id = :version_id and v.package_key = t.package_key select owner_uri, owner_name from apm_package_owners where version_id = :version_id order by sort_key, owner_uri select dependency_type, service_uri, service_version from apm_package_dependencies where version_id = :version_id order by dependency_type, service_uri select type, proc from apm_package_callbacks where version_id = :version_id select type, proc from apm_package_callbacks where version_id = :version_id select parameter_name, description, datatype, section_name, default_value, min_n_values, max_n_values, scope from apm_parameters where package_key = :package_key order by parameter_name