APPS.IEM_SPV_MONITORING_PVT dependencies on IEM_ROUTE_CLASSIFICATIONS

Line 113: from iem_route_classifications a, iem_account_route_class b

109:
110: l_monitor_index := l_monitor_index + 1;
111:
112: select a.route_classification_id, a.name bulk collect into l_class_id_tbl, l_class_name_tbl
113: from iem_route_classifications a, iem_account_route_class b
114: where a.route_classification_id = b.route_classification_id and b.email_account_id=l_email_account_id_tbl(l_index) order by UPPER(a.name);
115:
116: for i in l_class_id_tbl.FIRST..l_class_id_tbl.LAST LOOP
117: -- Queue statistics

Line 121: FROM iem_rt_proc_emails a,iem_mstemail_accounts b, iem_route_classifications c

117: -- Queue statistics
118: select Count(*) Total, nvl(max(sysdate-a.received_date)*24*60,0) wait_time,
119: nvl(avg(sysdate-a.received_date)*24*60,0) average_time
120: into l_queue_count, l_queue_wait_time, l_queue_average_time
121: FROM iem_rt_proc_emails a,iem_mstemail_accounts b, iem_route_classifications c
122: WHERE a.email_account_id=b.email_account_id and a.rt_classification_id=c.route_classification_id
123: and a.resource_id=0 and a.email_account_id=l_email_account_id_tbl(l_index) and c.route_classification_id=l_class_id_tbl(i);
124:
125: -- Agent Inbox statistics

Line 129: FROM iem_rt_proc_emails a,iem_mstemail_accounts b, iem_route_classifications c, iem_rt_media_items d

125: -- Agent Inbox statistics
126: select Count(*) Total, nvl(max(sysdate-a.received_date)*24*60,0) wait_time,
127: nvl(avg(sysdate-a.received_date)*24*60,0) average_time
128: into l_inbox_count, l_inbox_wait_time, l_inbox_average_time
129: FROM iem_rt_proc_emails a,iem_mstemail_accounts b, iem_route_classifications c, iem_rt_media_items d
130: WHERE a.email_account_id=b.email_account_id and a.rt_classification_id=c.route_classification_id
131: and a.resource_id<>0 and a.message_id=d.message_id and d.expire='N'
132: and a.email_account_id=l_email_account_id_tbl(l_index) and c.route_classification_id=l_class_id_tbl(i);
133: