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_REAL_TIME_RPTS_PKG dependencies on JTF_IH_MEDIA_ITEM_LC_SEGS

Line 339: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,

335:
336: SELECT SUM(DECODE(SIGN(msegs.duration - goals.SL_SECONDS_GOAL),0,1,-1,1,0))
337: into callsSrvLevel
338: FROM jtf_ih_media_items ih_mitem,
339: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,
340: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps,
341: bix_dm_goals goals
342: where (ih_mitem.server_group_id = v_site_id or (v_site_id is null or v_site_id = -999))
343: and goals.call_type_id = v_classification_id

Line 355: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,

351:
352: SELECT SUM(msegs.duration)/count(distinct(msegs.media_id))
353: INTO avgAbandonTime
354: FROM jtf_ih_media_items ih_mitem,
355: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,
356: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps
357: where ih_mitem.start_date_time BETWEEN l_date_low and l_date_high
358: and ih_mitem.media_id = msegs.media_id
359: and mtyps.milcs_type_id = msegs.milcs_type_id

Line 370: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,

366:
367: SELECT sum(msegs.duration)/count(distinct(msegs.media_id))
368: INTO avgTalkTime
369: FROM jtf_ih_media_items ih_mitem,
370: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,
371: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps,
372: JTF_RS_GROUP_MEMBERS gp
373: where ih_mitem.start_date_time BETWEEN l_date_low and l_date_high
374: and ih_mitem.media_id = msegs.media_id

Line 386: JTF_IH_MEDIA_ITEM_LC_SEGS msegs1,

382:
383: SELECT sum(msegs1.duration)/count(distinct(msegs1.media_id))
384: INTO avgSpeedToAnswer
385: FROM jtf_ih_media_items ih_mitem,
386: JTF_IH_MEDIA_ITEM_LC_SEGS msegs1,
387: JTF_IH_MEDIA_ITEM_LC_SEGS msegs2,
388: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps1,
389: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps2,
390: JTF_RS_GROUP_MEMBERS gp

Line 387: JTF_IH_MEDIA_ITEM_LC_SEGS msegs2,

383: SELECT sum(msegs1.duration)/count(distinct(msegs1.media_id))
384: INTO avgSpeedToAnswer
385: FROM jtf_ih_media_items ih_mitem,
386: JTF_IH_MEDIA_ITEM_LC_SEGS msegs1,
387: JTF_IH_MEDIA_ITEM_LC_SEGS msegs2,
388: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps1,
389: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps2,
390: JTF_RS_GROUP_MEMBERS gp
391: where ih_mitem.start_date_time BETWEEN l_date_low and l_date_high

Line 538: from jtf_ih_media_item_lc_segs J1,

534: /*
535: talk time
536: ----------*/
537: select sum(J1.duration) *3600*24 into talk_past
538: from jtf_ih_media_item_lc_segs J1,
539: jtf_ih_media_itm_lc_seg_tys J2,
540: jtf_ih_media_items J3
541: where J1.resource_id = v_agent_id
542: and J1.milcs_type_id = J2.milcs_type_id

Line 586: from jtf_ih_media_item_lc_segs J2,

582:
583:
584:
585: select sum(J1.end_date_time - J2.end_date_time)*24*3600 into wrap_past
586: from jtf_ih_media_item_lc_segs J2,
587: jtf_ih_interactions J1,
588: jtf_ih_media_itm_lc_seg_tys J3
589: where J1.resource_id = v_agent_id
590: and J1.resource_id = J2.resource_id