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 o.object_id, repeat(' ', (tree_level(tree_sortkey) - :indent)* 2) as indent, i.item_id, i.item_title as item_title, i.hasmetadata, i.item_id as identifierref, i.type, i.org_id, m.fs_package_id, m.folder_id, m.course_name from acs_objects o, ims_cp_items i, ims_cp_manifests m where o.object_type = 'ims_item' and i.org_id = :org_id and o.object_id = i.item_id and m.man_id = :man_id order by object_id, tree_sortkey