APPS.IEM_SPV_MONITORING_PVT dependencies on IEM_MSTEMAIL_ACCOUNTS

Line 61: from iem_mstemail_accounts a, iem_agents b, jtf_rs_resource_extns c

57: -- Initialize API return status to SUCCESS
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59:
60: select a.email_account_id, a.from_name bulk collect into l_email_account_id_tbl, l_account_name_tbl
61: from iem_mstemail_accounts a, iem_agents b, jtf_rs_resource_extns c
62: where a.email_account_id=b.email_account_id and b.resource_id = c.resource_id and c.user_id = l_current_user
63: order by UPPER(a.from_name);
64:
65:

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:

Line 389: from iem_mstemail_accounts a, iem_agents b

385:
386: l_monitor_index := l_monitor_index + 1;
387:
388: select a.email_account_id, a.from_name bulk collect into l_account_id_tbl, l_account_name_tbl
389: from iem_mstemail_accounts a, iem_agents b
390: where a.email_account_id=b.email_account_id and b.resource_id=l_resource_id_tbl(l_index)
391: order by UPPER(a.from_name);
392:
393: for i in l_account_id_tbl.FIRST..l_account_id_tbl.LAST LOOP