eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_PROFILE dependencies on JTF_IH_INTERACTIONS

Line 234: -- FROM JTF_IH_INTERACTIONS JII,

230: -- SELECT JIOV.short_description outcome,
231: -- jii.start_date_time s_date,
232: -- JRREV.resource_Name res_name,
233: -- JIRV.short_description result
234: -- FROM JTF_IH_INTERACTIONS JII,
235: -- JTF_RS_RESOURCE_EXTNS_VL JRREV,
236: -- JTF_IH_OUTCOMES_VL JIOV,
237: -- JTF_IH_RESULTS_VL JIRV
238: -- WHERE JII.resource_id = JRREV.resource_id

Line 243: -- from jtf_ih_interactions i

239: -- AND JIOV.Outcome_id = JII.outcome_id
240: -- AND JIRV.Result_id(+) = JII.result_id
241: -- AND JII.Party_Id = p_Party_id
242: -- AND JII.start_date_time = (select Max(i.start_date_time)
243: -- from jtf_ih_interactions i
244: -- where i.party_id = jii.party_id) ;
245:
246: SELECT JIOV.short_description outcome,
247: jii.start_date_time s_date,

Line 250: FROM JTF_IH_INTERACTIONS JII,

246: SELECT JIOV.short_description outcome,
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

Line 262: from jtf_ih_interactions i

258: AND JIRV.Result_id(+) = JII.result_id
259: AND JIRV.LANGUAGE (+)= USERENV('LANG')
260: AND JII.Party_Id = p_party_id
261: AND JII.start_date_time = (select Max(i.start_date_time)
262: from jtf_ih_interactions i
263: where i.party_id = jii.party_id) ;
264: -- END BUG 5187355 scherkas 07/27/2006
265:
266:

Line 275: -- FROM JTF_IH_INTERACTIONS JII,

271: -- SELECT DISTINCT JIOV.short_description outcome,
272: -- jii.start_date_time s_date,
273: -- JRREV.resource_Name res_name,
274: -- JIRV.short_description result
275: -- FROM JTF_IH_INTERACTIONS JII,
276: -- JTF_RS_RESOURCE_EXTNS_VL JRREV,
277: -- JTF_IH_OUTCOMES_VL JIOV,
278: --START BUG 4930386 jsanju 01/10/06
279: --JTF_IH_RESULTS_VL JIRV,

Line 297: -- from jtf_ih_interactions i,

293: --END BUG 4930386 jsanju 01/10/06
294: -- AND jia.cust_account_id = cust_acct_id
295: -- AND JII.start_date_time =
296: -- (select Max(i.start_date_time)
297: -- from jtf_ih_interactions i,
298: -- jtf_ih_activities a
299: -- where a.cust_account_id = cust_acct_id
300: -- AND a.interaction_id = i.interaction_id) ;
301:

Line 306: FROM JTF_IH_INTERACTIONS JII,

302: SELECT DISTINCT JIOV.short_description outcome,
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,

Line 323: from jtf_ih_interactions i,

319: AND JIRV.LANGUAGE (+)= USERENV('LANG')
320: AND jia.cust_account_id = cust_acct_id
321: AND JII.start_date_time =
322: (select Max(i.start_date_time)
323: from jtf_ih_interactions i,
324: jtf_ih_activities a
325: where a.cust_account_id = cust_acct_id
326: AND a.interaction_id = i.interaction_id);
327: -- END BUG 5187355 scherkas 07/27/2006

Line 337: -- FROM JTF_IH_INTERACTIONS JII,

333: -- SELECT JIOV.short_description outcome,
334: -- jii.start_date_time s_date,
335: -- JRREV.resource_Name res_name,
336: -- JIRV.short_description result
337: -- FROM JTF_IH_INTERACTIONS JII,
338: -- JTF_RS_RESOURCE_EXTNS_VL JRREV,
339: -- JTF_IH_OUTCOMES_VL JIOV,
340: -- JTF_IH_RESULTS_VL JIRV
341: -- WHERE JII.resource_id = JRREV.resource_id

Line 354: -- from jtf_ih_interactions i

350: -- AND TRUNC(sysdate) BETWEEN
351: -- TRUNC(NVL(ar.effective_start_date,sysdate)) AND
352: -- TRUNC(NVL(ar.effective_end_date,sysdate)) )
353: -- AND JII.start_date_time = (select Max(i.start_date_time)
354: -- from jtf_ih_interactions i
355: -- where i.party_id = jii.party_id) ;
356:
357: SELECT JIOV.short_description outcome,
358: jii.start_date_time s_date,

Line 361: FROM JTF_IH_INTERACTIONS JII,

357: SELECT JIOV.short_description outcome,
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

Line 381: from jtf_ih_interactions i

377: AND TRUNC(sysdate) BETWEEN
378: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
379: TRUNC(NVL(ar.effective_end_date,sysdate)) )
380: AND JII.start_date_time = (select Max(i.start_date_time)
381: from jtf_ih_interactions i
382: where i.party_id = jii.party_id) ;
383: -- END BUG 5187355 scherkas 07/27/2006
384: -- END BUG 6529958 gnramasa 7th mar 2008
385: