ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2673869E053B46B63588994 select f.forum_id FORUM_ID, fl.name FORUM_NAME, fl.description DESCRIPTION, th.forum_thread_id FORUM_THREAD_ID, th.subject SUBJECT, msg.message_body MESSAGE, fnd_date.date_to_displaydate(msg.creation_date,2) POSTED_DATE, ota_utility.get_learner_name(msg.person_id, null, msg.contact_id) USER_NAME from ota_forums_b f, ota_forums_tl fl, ota_forum_threads th, ota_forum_messages msg where fl.forum_id = f.forum_id and fl.language = Userenv('LANG') and f.forum_id = th.forum_id(+) and th.forum_thread_id = msg.forum_thread_id(+) and ((:P_FORUM_ID is not null and f.forum_id = :P_FORUM_ID) or :P_FORUM_ID is null) and (upper(msg.message_body) like upper(:P_MESSAGE||'%') or :P_MESSAGE is null) and (upper(ota_utility.get_learner_name(msg.person_id, null, msg.contact_id)) like upper('%'||:P_AUTHOR||'%') or :P_AUTHOR is null) and ( (:P_FROM_DATE is null) or (trunc(msg.creation_date) >= trunc(:P_FROM_DATE)) ) and ( (:P_TO_DATE is null) or (trunc(msg.creation_date) <= trunc(:P_TO_DATE)) ) and f.business_group_id = ota_general.get_business_group_id and ota_admin_access_util.admin_can_access_forum(f.forum_id)='Y' group by f.forum_id, fl.name, fl.description, th.forum_thread_id, th.subject, th.last_post_date, msg.message_body, msg.creation_date, ota_utility.get_learner_name(msg.person_id, null, msg.contact_id) order by fl.name, th.subject, msg.message_body, msg.creation_date Y OTA OTAFRM Y AR OTA تقرير المنتدى في OLM Application: إدارة التعليم Source: تقرير المنتدى في OLM Short Name: OTAFRM DB package: OTA_FRM_XMLP_PKG D OTA OLM-Foren Application: Learning Management Source: OLM-Foren Short Name: OTAFRM DB package: OTA_FRM_XMLP_PKG F OTA OLM - Etat du forum Application: Learning Management Source: OLM - Etat du forum Short Name: OTAFRM DB package: OTA_FRM_XMLP_PKG US OTA OLM Forum Application: Learning Management Source: OLM Forum Report Short Name: OTAFRM DB package: OTA_FRM_XMLP_PKG ZHS OTA OLM 论坛报表 Application: Oracle Learning Management Source: OLM 论坛报表 Short Name: OTAFRM DB package: OTA_FRM_XMLP_PKG BI Publisher :c_forum_name :c_from_date :c_to_date :p_author :p_forum_id :p_from_date :p_message :p_to_date 1 10 :p_forum_id LOV Oracle OTA_FORUMS Y select forum_id id, name value, null description from ota_forums_vl where business_group_id=ota_general.get_business_group_id and ota_admin_access_util.admin_can_access_forum(forum_id)='Y' order by value,description AR اسم المنتدى D Forumbezeichnung F Nom du forum US Forum Name ZHS 论坛名 2 20 :p_author Char AR المؤلف D Verfasser F Auteur US Author ZHS 作者 3 30 :p_message Char AR الرسالة D Nachricht US Message ZHS 消息 4 40 :p_from_date Date AR من تاريخ D Von Datum F Date - Du US From Date ZHS 自日期 5 50 :p_to_date Date AR إلى تاريخ D Bis Datum F Date - Au US To Date ZHS 至日期