select max(d.as_item_display_id) as as_item_display_id from cr_revisions r, as_item_rels ir, cr_revisions r2, as_item_display_cb d where r.revision_id = :as_item_id and r2.item_id = r.item_id and ir.item_rev_id = r2.revision_id and ir.rel_type = 'as_item_display_rel' and d.as_item_display_id = ir.target_rev_id select d.html_display_options, d.choice_orientation, d.choice_label_orientation, d.sort_order_type, d.item_answer_alignment from cr_revisions r, as_item_display_cb d where r.revision_id = d.as_item_display_id and d.as_item_display_id = :as_item_display_id update as_assessment_section_map set section_id = :new_section_id where assessment_id = :new_assessment_rev_id and section_id = :section_id update as_item_section_map set as_item_id = :new_item_id where section_id = :new_section_id and as_item_id = :as_item_id update as_item_rels set target_rev_id = :new_item_display_id where item_rev_id = :new_item_id and rel_type = 'as_item_display_rel'