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
select i.parent_item, i.ims_item_id, i.item_title as item_title
from ims_cp_items i, cr_items ci, cr_revisions cr
where i.org_id = :org_id
and ci.item_id=cr.item_id
and cr.revision_id=i.ims_item_id
and exists (select 1
from acs_object_party_privilege_map p
where p.object_id = i.ims_item_id
and p.party_id = :user_id
and p.privilege = 'read')
order by i.sort_order,ci.tree_sortkey