select
org_id
from
ims_cp_organizations
where
man_id = :man_id
select
org.org_id,
org.org_title as org_title,
org.hasmetadata,
tree_level(o.tree_sortkey) as indent
from
ims_cp_organizations org, acs_objects o
where
org.org_id = o.object_id
and
man_id = :man_id
order by
org_id
select
fs_package_id
from
ims_cp_manifests
where
man_id = :man_id