ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2643869E053B46B63588994Y SELECT DISTINCT msg.chat_id CHAT_ID, tl.name CHAT_NAME, decode(nvl(trainer.IS_INSTRUCTOR,'N'),'Y','Instructor','N','Active Participant') PERSON_TYPE, ota_utility.get_learner_name(msg.person_id, null, msg.contact_id) FULL_NAME FROM ( select sr.trainer_id as trainer_id, 'Y' as IS_INSTRUCTOR from ota_resource_bookings rb, ota_suppliable_resources sr, OTA_CHATS_TL tl, OTA_CHATS_B ch, OTA_CHAT_MESSAGES msg where rb.supplied_resource_id = sr.supplied_Resource_id and rb.chat_id = ch.chat_id and ch.chat_id = tl.chat_id and ((:P_CHAT_ID is not null and ch.chat_id = :P_CHAT_ID) or :P_CHAT_ID is null) and tl.language = Userenv('LANG') and ch.business_group_id = ota_general.get_business_group_id and ch.chat_id = msg.chat_id and ( (:P_MESSAGE_START_DATE is null) or (trunc(msg.creation_date) >= trunc(:P_MESSAGE_START_DATE)) ) and ( (:P_MESSAGE_END_DATE is null) or (trunc(msg.creation_date) <= trunc(:P_MESSAGE_END_DATE)) ) and msg.person_id = sr.trainer_id group by sr.trainer_id, ch.chat_id ) trainer, OTA_CHATS_TL tl, OTA_CHATS_B ch, OTA_CHAT_MESSAGES msg WHERE ch.chat_id = tl.chat_id and msg.chat_id = ch.chat_id and ((:P_CHAT_ID is not null and ch.chat_id = :P_CHAT_ID) or :P_CHAT_ID is null) and ch.business_group_id = ota_general.get_business_group_id and tl.language = Userenv('LANG') and ( (:P_MESSAGE_START_DATE is null) or (trunc(msg.creation_date) >= trunc(:P_MESSAGE_START_DATE)) ) and ( (:P_MESSAGE_END_DATE is null) or (trunc(msg.creation_date) <= trunc(:P_MESSAGE_END_DATE)) ) and msg.person_id = trainer.trainer_id(+) and (msg.person_id is not null or msg.contact_id is not null) and ota_admin_access_util.admin_can_access_chat(ch.chat_id)='Y' order by tl.name, ota_utility.get_learner_name(msg.person_id, null, msg.contact_id) OTA OTACHT AR OTA تقرير المحادثة في OLM Application: إدارة التعليم Source: تقرير المحادثة في OLM Short Name: OTACHT DB package: OTA_CHT_XMLP_PKG D OTA OLM-Chats Application: Learning Management Source: OLM-Chats Short Name: OTACHT DB package: OTA_CHT_XMLP_PKG F OTA OLM - Etat de la discussion Application: Learning Management Source: OLM - Etat de la discussion Short Name: OTACHT DB package: OTA_CHT_XMLP_PKG US OTA OLM Chat Application: Learning Management Source: OLM Chat Report Short Name: OTACHT DB package: OTA_CHT_XMLP_PKG ZHS OTA OLM 聊天报表 Application: Oracle Learning Management Source: OLM 聊天报表 Short Name: OTACHT DB package: OTA_CHT_XMLP_PKG BI Publisher :c_chat_content_type :c_chat_name :c_from_date :c_to_date :p_chat_id :p_message_end_date :p_message_start_date :p_type 1 10 :p_chat_id LOV Oracle OTA_CHATS Y select chat_id id, name value, null description from ota_chats_vl where business_group_id=ota_general.get_business_group_id and ota_admin_access_util.admin_can_access_chat(chat_id)='Y' order by value,description AR اسم المحادثة D Chat-Bezeichnung F Nom de la discussion US Chat Name ZHS 聊天名 2 20 :p_message_start_date Date AR تاريخ بداية الرسالة D Startdatum Nachricht F Date de début du message US Message Start Date ZHS 消息起始日期 3 30 :p_message_end_date Date AR تاريخ نهاية الرسالة D Enddatum Nachricht F Date de fin du message US Message End Date ZHS 消息终止日期 4 40 :p_type LOV Oracle OTA_CHAT_REPORT_LIST Y select es.lookup_code id, es.meaning value, null description from hr_lookups es where es.lookup_type='OTA_CHAT_REPORT_TYPES' 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 Inhaltsart F Type de contenu US Content Type ZHS 内容类型