oracle8.1.6 select r.title, i.name as file_name from cr_items i, cr_revisions r where i.item_id = :attach_id and r.revision_id = content_item.get_latest_revision(i.item_id)