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