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_ACTIVITIES

Line 173: jtf_ih_activities actv,

169: max(nvl(irc.route_classification_id, -1)) route_classification_id,
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: --

Line 193: FROM jtf_ih_activities actv,

189: /* This returns the parent level interactions and hardcoded depth as 1 for email replies-auto replies */
190: SELECT
191: actv.interaction_id interaction_id,
192: 1 depth
193: FROM jtf_ih_activities actv,
194: /* jtf_ih_media_items imtm,*/
195: jtf_ih_media_item_lc_segs mseg,
196: jtf_ih_media_itm_lc_seg_tys mtys
197: WHERE actv.media_id = mseg.media_id

Line 223: jtf_ih_activities actv ,

219: FROM
220: jtf_ih_media_itm_lc_seg_tys mtys,
221: jtf_ih_media_item_lc_segs mseg,
222: jtf_ih_media_items mitm,
223: jtf_ih_activities actv ,
224: (
225: SELECT to_number(decode(instr(sys_connect_by_path(intr3.interact_interaction_idrelates, ':'), ':', 2), 0,
226: substr(sys_connect_by_path(intr3.interact_interaction_idrelates, ':'), 2),
227: substr(sys_connect_by_path(intr3.interact_interaction_idrelates, ':'), 2,

Line 734: jtf_ih_activities actv,

730: SELECT /*+ use_hash(actv) use_hash(intr) PARALLEL(actv) PARALLEL(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

Line 812: jtf_ih_activities actv,

808: SELECT /*+ use_hash(actv) use_hash(intr) PARALLEL(actv) PARALLEL(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

Line 880: JTF_IH_ACTIVITIES actv,

876: 0 emails_orr_count_in_period,
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,

Line 887: jtf_ih_activities actv,

883: (select
884: actv.interaction_id interaction_id,
885: max(mitm.classification) classification
886: from
887: jtf_ih_activities actv,
888: jtf_ih_activities actv1,
889: jtf_ih_media_items mitm
890: where actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
891: and actv.interaction_id = actv1.interaction_id

Line 888: jtf_ih_activities actv1,

884: actv.interaction_id interaction_id,
885: max(mitm.classification) classification
886: from
887: jtf_ih_activities actv,
888: jtf_ih_activities actv1,
889: jtf_ih_media_items mitm
890: where actv.start_date_time BETWEEN g_collect_start_date AND g_collect_end_date
891: and actv.interaction_id = actv1.interaction_id
892: and actv1.media_id = mitm.media_id

Line 968: jtf_ih_activities actv,

964: SELECT /*+ use_hash(actv) use_hash(intr) PARALLEL(actv) PARALLEL(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

Line 1054: JTF_IH_ACTIVITIES actv,

1050: 0 EMAILS_REROUTED_IN_PERIOD,
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: --

Line 1127: JTF_IH_ACTIVITIES actv,

1123: FROM
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: --

Line 1588: --jtf_ih_activities actv,

1584: --SELECT /*+ use_hash(actv) use_hash(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

Line 1598: jtf_ih_activities actv,

1594: distinct actv.media_id media_id,
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

Line 1675: --jtf_ih_activities actv,

1671: --SELECT /*+ use_hash(actv) use_hash(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

Line 1685: jtf_ih_activities actv,

1681: distinct actv.media_id media_id,
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,

Line 2192: --jtf_ih_activities actv,

2188: --SELECT /*+ use_hash(actv) use_hash(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

Line 2202: jtf_ih_activities actv,

2198: distinct actv.media_id media_id,
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

Line 2271: --jtf_ih_activities actv,

2267: --SELECT /*+ use_hash(actv) use_hash(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

Line 2281: jtf_ih_activities actv,

2277: distinct actv.media_id media_id,
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,