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 236: -- FROM JTF_IH_INTERACTIONS JII,

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

Line 245: -- from jtf_ih_interactions i

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

Line 252: FROM JTF_IH_INTERACTIONS JII,

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

Line 264: from jtf_ih_interactions i

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

Line 274: /+ leading(a) index(A JTF_IH_ACTIVITIES_N3) index(I JTF_IH_INTERACTIONS_CUS01)/

270:
271: cursor cust_int_get_dt30_cur(cust_acct_id number)
272: is
273: SELECT
274: /*+ leading(a) index(A JTF_IH_ACTIVITIES_N3) index(I JTF_IH_INTERACTIONS_CUS01)*/
275: MAX(i.start_date_time)
276: FROM jtf_ih_interactions i,
277: jtf_ih_activities a
278: WHERE a.cust_account_id = cust_acct_id

Line 276: FROM jtf_ih_interactions i,

272: is
273: SELECT
274: /*+ leading(a) index(A JTF_IH_ACTIVITIES_N3) index(I JTF_IH_INTERACTIONS_CUS01)*/
275: MAX(i.start_date_time)
276: FROM jtf_ih_interactions i,
277: jtf_ih_activities a
278: WHERE a.cust_account_id = cust_acct_id
279: AND a.interaction_id = i.interaction_id
280: and i.start_date_time between (trunc(sysdate)-30) and sysdate;

Line 285: /+ leading(a) index(A JTF_IH_ACTIVITIES_N3) index(I JTF_IH_INTERACTIONS_CUS01)/

281:
282: cursor cust_int_get_dt365_cur(cust_acct_id number)
283: is
284: SELECT
285: /*+ leading(a) index(A JTF_IH_ACTIVITIES_N3) index(I JTF_IH_INTERACTIONS_CUS01)*/
286: MAX(i.start_date_time)
287: FROM jtf_ih_interactions i,
288: jtf_ih_activities a
289: WHERE a.cust_account_id = cust_acct_id

Line 287: FROM jtf_ih_interactions i,

283: is
284: SELECT
285: /*+ leading(a) index(A JTF_IH_ACTIVITIES_N3) index(I JTF_IH_INTERACTIONS_CUS01)*/
286: MAX(i.start_date_time)
287: FROM jtf_ih_interactions i,
288: jtf_ih_activities a
289: WHERE a.cust_account_id = cust_acct_id
290: AND a.interaction_id = i.interaction_id
291: and i.start_date_time between (trunc(sysdate)-365) and sysdate;

Line 296: /+ leading(a) index(A JTF_IH_ACTIVITIES_N3) index(I JTF_IH_INTERACTIONS_CUS01)/

292:
293: cursor cust_int_get_dt_cur(cust_acct_id number)
294: is
295: SELECT
296: /*+ leading(a) index(A JTF_IH_ACTIVITIES_N3) index(I JTF_IH_INTERACTIONS_CUS01)*/
297: MAX(i.start_date_time)
298: FROM jtf_ih_interactions i,
299: jtf_ih_activities a
300: WHERE a.cust_account_id = cust_acct_id

Line 298: FROM jtf_ih_interactions i,

294: is
295: SELECT
296: /*+ leading(a) index(A JTF_IH_ACTIVITIES_N3) index(I JTF_IH_INTERACTIONS_CUS01)*/
297: MAX(i.start_date_time)
298: FROM jtf_ih_interactions i,
299: jtf_ih_activities a
300: WHERE a.cust_account_id = cust_acct_id
301: AND a.interaction_id = i.interaction_id;
302:

Line 308: /+ index (jia JTF_IH_ACTIVITIES_N4) index(JII JTF_IH_INTERACTIONS_N6)/ --Added for Bug 8200476 16-Jul-2009 barathsr

304:
305: CURSOR CUST_INT_CUR(cust_acct_id Number,date_time date) --Added for Bug 8200476 16-Jul-2009 barathsr
306: IS
307: SELECT
308: /*+ index (jia JTF_IH_ACTIVITIES_N4) index(JII JTF_IH_INTERACTIONS_N6)*/ --Added for Bug 8200476 16-Jul-2009 barathsr
309: DISTINCT JIOVT.short_description outcome,
310: jii.start_date_time s_date ,
311: JRRES.source_Name res_name ,
312: JIRV.short_description result

Line 313: FROM JTF_IH_INTERACTIONS JII ,

309: DISTINCT JIOVT.short_description outcome,
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 ,

Line 331: FROM jtf_ih_interactions i,

327: --Start of comment for Bug 8200476 16-Jul-2009 barathsr
328: -- (SELECT
329: -- /*+ index(I JTF_IH_ACTIVITIES_N3)*/
330: /* MAX(i.start_date_time)
331: FROM jtf_ih_interactions i,
332: jtf_ih_activities a
333: WHERE a.cust_account_id = cust_acct_id
334: AND a.interaction_id = i.interaction_id);
335: --End bug 7572544 16-Jan-2009 barathsr*/

Line 346: -- FROM JTF_IH_INTERACTIONS JII,

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

Line 368: -- from jtf_ih_interactions i,

364: --END BUG 4930386 jsanju 01/10/06
365: -- AND jia.cust_account_id = cust_acct_id
366: -- AND JII.start_date_time =
367: -- (select Max(i.start_date_time)
368: -- from jtf_ih_interactions i,
369: -- jtf_ih_activities a
370: -- where a.cust_account_id = cust_acct_id
371: -- AND a.interaction_id = i.interaction_id) ;
372:

Line 377: FROM JTF_IH_INTERACTIONS JII,

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

Line 394: from jtf_ih_interactions i,

390: AND JIRV.LANGUAGE (+)= USERENV('LANG')
391: AND jia.cust_account_id = cust_acct_id
392: AND JII.start_date_time =
393: (select Max(i.start_date_time)
394: from jtf_ih_interactions i,
395: jtf_ih_activities a
396: where a.cust_account_id = cust_acct_id
397: AND a.interaction_id = i.interaction_id);*/
398: -- END BUG 5187355 scherkas 07/27/2006

Line 409: -- FROM JTF_IH_INTERACTIONS JII,

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

Line 426: -- from jtf_ih_interactions i

422: -- AND TRUNC(sysdate) BETWEEN
423: -- TRUNC(NVL(ar.effective_start_date,sysdate)) AND
424: -- TRUNC(NVL(ar.effective_end_date,sysdate)) )
425: -- AND JII.start_date_time = (select Max(i.start_date_time)
426: -- from jtf_ih_interactions i
427: -- where i.party_id = jii.party_id) ;
428:
429: SELECT JIOV.short_description outcome,
430: jii.start_date_time s_date,

Line 433: FROM JTF_IH_INTERACTIONS JII,

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

Line 453: from jtf_ih_interactions i

449: AND TRUNC(sysdate) BETWEEN
450: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
451: TRUNC(NVL(ar.effective_end_date,sysdate)) )
452: AND JII.start_date_time = (select Max(i.start_date_time)
453: from jtf_ih_interactions i
454: where i.party_id = jii.party_id) ;
455: -- END BUG 5187355 scherkas 07/27/2006
456: -- END BUG 6529958 gnramasa 7th mar 2008
457: