oracle8.1.6
select org.org_id, org.org_title as org_title, org.hasmetadata,
(select level
from acs_objects
connect by prior object_id = context_id
start with object_id = org.org_id) as indent
from ims_cp_organizations org
where man_id = :man_id
order by org_id
select i.ims_item_id as object_id,
((select level
from acs_objects connect by prior object_id = context_id
start with object_id = i.org_id) - :indent
) * 2 as indent,
i.ims_item_id, i.item_title as item_title,
i.hasmetadata, i.ims_item_id as identifierref,
i.type, i.org_id, m.fs_package_id,
m.folder_id, m.course_name
from ims_cp_items i, ims_cp_manifests m
where i.org_id = :org_id and m.man_id = :man_id
order by indent, ims_item_id;