247: jii.start_date_time s_date,
248: JRREV.resource_Name res_name,
249: JIRV.short_description result
250: FROM JTF_IH_INTERACTIONS JII,
251: JTF_RS_RESOURCE_EXTNS_TL JRREV,
252: JTF_IH_OUTCOMES_TL JIOV,
253: JTF_IH_RESULTS_TL JIRV
254: WHERE JII.resource_id = JRREV.resource_id
255: AND JRREV.LANGUAGE (+)= USERENV('LANG')
303: jii.start_date_time s_date,
304: JRREV.resource_Name res_name,
305: JIRV.short_description result
306: FROM JTF_IH_INTERACTIONS JII,
307: JTF_RS_RESOURCE_EXTNS_TL JRREV,
308: JTF_IH_OUTCOMES_TL JIOV,
309: JTF_IH_RESULTS_B JIRB,
310: JTF_IH_RESULTS_TL JIRV,
311: JTF_IH_ACTIVITIES JIA
358: jii.start_date_time s_date,
359: JRREV.resource_Name res_name,
360: JIRV.short_description result
361: FROM JTF_IH_INTERACTIONS JII,
362: JTF_RS_RESOURCE_EXTNS_TL JRREV,
363: JTF_IH_OUTCOMES_TL JIOV,
364: JTF_IH_RESULTS_TL JIRV
365: WHERE JII.resource_id = JRREV.resource_id
366: AND JRREV.LANGUAGE (+)= USERENV('LANG')