Report ExamObjects

SELECT a.clear_all_flags_when_failed, 
       a.exit_course_when_failed, 
       a.lock_course_when_failed, 
       a.lock_exam_when_failed, 
       a.notify_proctor_when_failed, 
       a.set_flags_when_failed, 
       a.clear_flags_when_failed 
FROM   pa_cbt_exam_def a 
WHERE  exam_name = ? 

SELECT a.exit_course_when_passed, 
       a.lock_course_when_passed, 
       a.lock_exam_when_passed, 
       a.set_flags_when_passed, 
       a.clear_flags_when_passed 
FROM   pa_cbt_exam_def a 
WHERE  exam_name = ? 

SELECT a.exam_name, 
       a.description, 
       a.is_active, 
       a.is_online, 
       a.is_survey, 
       b.cpnt_id, 
       a.no_of_questions, 
       a.grade_exam, 
       a.resumeable, 
       Nvl(f.exam_duration, 0) AS alloted_time, 
       a.display_point_value, 
       a.feedback_option, 
       a.messages_enabled, 
       a.exam_type_message, 
       a.repeat_count, 
       a.proctor_required, 
       a.reviewable, 
       a.pass_grade, 
       etype.label_id          AS exam_type 
FROM   pa_cbt_exam_def a, 
       ps_cbt_exam_def_type etype, 
       pa_cbt_cpnt_mod f, 
       pa_cbt_cpnt b 
WHERE  a.exam_type = etype.exam_type 
       AND f.cpnt_id = b.cpnt_id 
       AND f.exam_name = a.exam_name 
/** and a.exam_name in [ExamNameSearch]      and [security:pa_cbt_exam_def a] */ 

SELECT display_message, 
       msgType.label_id AS message_type, 
       message, 
       stud_sig_reqd 
FROM   pa_cbt_exam_def_msg msg, 
       ps_cbt_exam_def_msg_type msgType 
WHERE  exam_name = ? 
       AND msg.message_type = msgType.message_type 

SELECT a.objective_id, 
       objective, 
       min_questions, 
       max_questions, 
       pass_grade, 
       points_per_objective 
FROM   pa_cbt_exam_obj a, 
       pa_cbt_objective b 
WHERE  exam_name = ? 
       AND a.objective_id = b.objective_id 
ORDER  BY objective_id 

SELECT o.objective_id, 
       o.objective, 
       q.question_name, 
       q.version, 
       q.revision, 
       eq.point_value 
FROM   pa_cbt_exam_question eq, 
       pa_cbt_question q, 
       pa_cbt_question_metadata m, 
       pa_cbt_objective o 
WHERE  eq.exam_name = ? 
       AND eq.question_id = q.question_id 
       AND q.question_name = m.question_name 
       AND m.objective_id = o.objective_id(+)