eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_MAILITEM_PUB dependencies on IEM_AGENTS

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