APPS.BIX_ALERT dependencies on BIX_SUM_GRP_CLS

Line 126: from bix_sum_grp_cls

122: CURSOR cr_actual IS
123: Select round(sum(abandoned_count)/sum(number_of_interactions)*100, 2) abandoned_level,
124: to_char(hour,'MON-YYYY') month,
125: interaction_center_id center_id
126: from bix_sum_grp_cls
127: group by to_char(hour,'MON-YYYY'), interaction_center_id;
128: CURSOR cr_center(p_center_id NUMBER) IS
129: SELECT call_center_name center_name
130: FROM bix_call_center_v

Line 408: from bix_sum_grp_cls

404: CURSOR cr_actual IS
405: Select round(sum(interactions_answered_live)/sum(number_of_interactions)*100, 2) service_level,
406: to_char(hour,'MON-YYYY') month,
407: interaction_center_id center_id
408: from bix_sum_grp_cls
409: group by to_char(hour,'MON-YYYY'), interaction_center_id;
410:
411: CURSOR cr_center(p_center_id NUMBER) IS
412: SELECT call_center_name center_name

Line 666: from bix_sum_grp_cls

662: CURSOR cr_actual IS
663: Select round(sum(speed_to_answer)/sum(number_of_interactions), 2) avg_speed_to_answer,
664: to_char(hour,'MON-YYYY') month,
665: interaction_center_id center_id
666: from bix_sum_grp_cls
667: group by to_char(hour,'MON-YYYY'), interaction_center_id;
668: CURSOR cr_center(p_center_id NUMBER) IS
669: SELECT call_center_name center_name
670: FROM bix_call_center_v

Line 970: from bix_sum_grp_cls

966: CURSOR cr_actual IS
967: Select round(sum(talk_time)/sum(talk_time + idle_time)*100, 2) occupancy_rate,
968: to_char(hour,'MON-YYYY') month,
969: interaction_center_id center_id
970: from bix_sum_grp_cls
971: group by to_char(hour,'MON-YYYY'), interaction_center_id;
972: CURSOR cr_center(p_center_id NUMBER) IS
973: SELECT call_center_name center_name
974: FROM bix_call_center_v

Line 1278: from bix_sum_grp_cls

1274: CURSOR cr_actual IS
1275: Select round(sum(talk_time)/sum(interactions_answered_live)/60,2) avg_talk_time,
1276: to_char(hour,'MON-YYYY') month,
1277: interaction_center_id center_id
1278: from bix_sum_grp_cls
1279: group by to_char(hour,'MON-YYYY'), interaction_center_id;
1280: CURSOR cr_center(p_center_id NUMBER) IS
1281: SELECT call_center_name center_name
1282: FROM bix_call_center_v

Line 1535: from bix_sum_grp_cls

1531: CURSOR cr_actual IS
1532: Select round(sum(wait_time_to_abandon)/sum(number_of_interactions), 2) avg_wait_time_to_abandon,
1533: to_char(hour,'MON-YYYY') month,
1534: interaction_center_id center_id
1535: from bix_sum_grp_cls
1536: group by to_char(hour,'MON-YYYY'), interaction_center_id;
1537: CURSOR cr_center(p_center_id NUMBER) IS
1538: SELECT call_center_name center_name
1539: FROM bix_call_center_v

Line 1798: from bix_sum_grp_cls

1794: CURSOR cr_actual IS
1795: Select round(sum(talk_time)/sum(talk_time + idle_time) * 100, 2) utilization_rate,
1796: to_char(hour,'MON-YYYY') month,
1797: interaction_center_id center_id
1798: from bix_sum_grp_cls
1799: group by to_char(hour,'MON-YYYY'), interaction_center_id;
1800: CURSOR cr_center(p_center_id NUMBER) IS
1801: SELECT call_center_name center_name
1802: FROM bix_call_center_v

Line 2062: from bix_sum_grp_cls

2058: CURSOR cr_actual IS
2059: Select sum(interactions_answered_live) calls_ansd,
2060: to_char(hour,'MON-YYYY') month,
2061: interaction_center_id center_id
2062: from bix_sum_grp_cls
2063: group by to_char(hour,'MON-YYYY'), interaction_center_id;
2064: CURSOR cr_center(p_center_id NUMBER) IS
2065: SELECT call_center_name center_name
2066: FROM bix_call_center_v