APPS.IEX_PROFILE dependencies on JTF_RS_RESOURCE_EXTNS

Line 237: -- JTF_RS_RESOURCE_EXTNS_VL JRREV,

233: -- jii.start_date_time s_date,
234: -- JRREV.resource_Name res_name,
235: -- JIRV.short_description result
236: -- FROM JTF_IH_INTERACTIONS JII,
237: -- JTF_RS_RESOURCE_EXTNS_VL JRREV,
238: -- JTF_IH_OUTCOMES_VL JIOV,
239: -- JTF_IH_RESULTS_VL JIRV
240: -- WHERE JII.resource_id = JRREV.resource_id
241: -- AND JIOV.Outcome_id = JII.outcome_id

Line 253: JTF_RS_RESOURCE_EXTNS_TL JRREV,

249: jii.start_date_time s_date,
250: JRREV.resource_Name res_name,
251: JIRV.short_description result
252: FROM JTF_IH_INTERACTIONS JII,
253: JTF_RS_RESOURCE_EXTNS_TL JRREV,
254: JTF_IH_OUTCOMES_TL JIOV,
255: JTF_IH_RESULTS_TL JIRV
256: WHERE JII.resource_id = JRREV.resource_id
257: AND JRREV.LANGUAGE (+)= USERENV('LANG')

Line 314: jtf_rs_resource_extns JRRES,

310: jii.start_date_time s_date ,
311: JRRES.source_Name res_name ,
312: JIRV.short_description result
313: FROM JTF_IH_INTERACTIONS JII ,
314: jtf_rs_resource_extns JRRES,
315: JTF_IH_OUTCOMES_tl JIOVT ,
316: jtf_ih_outcomes_b jiovb ,
317: JTF_IH_RESULTS_tl JIRV ,
318: JTF_IH_ACTIVITIES JIA

Line 347: -- JTF_RS_RESOURCE_EXTNS_VL JRREV,

343: -- jii.start_date_time s_date,
344: -- JRREV.resource_Name res_name,
345: -- JIRV.short_description result
346: -- FROM JTF_IH_INTERACTIONS JII,
347: -- JTF_RS_RESOURCE_EXTNS_VL JRREV,
348: -- JTF_IH_OUTCOMES_VL JIOV,
349: --START BUG 4930386 jsanju 01/10/06
350: --JTF_IH_RESULTS_VL JIRV,
351: -- JTF_IH_RESULTS_B JIRB,

Line 378: JTF_RS_RESOURCE_EXTNS_TL JRREV,

374: jii.start_date_time s_date,
375: JRREV.resource_Name res_name,
376: JIRV.short_description result
377: FROM JTF_IH_INTERACTIONS JII,
378: JTF_RS_RESOURCE_EXTNS_TL JRREV,
379: JTF_IH_OUTCOMES_TL JIOV,
380: JTF_IH_RESULTS_B JIRB,
381: JTF_IH_RESULTS_TL JIRV,
382: JTF_IH_ACTIVITIES JIA

Line 410: -- JTF_RS_RESOURCE_EXTNS_VL JRREV,

406: -- jii.start_date_time s_date,
407: -- JRREV.resource_Name res_name,
408: -- JIRV.short_description result
409: -- FROM JTF_IH_INTERACTIONS JII,
410: -- JTF_RS_RESOURCE_EXTNS_VL JRREV,
411: -- JTF_IH_OUTCOMES_VL JIOV,
412: -- JTF_IH_RESULTS_VL JIRV
413: -- WHERE JII.resource_id = JRREV.resource_id
414: -- AND JIOV.Outcome_id = JII.outcome_id

Line 434: JTF_RS_RESOURCE_EXTNS_TL JRREV,

430: jii.start_date_time s_date,
431: JRREV.resource_Name res_name,
432: JIRV.short_description result
433: FROM JTF_IH_INTERACTIONS JII,
434: JTF_RS_RESOURCE_EXTNS_TL JRREV,
435: JTF_IH_OUTCOMES_TL JIOV,
436: JTF_IH_RESULTS_TL JIRV
437: WHERE JII.resource_id = JRREV.resource_id
438: AND JRREV.LANGUAGE (+)= USERENV('LANG')