APPS.IEM_MAILITEM_PUB dependencies on IEM_ROUTE_CLASSIFICATIONS

Line 22: iem_route_classifications c,iem_agents d

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
26: AND a.email_account_id=d.email_account_id

Line 36: iem_route_classifications c,iem_agents d

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
40: AND a.email_account_id=d.email_account_id

Line 53: iem_route_classifications c

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
57: and a.queue_status is null

Line 240: FROM iem_rt_proc_emails a,iem_route_classifications b

236: l_tbl t_number_table:=t_number_table();
237: i_tbl jtf_number_table:=jtf_number_table();
238: CURSOR c1 IS
239: SELECT a.RT_CLASSIFICATION_ID,b.name,COUNT(*) TOTAL
240: FROM iem_rt_proc_emails a,iem_route_classifications b
241: where a.email_account_id=p_email_account_id
242: and a.resource_id =0
243: and a.rt_classification_id=b.route_classification_id
244: AND a.group_id in (select * from TABLE(cast(i_tbl as jtf_number_table)))

Line 368: from iem_rt_proc_emails a,iem_route_classifications b

364: x_msg_data OUT NOCOPY VARCHAR2)
365:
366: IS
367: cursor c2 is select a.rt_classification_id,b.name,count(*) total
368: from iem_rt_proc_emails a,iem_route_classifications b
369: where a.email_account_id=p_email_account_id
370: and a.resource_id=0
371: and a.rt_classification_id=b.route_classification_id
372: group by rt_classification_id,b.name;

Line 1210: IEM_ROUTE_CLASSIFICATIONS c,

1206: a.from_resource_id,
1207: decode(a.mail_item_status,''R'',1,''S'',1,0) read_status,d.description
1208: FROM iem_rt_proc_emails a,
1209: IEM_RT_MEDIA_ITEMS b,
1210: IEM_ROUTE_CLASSIFICATIONS c,
1211: FND_LOOKUPS d
1212: WHERE A.RT_CLASSIFICATION_ID=C.ROUTE_CLASSIFICATION_ID AND B.EXPIRE=:expire AND A.MESSAGE_ID=B.MESSAGE_ID and a.resource_id=:id and a.email_account_id=:account_id and
1213: substr(a.mail_item_status,1,1)=d.lookup_code and d.lookup_type=:status_type '||l_order_by
1214: using l_expire,p_resource_id,p_email_account_id,l_status_type;

Line 1376: from iem_rt_proc_emails a , IEM_ROUTE_CLASSIFICATIONS c,

1372: WHERE DTLS.key = ''IEMNBZTSRVSRID''
1373: and DTLS.encrypted_id = TAG.encrypted_id
1374: and TAG.message_id = a.message_id)
1375: )source_number
1376: from iem_rt_proc_emails a , IEM_ROUTE_CLASSIFICATIONS c,
1377: FND_LOOKUPS d , HZ_PARTIES p
1378: where a.RT_CLASSIFICATION_ID=c.ROUTE_CLASSIFICATION_ID
1379: and a.resource_id=0
1380: and a.email_account_id=:account_id