select cr.title ,ci.item_id as assessment_id from cr_folders cf, cr_items ci, cr_revisions cr, as_assessments a where cr.revision_id = ci.latest_revision and a.assessment_id = cr.revision_id and ci.parent_id = cf.folder_id and cf.package_id = :package_id order by cr.title
select to_date(now(),'YYYY-MM-DD')
select to_date (to_date(now(),'YYYY-MM-DD')-1,'YYYY-MM-DD')
select to_date (to_date(now(),'YYYY-MM-DD')-2,'YYYY-MM-DD')
select to_date (to_date(now(),'YYYY-MM-DD')-7,'YYYY-MM-DD')
select to_date (to_date(now(),'YYYY-MM-DD')-30,'YYYY-MM-DD')
select max(am.order_by) from as_action_map am,as_inter_item_checks c
where c.inter_item_check_id=am.inter_item_check_id and
c.section_id_from = :section_id and am.action_perform=:action_perform
select item_id from as_param_map where parameter_id=:parameter_id and inter_item_check_id=:check_id
select value from as_param_map where parameter_id=:parameter_id and inter_item_check_id=:check_id
update as_param_map set item_id=:value where parameter_id=:parameter_id and inter_item_check_id=:check_id
insert into as_param_map (parameter_id,inter_item_check_id,value,item_id) values (:parameter_id,:check_id,null,:value)
insert into as_param_map (parameter_id,inter_item_check_id,value,item_id) values (:parameter_id,:check_id,:value,null)
update as_param_map set value=:value where parameter_id=:parameter_id and inter_item_check_id=:check_id
select order_by from as_action_map where inter_item_check_id=:check_id
select c.inter_item_check_id from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and c.section_id_from = :section_id and am.action_perform=:action_perform and am.order_by > :order_by
update as_action_map set order_by=:order where inter_item_check_id=:inter_item_check_id
select c.inter_item_check_id from as_inter_item_checks c ,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and am.order_by=:order and c.section_id_from=:section_id and am.action_perform=:action_perform
update as_action_map set order_by=:order where inter_item_check_id=:check_id
update as_action_map set order_by=:order_by where inter_item_check_id=:swap_check_id
select c.inter_item_check_id from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and am.order_by=:order and c.section_id_from=:section_id and am.action_perform=:action_perform
update as_action_map set order_by=:order where inter_item_check_id=:check_id
update as_action_map set order_by=:order_by where inter_item_check_id=:swap_check_id
select am.action_id from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and c.inter_item_check_id=:check_id
insert into as_actions_log (action_log_id,inter_item_check_id,action_id,date_requested,date_processed,approved_p,failed_p,finally_executed_by,session_id) values (:log_id,:check_id,:action_id,now(),now(),'t',:failed,:user_id,:session_id)
select am.action_id from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and c.inter_item_check_id=:check_id
insert into as_actions_log (action_log_id,inter_item_check_id,action_id,date_requested,date_processed,approved_p,failed_p,finally_executed_by,session_id) values (:log_id,:check_id,:action_id,now(),null,'f','f',null,:session_id)
select * from as_param_map where inter_item_check_id = :inter_item_check_id
select varname from as_action_params where parameter_id = :parameter_id
select item_data_id, boolean_answer, clob_answer, numeric_answer,
integer_answer, text_answer, timestamp_answer, content_answer
from as_item_data
where session_id = :session_id
and as_item_id = :item_id
select item_data_id, boolean_answer, clob_answer, numeric_answer,
integer_answer, text_answer, timestamp_answer, content_answer
from as_item_data
where session_id = :session_id
and as_item_id = :item_id
select idc.choice_id from as_item_data_choices idc,as_item_data id where id.as_item_id=:item_id and id.item_data_id=idc.item_data_id and id.session_id=:session_id
select a.tcl_code from as_actions a,as_action_map am where am.action_id = a.action_id and am.inter_item_check_id = :inter_item_check_id
select * from as_param_map where inter_item_check_id = :inter_item_check_id
select varname from as_action_params where parameter_id = :parameter_id
select idc.choice_id from as_item_data_choices idc,as_item_data id where id.as_item_id=:item_id and id.item_data_id=idc.item_data_id and id.session_id=:session_id
select a.tcl_code from as_actions a,as_action_map am where am.action_id = a.action_id and inter_item_check_id = :inter_item_check_id
update as_actions_log set failed_p=:failed_p,date_processed=now(),finally_executed_by=:user_id,approved_p='t' where action_log_id=:action_log_id
select c.inter_item_check_id,c.check_sql,action_p from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and am.action_perform='i' and section_id_from=:section_id order by am.order_by
select * from as_inter_item_checks where action_p = 'f' and section_id_from=:section_id
select sort_order from as_assessment_section_map where section_id=:section_id_to and assessment_id=:new_assessment_revision
select max(revision_id) from cr_revisions where item_id=:assessment_id
select s.section_id from as_sections s, cr_revisions cr, cr_items ci, as_assessment_section_map asm where ci.item_id = cr.item_id and cr.revision_id = s.section_id and s.section_id = asm.section_id and asm.assessment_id =:assessment_rev_id order by asm.sort_order
select c.inter_item_check_id as check from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and am.action_perform='aa' and section_id_from=:section_id order by am.order_by
select * from as_inter_item_checks c,as_action_map am where
c.inter_item_check_id=am.inter_item_check_id and am.action_perform='aa'
and section_id_from=:section_id and c.inter_item_check_id=:check order by am.order_by
select max(revision_id) from cr_revisions where item_id=:assessment_id
select s.section_id from as_sections s, cr_revisions cr, cr_items ci, as_assessment_section_map asm where ci.item_id = cr.item_id and cr.revision_id = s.section_id and s.section_id = asm.section_id and asm.assessment_id =:assessment_rev_id order by asm.sort_order
select * from as_inter_item_checks c,as_action_map am where c.inter_item_check_id=am.inter_item_check_id and am.action_perform='m' and section_id_from=:section_id order by am.order_by
select * from as_inter_item_checks where inter_item_check_id=:check_id
select a.name as action_name from as_actions a, as_action_map am where inter_item_check_id=:check_id and a.action_id=am.action_id
select * from as_param_map pm,as_action_params p where pm.parameter_id=p.parameter_id and pm.inter_item_check_id=:check_id
select cr.title from cr_revisions cr,as_sections s where cr.revision_id=s.section_id and s.section_id=:section_id_to
select action_id,order_by,user_message,action_perform from as_action_map where inter_item_check_id=:inter_item_check_id
insert into as_action_map (inter_item_check_id,action_id,order_by,user_message,action_perform) values
(:insert_p,:action_id,:order_by,:user_message,:action_perform)
select parameter_id,value,item_id from as_param_map
where inter_item_check_id=:inter_item_check_id
insert into as_param_map (parameter_id,value,item_id,inter_item_check_id) values (:parameter_id,:value,:item_id,:insert_p)
select inter_item_check_id from as_inter_item_checks where section_id_to =:section_id
update as_inter_item_checks set section_id_to=:new_section_id where inter_item_check_id=:check_id
select inter_item_check_id from as_inter_item_checks where section_id_from in (select s.section_id from as_sections s, cr_revisions cr, cr_items ci, as_assessment_section_map asm where ci.item_id = cr.item_id and cr.revision_id = s.section_id and s.section_id = asm.section_id and asm.assessment_id =:assessment_rev_id)