APPS.BIX_DM_REAL_QUEUE_SUMMARY_PKG dependencies on JTF_IH_MEDIA_ITEMS

Line 66: FROM JTF_IH_MEDIA_ITEMS ih_mitem

62: ih_mitem.classification CLASSIFICATION,
63: TRUNC(ih_mitem.start_date_time) PERIOD_START_DATE,
64: LPAD(TO_CHAR(ih_mitem.start_date_time,'HH24:'),3,'0')|| DECODE(SIGN(TO_NUMBER(TO_CHAR(ih_mitem.start_date_time,'MI'))-29),0,'00',1,'30',-1,'00') PERIOD_START_TIME,
65: TO_DATE(TO_CHAR(ih_mitem.start_date_time,'YYYY/MM/DD ')||LPAD(TO_CHAR(ih_mitem.start_date_time,'HH24:'),3,'0') || DECODE(SIGN(TO_NUMBER(TO_CHAR(ih_mitem.start_date_time,'MI'))-29),0,'00',1,'30',-1,'00'),'YYYY/MM/DD HH24:MI') PERIOD_START_DATE_TIME
66: FROM JTF_IH_MEDIA_ITEMS ih_mitem
67: WHERE ih_mitem.start_date_time BETWEEN l_start_date and l_end_date
68: AND
69: (
70: ih_mitem.media_item_type = 'TELE_INB' or

Line 88: FROM jtf_ih_media_items ih_mitem,

84: p_period_start_date DATE,
85: p_period_start_time VARCHAR2,
86: p_period_start_date_time DATE) IS
87: SELECT SUM(NVL(msegs.duration,0)) ABANDON_TIME
88: FROM jtf_ih_media_items ih_mitem,
89: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,
90: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps
91: where ih_mitem.server_group_id = p_server_group_id
92: and ih_mitem.classification = p_classification

Line 110: FROM jtf_ih_media_items ih_mitem,

106: p_period_start_date DATE,
107: p_period_start_time VARCHAR2,
108: p_period_start_date_time DATE) IS
109: SELECT count(distinct msegs.media_id) CALLS_ANSWRD_WITHIN_X_TIME
110: FROM jtf_ih_media_items ih_mitem,
111: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,
112: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps
113: where ih_mitem.server_group_id = p_server_group_id
114: and ih_mitem.classification = p_classification

Line 133: FROM jtf_ih_media_items ih_mitem,

129: p_period_start_time VARCHAR2,
130: p_period_start_date_time DATE) IS
131: SELECT SUM(NVL(msegs.duration,0)) queue_time_answered,
132: count(distinct(ih_mitem.media_id)) calls_answered
133: FROM jtf_ih_media_items ih_mitem,
134: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,
135: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps
136: where ih_mitem.server_group_id = p_server_group_id
137: and ih_mitem.classification = p_classification

Line 156: FROM jtf_ih_media_items ih_mitem,

152: p_period_start_time VARCHAR2,
153: p_period_start_date_time DATE) IS
154: SELECT SUM(NVL(msegs.duration,0)) talk_time,
155: count(distinct(msegs.media_id)) calls_handled
156: FROM jtf_ih_media_items ih_mitem,
157: JTF_IH_MEDIA_ITEM_LC_SEGS msegs,
158: JTF_IH_MEDIA_ITM_LC_SEG_TYS mtyps
159: where ih_mitem.server_group_id = p_server_group_id
160: and ih_mitem.classification = p_classification