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_LOAD_PKG dependencies on JTF_IH_INTERACTIONS

Line 174: jtf_ih_interactions intr,

170: max(nvl(iview.depth, 0)) depth
171: FROM
172: jtf_ih_media_items mitm,
173: jtf_ih_activities actv,
174: jtf_ih_interactions intr,
175: --
176: --Changes for R12
177: --
178: (

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

274:
275:
276:
277:
278: TYPE root_interaction_id_tab IS TABLE OF jtf_ih_interactions.interaction_id%TYPE;
279: TYPE agent_id_tab IS TABLE OF jtf_ih_interactions.resource_id%TYPE;
280: TYPE party_id_tab IS TABLE OF jtf_ih_interactions.party_id%TYPE;
281: TYPE start_date_time_tab IS TABLE OF jtf_ih_interactions.start_date_time%TYPE;
282: TYPE source_id_tab IS TABLE OF jtf_ih_media_items.source_id%TYPE;

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

275:
276:
277:
278: TYPE root_interaction_id_tab IS TABLE OF jtf_ih_interactions.interaction_id%TYPE;
279: TYPE agent_id_tab IS TABLE OF jtf_ih_interactions.resource_id%TYPE;
280: TYPE party_id_tab IS TABLE OF jtf_ih_interactions.party_id%TYPE;
281: TYPE start_date_time_tab IS TABLE OF jtf_ih_interactions.start_date_time%TYPE;
282: TYPE source_id_tab IS TABLE OF jtf_ih_media_items.source_id%TYPE;
283: TYPE route_classification_id_tab IS TABLE OF iem_route_classifications.route_classification_id%TYPE;

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

276:
277:
278: TYPE root_interaction_id_tab IS TABLE OF jtf_ih_interactions.interaction_id%TYPE;
279: TYPE agent_id_tab IS TABLE OF jtf_ih_interactions.resource_id%TYPE;
280: TYPE party_id_tab IS TABLE OF jtf_ih_interactions.party_id%TYPE;
281: TYPE start_date_time_tab IS TABLE OF jtf_ih_interactions.start_date_time%TYPE;
282: TYPE source_id_tab IS TABLE OF jtf_ih_media_items.source_id%TYPE;
283: TYPE route_classification_id_tab IS TABLE OF iem_route_classifications.route_classification_id%TYPE;
284: TYPE one_done_rsln_tab IS TABLE OF bix_email_details_f.one_rsln_in_period%TYPE;

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

277:
278: TYPE root_interaction_id_tab IS TABLE OF jtf_ih_interactions.interaction_id%TYPE;
279: TYPE agent_id_tab IS TABLE OF jtf_ih_interactions.resource_id%TYPE;
280: TYPE party_id_tab IS TABLE OF jtf_ih_interactions.party_id%TYPE;
281: TYPE start_date_time_tab IS TABLE OF jtf_ih_interactions.start_date_time%TYPE;
282: TYPE source_id_tab IS TABLE OF jtf_ih_media_items.source_id%TYPE;
283: TYPE route_classification_id_tab IS TABLE OF iem_route_classifications.route_classification_id%TYPE;
284: TYPE one_done_rsln_tab IS TABLE OF bix_email_details_f.one_rsln_in_period%TYPE;
285: TYPE two_done_rsln_tab IS TABLE OF bix_email_details_f.two_rsln_in_period%TYPE;

Line 735: jtf_ih_interactions intr

731: actv.media_id media_id,
732: min(intr.party_id) party_id
733: FROM
734: jtf_ih_activities actv,
735: jtf_ih_interactions intr
736: WHERE actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
737: AND actv.interaction_id = intr.interaction_id
738: GROUP BY actv.media_id
739: ) inv1,

Line 813: jtf_ih_interactions intr

809: actv.media_id media_id,
810: min(intr.party_id) party_id
811: FROM
812: jtf_ih_activities actv,
813: jtf_ih_interactions intr
814: WHERE actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
815: AND actv.interaction_id = intr.interaction_id
816: GROUP BY actv.media_id
817: ) inv1,

Line 881: JTF_IH_INTERACTIONS intr,

877: 0 EMAILS_REROUTED_IN_PERIOD,
878: SUM(DECODE(actv.action_id,71,1)) LEADS_CREATED_IN_PERIOD
879: FROM
880: JTF_IH_ACTIVITIES actv,
881: JTF_IH_INTERACTIONS intr,
882: JTF_IH_MEDIA_ITEMS mitm,
883: (select
884: actv.interaction_id interaction_id,
885: max(mitm.classification) classification

Line 969: jtf_ih_interactions intr

965: actv.media_id media_id,
966: min(intr.party_id) party_id
967: FROM
968: jtf_ih_activities actv,
969: jtf_ih_interactions intr
970: WHERE actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
971: AND actv.interaction_id = intr.interaction_id
972: GROUP BY actv.media_id
973: ) inv2,

Line 1055: JTF_IH_INTERACTIONS intr,

1051: 0 LEADS_CREATED_IN_PERIOD
1052: FROM
1053: JTF_IH_MEDIA_ITEMS mitm,
1054: JTF_IH_ACTIVITIES actv,
1055: JTF_IH_INTERACTIONS intr,
1056: --
1057: --Changes for R12
1058: --
1059: (

Line 1128: JTF_IH_INTERACTIONS intr,

1124: JTF_IH_MEDIA_ITEMS mitm,
1125: JTF_IH_MEDIA_ITEM_LC_SEGS segs,
1126: JTF_IH_MEDIA_ITM_LC_SEG_TYS seg_type,
1127: JTF_IH_ACTIVITIES actv,
1128: JTF_IH_INTERACTIONS intr,
1129: --
1130: --Changes for R12
1131: --
1132: (

Line 1589: --jtf_ih_interactions intr

1585: --actv.media_id media_id,
1586: --min(intr.party_id) party_id
1587: --FROM
1588: --jtf_ih_activities actv,
1589: --jtf_ih_interactions intr
1590: --WHERE actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
1591: --AND actv.interaction_id = intr.interaction_id
1592: --GROUP BY actv.media_id
1593: SELECT /*+ use_hash(actv) use_hash(intr) */

Line 1599: jtf_ih_interactions intr

1595: first_value(intr.party_id)
1596: over(partition by actv.media_id order by actv.interaction_id desc) party_id
1597: FROM
1598: jtf_ih_activities actv,
1599: jtf_ih_interactions intr
1600: WHERE actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
1601: AND actv.interaction_id = intr.interaction_id
1602: ) inv2
1603: WHERE mitm.MEDIA_ITEM_TYPE = 'EMAIL'

Line 1676: --jtf_ih_interactions intr

1672: --actv.media_id media_id,
1673: --min(intr.party_id) party_id
1674: --FROM
1675: --jtf_ih_activities actv,
1676: --jtf_ih_interactions intr
1677: --WHERE actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
1678: --AND actv.interaction_id = intr.interaction_id
1679: --GROUP BY actv.media_id
1680: SELECT /*+ use_hash(actv) use_hash(intr) */

Line 1686: jtf_ih_interactions intr

1682: first_value(intr.party_id)
1683: over(partition by actv.media_id order by actv.interaction_id desc) party_id
1684: FROM
1685: jtf_ih_activities actv,
1686: jtf_ih_interactions intr
1687: WHERE actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
1688: AND actv.interaction_id = intr.interaction_id
1689: ) inv1,
1690: JTF_IH_MEDIA_ITEM_LC_SEGS mseg2,

Line 2193: --jtf_ih_interactions intr

2189: --actv.media_id media_id,
2190: --min(intr.party_id) party_id
2191: --FROM
2192: --jtf_ih_activities actv,
2193: --jtf_ih_interactions intr
2194: --WHERE actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
2195: --AND actv.interaction_id = intr.interaction_id
2196: --GROUP BY actv.media_id
2197: SELECT /*+ use_hash(actv) use_hash(intr) */

Line 2203: jtf_ih_interactions intr

2199: first_value(intr.party_id)
2200: over(partition by actv.media_id order by actv.interaction_id desc) party_id
2201: FROM
2202: jtf_ih_activities actv,
2203: jtf_ih_interactions intr
2204: WHERE actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
2205: AND actv.interaction_id = intr.interaction_id
2206: ) inv2
2207: WHERE mitm.media_item_type = 'EMAIL'

Line 2272: --jtf_ih_interactions intr

2268: --actv.media_id media_id,
2269: --min(intr.party_id) party_id
2270: --FROM
2271: --jtf_ih_activities actv,
2272: --jtf_ih_interactions intr
2273: --WHERE actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
2274: --AND actv.interaction_id = intr.interaction_id
2275: --GROUP BY actv.media_id
2276: SELECT /*+ use_hash(actv) use_hash(intr) */

Line 2282: jtf_ih_interactions intr

2278: first_value(intr.party_id)
2279: over(partition by actv.media_id order by actv.interaction_id desc) party_id
2280: FROM
2281: jtf_ih_activities actv,
2282: jtf_ih_interactions intr
2283: WHERE actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
2284: AND actv.interaction_id = intr.interaction_id
2285: ) inv1,
2286: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,