oracle8.1.6 select distinct t.pretty_name, c.child_type from acs_object_types t, cr_type_children c where c.parent_type = content_item.get_content_type(:item_id) and c.child_type = t.object_type select r.rel_id, r.child_id item_id, t.pretty_name as type_name, NVL(r.relation_tag, '-') as tag, trim(NVL(content_item.get_title(r.child_id), i.name)) title, ot.pretty_name as content_type from cr_child_rels r, acs_objects o, acs_object_types t, cr_items i, acs_object_types ot where r.parent_id = :item_id and o.object_id = r.rel_id and t.object_type = o.object_type and i.item_id = r.child_id and ot.object_type = i.content_type order by order_n, title