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_ACTIVITIES

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 277: jtf_ih_activities a

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;
281:

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 288: jtf_ih_activities a

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;
292:

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 299: jtf_ih_activities a

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:
303: --End Bug 8200476 16-Jul-2009 barathsr

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 318: JTF_IH_ACTIVITIES JIA

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
319: WHERE JII.resource_id = JRRES.resource_id
320: AND jii.interaction_id = jia.interaction_id
321: AND jiovt.outcome_id = jiovb.outcome_id
322: AND JIOVB.Outcome_id(+) = JII.outcome_id

Line 329: -- /+ index(I JTF_IH_ACTIVITIES_N3)/

325: AND jiovt.language = userenv('LANG')
326: AND JII.start_date_time = date_time; --Added for Bug 8200476 16-Jul-2009 barathsr
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

Line 332: jtf_ih_activities a

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*/
336:

Line 354: -- JTF_IH_ACTIVITIES_VL JIA

350: --JTF_IH_RESULTS_VL JIRV,
351: -- JTF_IH_RESULTS_B JIRB,
352: -- JTF_IH_RESULTS_TL JIRV,
353: --END BUG 4930386 jsanju 01/10/06
354: -- JTF_IH_ACTIVITIES_VL JIA
355: -- WHERE JII.resource_id = JRREV.resource_id
356: -- AND jii.interaction_id = jia.interaction_id
357: -- AND JIOV.Outcome_id = JII.outcome_id
358:

Line 369: -- jtf_ih_activities a

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

Line 382: JTF_IH_ACTIVITIES JIA

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
383: WHERE JII.resource_id = JRREV.resource_id
384: AND JRREV.LANGUAGE (+)= USERENV('LANG')
385: AND jii.interaction_id = jia.interaction_id
386: AND JIOV.Outcome_id = JII.outcome_id

Line 395: jtf_ih_activities a

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
399: --End of comment for Bug 8200476 16-Jul-2009 barathsr