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.

[Home] [Help]

APPS.BIX_EMAILS_SUMMARY_PKG dependencies on JTF_IH_MEDIA_ITM_LC_SEG_TYS

Line 303: jtf_ih_media_itm_lc_seg_tys mtys

299: INTO p_curr_depth
300: FROM jtf_ih_activities actv,
301: jtf_ih_media_items imtm,
302: jtf_ih_media_item_lc_segs mseg,
303: jtf_ih_media_itm_lc_seg_tys mtys
304: WHERE actv.interaction_id = p_interaction_id
305: AND imtm.media_id = actv.media_id
306: AND mseg.media_id = imtm.media_id
307: AND mtys.milcs_type_id = mseg.milcs_type_id

Line 340: jtf_ih_media_itm_lc_seg_tys mtys

336: CONNECT BY interact_interaction_idrelates = PRIOR interact_interaction_id
337: ORDER BY creation_date DESC) inv2, jtf_ih_activities actv,
338: jtf_ih_media_items mitm,
339: jtf_ih_media_item_lc_segs mseg,
340: jtf_ih_media_itm_lc_seg_tys mtys
341: WHERE actv.interaction_id = inv2.interaction_id
342: AND mitm.media_id = actv.media_id
343: AND mitm.media_id = mseg.media_id
344: AND mseg.milcs_type_id = mtys.milcs_type_id

Line 357: jtf_ih_media_itm_lc_seg_tys mtys

353: INTO p_parent_depth
354: FROM jtf_ih_activities actv,
355: jtf_ih_media_items imtm,
356: jtf_ih_media_item_lc_segs mseg,
357: jtf_ih_media_itm_lc_seg_tys mtys
358: WHERE actv.interaction_id = p_interaction_id
359: AND imtm.media_id = actv.media_id
360: AND mseg.media_id = imtm.media_id
361: AND mtys.milcs_type_id = mseg.milcs_type_id

Line 433: jtf_ih_media_itm_lc_seg_tys mtys1

429: )
430: AND NOT EXISTS (
431: SELECT 1
432: FROM jtf_ih_media_item_lc_segs mseg1,
433: jtf_ih_media_itm_lc_seg_tys mtys1
434: WHERE mseg1.media_id = imtm.media_id
435: AND mseg1.milcs_type_id = mtys1.milcs_type_id
436: AND mtys1.milcs_code IN ( 'EMAIL_REPLY','EMAIL_AUTO_REPLY') )
437: UNION ALL

Line 444: jtf_ih_media_itm_lc_seg_tys mtys

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
445: WHERE actv.interaction_id = incr.interaction_id
446: AND imtm.media_id = actv.media_id
447: AND imtm.media_item_type = 'EMAIL'
448: AND imtm.direction = 'INBOUND'

Line 485: jtf_ih_media_itm_lc_seg_tys mtys

481: FROM jtf_ih_interaction_inters intr,
482: jtf_ih_activities actv,
483: jtf_ih_media_items imtm,
484: jtf_ih_media_item_lc_segs mseg,
485: jtf_ih_media_itm_lc_seg_tys mtys
486: WHERE actv.interaction_id = intr.interact_interaction_id
487: AND imtm.media_id = actv.media_id
488: AND mseg.media_id = imtm.media_id
489: AND mtys.milcs_type_id = mseg.milcs_type_id

Line 1227: jtf_ih_media_itm_lc_seg_tys mtyp2

1223: (
1224: SELECT MAX(mseg2.start_date_time) start_date_time
1225: FROM
1226: jtf_ih_media_item_lc_segs mseg2,
1227: jtf_ih_media_itm_lc_seg_tys mtyp2
1228: WHERE mseg.media_id = mseg2.media_id
1229: AND mseg2.milcs_type_id = mtyp2.milcs_type_id
1230: AND mtyp2.milcs_code IN ('EMAIL_FETCH','EMAIL_TRANSFER', 'EMAIL_ASSIGN_OPEN', 'EMAIL_AUTO_ROUTED', 'EMAIL_ASSIGNED')
1231: ) ) * 24 * 60 * 60) AGENT_RESP_TIME_IN_PERIOD,

Line 1256: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyp,

1252: decode(mtyp.milcs_code,'EMAIL_REROUTED_DIFF_CLASS',1,'EMAIL_REROUTED_DIFF_ACCT',1,'EMAIL_REQUEUED',1) EMAILS_REROUTED_IN_PERIOD
1253: FROM
1254: JTF_IH_MEDIA_ITEMS mitm,
1255: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,
1256: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyp,
1257: (
1258: select name, max(route_classification_id) route_classification_id
1259: from iem_route_classifications
1260: group by name

Line 2326: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyp,

2322: to_number(to_char(mseg.start_date_time, 'J')) TIME_ID
2323: FROM
2324: JTF_IH_MEDIA_ITEMS mitm,
2325: JTF_IH_MEDIA_ITEM_LC_SEGS mseg,
2326: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyp,
2327: (
2328: select name, max(route_classification_id) route_classification_id
2329: from iem_route_classifications
2330: group by name

Line 2344: jtf_ih_media_itm_lc_seg_tys mtys1

2340: SELECT
2341: 1
2342: FROM
2343: jtf_ih_media_item_lc_segs mseg1,
2344: jtf_ih_media_itm_lc_seg_tys mtys1
2345: WHERE mseg1.media_id = mitm.media_id
2346: AND mtys1.milcs_type_id = mseg1.milcs_type_id
2347: AND mtys1.milcs_code IN ( 'EMAIL_TRANSFERRED','EMAIL_ESCALATED') )
2348: )

Line 3055: JTF_IH_MEDIA_ITM_LC_SEG_TYS seg_type,

3051: 0 LEADS_CREATED_IN_PERIOD
3052: FROM
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

Line 6236: FROM jtf_ih_media_itm_lc_seg_tys

6232: G_REROUTED_CLASS,
6233: G_REROUTED_ACCT,
6234: G_REQUEUED,
6235: G_COMPOSE
6236: FROM jtf_ih_media_itm_lc_seg_tys
6237: WHERE milcs_code IN
6238: (
6239: 'EMAIL_PROCESSING'
6240: ,'EMAIL_REPLY','EMAIL_AUTO_REPLY'

Line 6286: jtf_ih_media_item_lc_segs segs, jtf_ih_media_itm_lc_seg_tys tys

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
6290: AND med.media_id = segs.media_id