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_ROUTE_PUB dependencies on IEM_REROUTE_HISTS

Line 287: d.resource_id not in (select agent_id from iem_reroute_hists where message_id=p_message_id)

283: c.group_id = i.group_id
284: and
285: i.usage = groupUsage
286: and
287: d.resource_id not in (select agent_id from iem_reroute_hists where message_id=p_message_id)
288: and
289: rownum = 1;
290:
291: return groupOK;

Line 598: select count(*) into l_count from iem_reroute_hists

594: else
595: -- Added on 8/21/2004. For Tar 4021452.999
596: -- Validate agent_id to see if the message has been route to the same agent before. For scenario
597: -- that auto-routed Agent pick up the message and requeues the message and expects it routed to different group
598: select count(*) into l_count from iem_reroute_hists
599: where message_id=l_msg_id and agent_id=l_agent_id;
600:
601:
602: if( l_count = 0 and IEM_TAGPROCESS_PUB.isValidAgent(l_agent_id,p_accountId)) then