select t.package_key,
t.package_uri,
t.pretty_name,
t.pretty_plural,
t.package_type,
t.initial_install_p,
t.singleton_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 path,
file_type,
db_type
from apm_package_files
where version_id = :version_id
order by path
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
from apm_parameters
where package_key = :package_key
order by parameter_name