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.BIX_EMAILS_SUMMARY_PKG dependencies on JTF_IH_INTERACTIONS

Line 413: FROM jtf_ih_interactions incr,

409: SELECT DISTINCT interaction_id from
410: (
411: SELECT
412: incr.interaction_id
413: FROM jtf_ih_interactions incr,
414: jtf_ih_activities actv,
415: jtf_ih_media_items imtm
416: WHERE incr.start_date_time between g_collect_start_date and g_collect_end_date
417: AND actv.interaction_id = incr.interaction_id

Line 440: FROM jtf_ih_interactions incr,

436: AND mtys1.milcs_code IN ( 'EMAIL_REPLY','EMAIL_AUTO_REPLY') )
437: UNION ALL
438: SELECT
439: incr.interaction_id
440: FROM jtf_ih_interactions incr,
441: jtf_ih_activities actv,
442: jtf_ih_media_items imtm,
443: jtf_ih_media_item_lc_segs mseg,
444: jtf_ih_media_itm_lc_seg_tys mtys

Line 511: TYPE root_interaction_id_tab IS TABLE OF jtf_ih_interactions.interaction_id%TYPE;

507: AND imtm.direction = 'INBOUND')
508: )
509: ;
510:
511: TYPE root_interaction_id_tab IS TABLE OF jtf_ih_interactions.interaction_id%TYPE;
512: TYPE agent_id_tab IS TABLE OF jtf_ih_interactions.resource_id%TYPE;
513: TYPE party_id_tab IS TABLE OF jtf_ih_interactions.party_id%TYPE;
514: TYPE start_date_time_tab IS TABLE OF jtf_ih_interactions.start_date_time%TYPE;
515: TYPE source_id_tab IS TABLE OF jtf_ih_media_items.source_id%TYPE;

Line 512: TYPE agent_id_tab IS TABLE OF jtf_ih_interactions.resource_id%TYPE;

508: )
509: ;
510:
511: TYPE root_interaction_id_tab IS TABLE OF jtf_ih_interactions.interaction_id%TYPE;
512: TYPE agent_id_tab IS TABLE OF jtf_ih_interactions.resource_id%TYPE;
513: TYPE party_id_tab IS TABLE OF jtf_ih_interactions.party_id%TYPE;
514: TYPE start_date_time_tab IS TABLE OF jtf_ih_interactions.start_date_time%TYPE;
515: TYPE source_id_tab IS TABLE OF jtf_ih_media_items.source_id%TYPE;
516: TYPE route_classification_id_tab IS TABLE OF iem_route_classifications.route_classification_id%TYPE;

Line 513: TYPE party_id_tab IS TABLE OF jtf_ih_interactions.party_id%TYPE;

509: ;
510:
511: TYPE root_interaction_id_tab IS TABLE OF jtf_ih_interactions.interaction_id%TYPE;
512: TYPE agent_id_tab IS TABLE OF jtf_ih_interactions.resource_id%TYPE;
513: TYPE party_id_tab IS TABLE OF jtf_ih_interactions.party_id%TYPE;
514: TYPE start_date_time_tab IS TABLE OF jtf_ih_interactions.start_date_time%TYPE;
515: TYPE source_id_tab IS TABLE OF jtf_ih_media_items.source_id%TYPE;
516: TYPE route_classification_id_tab IS TABLE OF iem_route_classifications.route_classification_id%TYPE;
517: TYPE one_done_rsln_tab IS TABLE OF bix_email_details_f.one_rsln_in_period%TYPE;

Line 514: TYPE start_date_time_tab IS TABLE OF jtf_ih_interactions.start_date_time%TYPE;

510:
511: TYPE root_interaction_id_tab IS TABLE OF jtf_ih_interactions.interaction_id%TYPE;
512: TYPE agent_id_tab IS TABLE OF jtf_ih_interactions.resource_id%TYPE;
513: TYPE party_id_tab IS TABLE OF jtf_ih_interactions.party_id%TYPE;
514: TYPE start_date_time_tab IS TABLE OF jtf_ih_interactions.start_date_time%TYPE;
515: TYPE source_id_tab IS TABLE OF jtf_ih_media_items.source_id%TYPE;
516: TYPE route_classification_id_tab IS TABLE OF iem_route_classifications.route_classification_id%TYPE;
517: TYPE one_done_rsln_tab IS TABLE OF bix_email_details_f.one_rsln_in_period%TYPE;
518: TYPE two_done_rsln_tab IS TABLE OF bix_email_details_f.two_rsln_in_period%TYPE;

Line 632: jtf_ih_interactions intr,

628: l_start_date_time(i),
629: l_email_account_id(i),
630: l_classification_id(i)
631: FROM
632: jtf_ih_interactions intr,
633: jtf_ih_activities actv,
634: jtf_ih_media_items mitm,
635: --
636: --Changes for R12

Line 1213: jtf_ih_interactions intr

1209: nvl(( SELECT
1210: distinct first_value(intr.party_id) over(order by actv.interaction_id desc) party_id
1211: FROM
1212: jtf_ih_activities actv,
1213: jtf_ih_interactions intr
1214: WHERE
1215: mitm.media_id = actv.media_id
1216: AND actv.interaction_id = intr.interaction_id
1217: ), -1) PARTY_ID,

Line 1582: jtf_ih_interactions intr

1578: nvl(( SELECT
1579: distinct first_value(intr.party_id) over(order by actv.interaction_id desc) party_id
1580: FROM
1581: jtf_ih_activities actv,
1582: jtf_ih_interactions intr
1583: WHERE
1584: mitm.media_id = actv.media_id
1585: AND actv.interaction_id = intr.interaction_id
1586: ), -1) PARTY_ID,

Line 1943: JTF_IH_INTERACTIONS intr,

1939: to_number(to_char(actv.start_date_time, 'J')) TIME_ID,
1940: actv.action_id ACTION_ID
1941: FROM
1942: JTF_IH_ACTIVITIES actv,
1943: JTF_IH_INTERACTIONS intr,
1944: JTF_IH_MEDIA_ITEMS mitm,
1945: (select /*+ index(actv jtf_ih_activities_n11) use_nl(actv actv1 mitm) */
1946: actv.interaction_id interaction_id,
1947: max(mitm.classification) classification

Line 2316: jtf_ih_interactions intr

2312: nvl(( SELECT
2313: distinct first_value(intr.party_id) over(order by actv.interaction_id desc) party_id
2314: FROM
2315: jtf_ih_activities actv,
2316: jtf_ih_interactions intr
2317: WHERE
2318: mitm.media_id = actv.media_id
2319: AND actv.interaction_id = intr.interaction_id
2320: ), -1) PARTY_ID,

Line 2703: JTF_IH_INTERACTIONS intr,

2699: intr.interaction_id INTERACTION_ID
2700: FROM
2701: JTF_IH_MEDIA_ITEMS mitm,
2702: JTF_IH_ACTIVITIES actv,
2703: JTF_IH_INTERACTIONS intr,
2704: (
2705: select name, max(route_classification_id) route_classification_id
2706: from iem_route_classifications
2707: group by name

Line 3057: JTF_IH_INTERACTIONS intr,

3053: JTF_IH_MEDIA_ITEMS mitm,
3054: JTF_IH_MEDIA_ITEM_LC_SEGS segs,
3055: JTF_IH_MEDIA_ITM_LC_SEG_TYS seg_type,
3056: JTF_IH_ACTIVITIES actv,
3057: JTF_IH_INTERACTIONS intr,
3058: --
3059: --Changes for R12
3060: --
3061: (

Line 3457: JTF_IH_INTERACTIONS int,

3453: FROM
3454: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,
3455: JTF_IH_MEDIA_ITEMS mitm,
3456: JTF_IH_ACTIVITIES act,
3457: JTF_IH_INTERACTIONS int,
3458: (
3459: select name, max(route_classification_id) route_classification_id
3460: from iem_route_classifications
3461: group by name

Line 3513: jtf_ih_interactions intr

3509: nvl(( SELECT
3510: distinct first_value(intr.party_id) over(order by actv.interaction_id desc) party_id
3511: FROM
3512: jtf_ih_activities actv,
3513: jtf_ih_interactions intr
3514: WHERE
3515: mitm.media_id = actv.media_id
3516: AND actv.interaction_id = intr.interaction_id
3517: ), -1) PARTY_ID,

Line 3944: JTF_IH_INTERACTIONS int,

3940: FROM
3941: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,
3942: JTF_IH_MEDIA_ITEMS mitm,
3943: JTF_IH_ACTIVITIES act,
3944: JTF_IH_INTERACTIONS int,
3945: (
3946: select name, max(route_classification_id) route_classification_id
3947: from iem_route_classifications
3948: group by name

Line 4010: jtf_ih_interactions intr

4006: over(partition by actv.media_id order by actv.interaction_id desc) party_id
4007: FROM
4008: jtf_ih_media_item_lc_segs segs,
4009: jtf_ih_activities actv,
4010: jtf_ih_interactions intr
4011: WHERE segs.media_id = actv.media_id
4012: AND actv.interaction_id = intr.interaction_id
4013: AND segs.START_DATE_TIME BETWEEN g_collect_start_date AND g_collect_end_date
4014: AND segs.milcs_type_id IN (

Line 6285: FROM jtf_ih_media_items med, jtf_ih_interactions int, jtf_ih_activities act,

6281: --
6282:
6283: SELECT min(med.start_date_time)
6284: INTO l_min_media_date
6285: FROM jtf_ih_media_items med, jtf_ih_interactions int, jtf_ih_activities act,
6286: jtf_ih_media_item_lc_segs segs, jtf_ih_media_itm_lc_seg_tys tys
6287: WHERE med.media_item_type = 'EMAIL'
6288: AND int.interaction_id = act.interaction_id
6289: AND med.media_id = act.media_id

Line 6400: FROM JTF_IH_INTERACTIONS INT

6396: DELETE BIX_INTERACTIONS_TEMP BIXTEMP
6397: WHERE EXISTS
6398: (
6399: SELECT INTERACTION_ID
6400: FROM JTF_IH_INTERACTIONS INT
6401: WHERE START_DATE_TIME >= trunc(l_min_media_date)
6402: AND INT.INTERACTION_ID = BIXTEMP.INTERACTION_ID
6403: );
6404: