APPS.BIX_REAL_TIME_RPTS_PKG dependencies on JTF_IH_MEDIA_ITEMS

Line 323: FROM JTF_IH_MEDIA_ITEMS ih_mitem

319:
320: SELECT sum(DECODE(UPPER(ih_mitem.direction),'INBOUND',1,0)) ,
321: sum(DECODE(UPPER(ih_mitem.direction),'INBOUND',DECODE(UPPER(ih_mitem.media_abandon_flag),'Y',1,0),0))
322: into callsOffered, abandonCalls
323: FROM JTF_IH_MEDIA_ITEMS ih_mitem
324: WHERE ih_mitem.start_date_time BETWEEN l_date_low and l_date_high
325: AND
326: (
327: ih_mitem.media_item_type = 'TELE_INB' or

Line 338: FROM jtf_ih_media_items ih_mitem,

334: AND (ih_mitem.server_group_id = v_site_id or (v_site_id=-999 or v_site_id is null));
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))

Line 354: FROM jtf_ih_media_items ih_mitem,

350: and goals.end_date_active is null;
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

Line 369: FROM jtf_ih_media_items ih_mitem,

365: and (ih_mitem.server_group_id = v_site_id or (v_site_id is null or v_site_id = -999));
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

Line 385: FROM jtf_ih_media_items ih_mitem,

381: and (gp.group_id = v_group_id or (v_group_id = -999 or v_group_id is null));
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,

Line 540: jtf_ih_media_items J3

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
543: and J2.milcs_code = 'WITH_AGENT'
544: and J1.start_date_time between l_date_low and l_date_high