APPS.IEM_MAILITEM_PUB dependencies on IEM_MSTEMAIL_ACCOUNTS

Line 21: FROM iem_rt_proc_emails a,iem_mstemail_accounts b,

17: CURSOR c1 IS
18: SELECT a.EMAIL_ACCOUNT_ID,a.RT_CLASSIFICATION_ID,
19: b.USER_NAME,c.name,count(*) Total,
20: nvl(max(sysdate-a.received_date)*24*60,0) wait_time
21: FROM iem_rt_proc_emails a,iem_mstemail_accounts b,
22: iem_route_classifications c,iem_agents d
23: WHERE a.resource_id=0
24: and a.email_account_id=b.email_account_id
25: and a.rt_classification_id=c.route_classification_id

Line 35: FROM iem_rt_proc_emails a,iem_mstemail_accounts b,

31: CURSOR c_11 IS
32: SELECT a.EMAIL_ACCOUNT_ID,a.RT_CLASSIFICATION_ID,
33: b.USER_NAME,c.name,count(*) Total,
34: nvl(max(sysdate-a.received_date)*24*60,0) wait_time
35: FROM iem_rt_proc_emails a,iem_mstemail_accounts b,
36: iem_route_classifications c,iem_agents d
37: WHERE a.resource_id=0
38: and a.email_account_id=b.email_account_id
39: and a.rt_classification_id=c.route_classification_id

Line 52: FROM iem_rt_proc_emails a,iem_mstemail_accounts b,

48: select a.email_account_id,a.rt_classification_id,
49: b.USER_NAME,c.name,Count(*) Total,
50: nvl(max(sysdate-a.received_date)*24*60,0) wait_time,
51: max(decode(a.mail_item_status,'A',1,'N',1,'T',1,0)) email_status
52: FROM iem_rt_proc_emails a,iem_mstemail_accounts b,
53: iem_route_classifications c
54: WHERE a.resource_id=p_resource_id
55: and a.email_account_id=b.email_account_id
56: and a.rt_classification_id=c.route_classification_id