APPS.BIX_SUMMARY_PUB dependencies on BIX_INTERACTIONS

Line 41: FROM bix_interactions

37: SUM(response_time) response_time,
38: SUM(resolution_time_internal) resolution_time_internal,
39: SUM(resolution_time) resolution_time,
40: SUM(DECODE(NVL(USER_ATTRIBUTE1,'F'),'T',1,NULL)) number_of_interactions
41: FROM bix_interactions
42: GROUP BY interaction_type, media_item_type, interaction_center_id,
43: campaign_id, resource_id, to_char(start_ts, 'DD-MM-YYYY-HH24'),
44: interaction_classification;
45:

Line 207: FROM BIX_INTERACTIONS;

203: l_count NUMBER := 0;
204: begin
205:
206: SELECT COUNT(*) INTO l_count
207: FROM BIX_INTERACTIONS;
208:
209: /* Since we capture data in summary tables at 1 hour level. We need delete the complete bucket
210: and re collect again
211: */

Line 218: FROM bix_interactions;

214:
215: IF l_count > 0 THEN
216: SELECT TO_DATE(TO_CHAR(MIN(start_ts),'DD/MM/YYYY HH24'),'DD/MM/YYYY HH24')
217: INTO g_start_date
218: FROM bix_interactions;
219: SELECT TO_DATE(TO_CHAR(MAX(start_ts),'DD/MM/YYYY HH24'),'DD/MM/YYYY HH24')
220: INTO g_end_date
221: FROM bix_interactions;
222:

Line 221: FROM bix_interactions;

217: INTO g_start_date
218: FROM bix_interactions;
219: SELECT TO_DATE(TO_CHAR(MAX(start_ts),'DD/MM/YYYY HH24'),'DD/MM/YYYY HH24')
220: INTO g_end_date
221: FROM bix_interactions;
222:
223: --dbms_output.put_line('Start date : '|| g_start_date);
224: --dbms_output.put_line('End date : '|| g_end_date);
225: