APPS.BIX_QUEUE_DETAIL_REPORT dependencies on BIX_DM_REAL_QUEUE_SUM

Line 25: from cct_classifications c, bix_dm_real_queue_sum b

21:
22: /* get all valid classifications for all calls */
23: cursor get_classifications is
24: select distinct c.classification_id, c.classification
25: from cct_classifications c, bix_dm_real_queue_sum b
26: where ((c.classification_id = p_classification_id) or (p_classification_id is null or p_classification_id = -999))
27: and b.classification_id = c.classification_id;
28: /*
29: and ((c.server_group_id = p_site_id) or (p_site_id is null or p_site_id = -1));

Line 42: from bix_dm_real_queue_sum

38:
39: /* find how many calls have no classification */
40: select count(*)
41: into l_unclassified_count
42: from bix_dm_real_queue_sum
43: where (classification_id is null or
44: classification_id not in
45: (select distinct classification_id
46: from cct_classifications));

Line 80: from bix_dm_real_queue_sum

76: , decode(SUM(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0, SUM(CALLS_ANSWRD_WITHIN_X_TIME))
77: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
78: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
79: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
80: from bix_dm_real_queue_sum
81: where classification_id = v_classification_id
82: and session_id = g_session_id
83: and period_start_date_time between p_start_period and p_end_period
84: and ((server_group_id = p_site_id) or (p_site_id is null or p_site_id = -999)));

Line 117: from bix_dm_real_queue_sum

113: , decode(sum(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0,sum(CALLS_ANSWRD_WITHIN_X_TIME))
114: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
115: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
116: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
117: from bix_dm_real_queue_sum
118: where classification_id = v_classification_id
119: and session_id = g_session_id
120: and classification_id = g_classification_id
121: and period_start_date_time between p_start_period and p_end_period

Line 172: from bix_dm_real_queue_sum

168: , decode(SUM(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0, SUM(CALLS_ANSWRD_WITHIN_X_TIME))
169: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
170: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
171: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
172: from bix_dm_real_queue_sum
173: where ( classification_id is null or classification_id not in
174: (select distinct classification_id
175: from cct_classifications))
176: and period_start_date_time between p_start_period and p_end_period

Line 212: from bix_dm_real_queue_sum

208: , decode(sum(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0,sum(CALLS_ANSWRD_WITHIN_X_TIME))
209: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
210: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
211: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
212: from bix_dm_real_queue_sum
213: where (classification_id is null or classification_id not in
214: (select distinct classification_id
215: from cct_classifications))
216: and session_id = g_session_id

Line 233: delete from bix_dm_real_queue_sum

229: and col2 = g_null_desc;
230: end if; /* detailed rows for unclassified calls */
231: end if; /* data for unclassified calls */
232:
233: delete from bix_dm_real_queue_sum
234: where session_id = g_session_id;
235:
236:
237: END insert_temp_table;

Line 280: BIX_DM_REAL_QUEUE_SUMMARY_PKG.get_calls(g_session_id);

276:
277:
278: g_drilldown := 0; /* drilldown default to yes */
279: g_session_id := bix_util_pkg.get_icx_session_id; /* get current session id */
280: BIX_DM_REAL_QUEUE_SUMMARY_PKG.get_calls(g_session_id);
281: /* get the classification id for the clicked row or data */
282: v_parent := jtfb_dcf.get_parameter_value(p_context, 'pContext');
283: /* to make the report listing link work */
284: if (v_parent = 'BIX_QUEUE_DETAIL_REPORT') then

Line 338: from bix_dm_real_queue_sum;

334: l_date DATE;
335: BEGIN
336: select max(period_start_date_time)
337: into l_date
338: from bix_dm_real_queue_sum;
339:
340: l_message := fnd_message.get_string('BIX', 'BIX_DM_REFRESH_MSG') ;
341: l_label := l_message || ' ' ||to_char(l_date, 'DD-MON-YYYY HH12:MI:SS AM');
342: return l_label;