ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2653869E053B46B63588994 select response_stat.activity_name COURSE_NAME, response_stat.class_name CLASS_NAME, sec.name SECTION_NAME, sec.test_section_id SECTION_ID, quest.text QUESTION_TEXT, quest.question_id, resptype.type_flag TypeFlag, respvalue.correct_flag CorrectFlag, respvalue.text RESPONSE_ANSWER, response_stat.per_response NUMBER_ANSWERED, respvalue.response_value_id, resptype.response_type_id from ota_tests test, ota_test_sections sec, ota_test_questions tq, ota_questions quest, ota_response_types resptype, ota_response_values respvalue, (select sum(decode(utr.answered_flag,'Y',1,0)) per_response, utr.response_value_id responsevalueid, utr.question_id questionid, evt_tl.title class_name, avt.version_name activity_name from ota_utest_questions utq, ota_utest_responses utr, ota_attempts att, ota_events evt, ota_activity_versions avt, ota_events_tl evt_tl where utq.object_type_flag= 'Q' and utq.attempt_id = att.attempt_id and att.time >0 and (att.score >=0 or att.score = -1000) and att.attempt_status = 'C' and utq.user_test_question_id = utr.user_test_question_id and ( (:P_ACTIVITY_ID is not null and :P_EVENT_ID is not null and avt.activity_Version_id = :P_ACTIVITY_ID and evt.event_id = :P_EVENT_ID and att.test_id = :TEST_ID or att.act_eval_id = :TEST_ID and att.event_id = :ATT_EVENT_ID ) OR (:P_ACTIVITY_ID is not null and :P_EVENT_ID is null and avt.activity_version_id = :P_ACTIVITY_ID and att.act_eval_id = :TEST_ID and att.event_id = :ATT_EVENT_ID ) OR (:P_ACTIVITY_ID is null and :P_EVENT_ID is not null and evt.event_id = :P_EVENT_ID and att.test_id = :TEST_ID or att.act_eval_id = :TEST_ID and att.event_id = :ATT_EVENT_ID ) OR (:P_ACTIVITY_ID is null and :P_EVENT_ID is null --and att.test_id = :TEST_ID or att.ACT_EVAL_ID = :TEST_ID and ( (att.test_id = :TEST_ID and :TYPE= 'CLASS') or (att.ACT_EVAL_ID = :TEST_ID and :TYPE = 'COURSE')) and att.event_id = :ATT_EVENT_ID ) ) and att.event_id = evt.event_id and ota_admin_access_util.admin_can_access_object('CL',evt.event_id)='Y' and evt.activity_version_id = avt.activity_version_id and evt_tl.event_id = evt.event_id and evt_tl.language = Userenv('LANG') and ( (:P_FROM_DATE is null) or (trunc(att.creation_date) >= trunc(:P_FROM_DATE)) ) and ( (:P_TO_DATE is null) or (trunc(att.creation_date) <= trunc(:P_TO_DATE)) ) group by utr.response_value_id, utr.question_id, utr.correct_flag, evt_tl.title, avt.version_name)response_stat where response_stat.questionid = quest.question_id and response_stat.responsevalueid = respvalue.response_value_id and test.test_id = sec.test_id and test.test_id = tq.test_id and sec.TEST_SECTION_ID = tq.section_id and tq.question_id = quest.question_id and tq.question_id = resptype.question_id and (resptype.type_flag = 'M' or resptype.type_flag = 'S' or resptype.type_flag = 'T') and resptype.response_type_id = respvalue.response_type_id and ( (:P_ACTIVITY_ID is not null and :P_EVENT_ID is not null and test.test_id = :TEST_ID ) OR (:P_ACTIVITY_ID is not null and :P_EVENT_ID is null and test.test_id = :TEST_ID ) OR (:P_ACTIVITY_ID is null and :P_EVENT_ID is not null and test.test_id = :TEST_ID ) OR (:P_ACTIVITY_ID is null and :P_EVENT_ID is null and test.test_id = :TEST_ID ) ) group by response_stat.activity_name, response_stat.class_name, sec.name, sec.test_section_id, quest.text, quest.question_id, resptype.type_flag, respvalue.correct_flag, respvalue.text, response_stat.per_response, respvalue.response_value_id, resptype.response_type_id order by response_stat.activity_name, response_stat.class_name, sec.name, quest.text, respvalue.text Y OTA OTAEVAL AR OTA تقرير تقييم البرنامج التدريبي في OLM Application: إدارة التعليم Source: تقرير تقييم البرنامج التدريبي في OLM Short Name: OTAEVAL DB package: OTA_EVAL_XMLP_PKG D OTA OLM-Kursbewertung Application: Learning Management Source: OLM-Kursbewertung Short Name: OTAEVAL DB package: OTA_EVAL_XMLP_PKG F OTA OLM - Etat d'évaluation du cours Application: Learning Management Source: OLM - Etat d'évaluation du cours Short Name: OTAEVAL DB package: OTA_EVAL_XMLP_PKG US OTA OLM Course Evaluation Application: Learning Management Source: OLM Course Evaluation Report Short Name: OTAEVAL DB package: OTA_EVAL_XMLP_PKG ZHS OTA OLM 课程评估报表 Application: Oracle Learning Management Source: OLM 课程评估报表 Short Name: OTAEVAL DB package: OTA_EVAL_XMLP_PKG BI Publisher :att_event_id :c_activity_version_name :c_answer_type :c_event_title :c_from_date :c_to_date :p_activity_id :p_answer_type :p_event_id :p_from_date :p_to_date :test_id :type 1 10 :p_activity_id LOV Oracle OTA_ACTIVITY_VERSIONS Y select activity_version_id id, version_name value, null description from ota_activity_versions_vl tav,ota_activity_definitions_vl tad where tad.activity_id=nvl(:$flex$.ota_activity_types:null,tad.activity_id) and tad.activity_id=tav.activity_id and tad.business_group_id=ota_general.get_business_group_id and ota_admin_access_util.admin_can_access_object('H',tav.activity_version_id)='Y' order by value,description AR اسم البرنامج التدريبي D Kursbezeichnung F Nom du cours US Course Name ZHS 课程名称 2 20 :p_event_id LOV Oracle OTA_CLASS_TITLE_LIST Y select evt_tl.event_id id, evt_tl.title value, null description from ota_events evt,ota_events_tl evt_tl,hr_all_organization_units org,ota_activity_versions_tl tav where org.organization_id(+)=evt.training_center_id and org.business_group_id(+)=evt.business_group_id and evt.event_id=evt_tl.event_id(+) and evt_tl.language=userenv('LANG') and tav.language=userenv('LANG') and evt.activity_version_id=tav.activity_version_id and evt.business_group_id=ota_general.get_business_group_id and tav.activity_version_id=nvl(:$flex$.ota_activity_versions:null,tav.activity_version_id) and ota_admin_access_util.admin_can_access_object('H',tav.activity_version_id)='Y' order by evt.title AR اسم الفصل الدراسي D Schulungsbezeichnung F Nom de session de cours US Class Name ZHS 课名称 3 30 :p_answer_type LOV Oracle OTA_EVAL_REPORT_TYPE_LIST Y select es.lookup_code id, es.meaning value, null description from hr_lookups es where es.lookup_type='OTA_EVAL_REPORT_TYPE' and sysdate between nvl(es.start_date_active,sysdate) and nvl (es.end_date_active,sysdate) and es.enabled_flag='Y' order by value,description Y AR نوع الإجابة D Antwortart F Type de réponse US Answer Type ZHS 答案类型 4 40 :p_from_date Date AR التاريخ من D Von Datum F Date - Du US Date From ZHS 日期自 5 50 :p_to_date Date AR التاريخ إلى D Bis Datum F Date - Au US Date To ZHS 日期至