select item_id
from cr_revisions
where revision_id = :as_item_type_id
select cr.title, i.default_value, i.feedback_text
from cr_revisions cr, as_item_type_oq i
where cr.revision_id = :type_id
and i.as_item_type_id = cr.revision_id
select default_value
from as_item_type_oq
where as_item_type_id = :type_id