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_SPV_MONITORING_PVT dependencies on JTF_RS_RESOURCE_EXTNS

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 271: jtf_rs_resource_extns res, fnd_responsibility resp where res.user_id=respgrp.user_id

267: if p_resource_role = 0 then -- All Agents
268: if (p_resource_name is not null) then
269: select unique res.resource_id,concat(concat(res.source_last_name, ', '), res.source_first_name) as resource_name
270: bulk collect into l_resource_id_tbl, l_resource_name_tbl from fnd_user_resp_groups respgrp,
271: jtf_rs_resource_extns res, fnd_responsibility resp where res.user_id=respgrp.user_id
272: and respgrp.responsibility_id=resp.responsibility_id and resp.application_id=680
273: and (resp.responsibility_key = 'EMAIL_CENTER_SUPERVISOR' or resp.responsibility_key = 'IEM_SA_AGENT')
274: and res.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where
275: rel.role_id in (28, 29, 30) and rel.delete_flag = 'N'

Line 287: jtf_rs_resource_extns res, fnd_responsibility resp where res.user_id=respgrp.user_id

283: order by resource_name;
284: else
285: select unique res.resource_id,concat(concat(res.source_last_name, ', '), res.source_first_name) as resource_name
286: bulk collect into l_resource_id_tbl, l_resource_name_tbl from fnd_user_resp_groups respgrp,
287: jtf_rs_resource_extns res, fnd_responsibility resp where res.user_id=respgrp.user_id
288: and respgrp.responsibility_id=resp.responsibility_id and resp.application_id=680
289: and (resp.responsibility_key = 'EMAIL_CENTER_SUPERVISOR' or resp.responsibility_key = 'IEM_SA_AGENT')
290: and res.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where
291: rel.role_id in (28, 29, 30) and rel.delete_flag = 'N'

Line 315: jtf_rs_resource_extns res, fnd_responsibility resp where res.user_id=respgrp.user_id

311:
312: if (p_resource_name is not null) then
313: select res.resource_id,concat(concat(res.source_last_name, ', '), res.source_first_name) as resource_name
314: bulk collect into l_resource_id_tbl, l_resource_name_tbl from fnd_user_resp_groups respgrp,
315: jtf_rs_resource_extns res, fnd_responsibility resp where res.user_id=respgrp.user_id
316: and respgrp.responsibility_id=resp.responsibility_id and resp.application_id=680
317: and resp.responsibility_key = l_resource_role
318: and res.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where
319: rel.role_id in (28, 29, 30) and rel.delete_flag = 'N'

Line 330: jtf_rs_resource_extns res, fnd_responsibility resp where res.user_id=respgrp.user_id

326: order by resource_name;
327: else
328: select res.resource_id,concat(concat(res.source_last_name, ', '), res.source_first_name) as resource_name
329: bulk collect into l_resource_id_tbl, l_resource_name_tbl from fnd_user_resp_groups respgrp,
330: jtf_rs_resource_extns res, fnd_responsibility resp where res.user_id=respgrp.user_id
331: and respgrp.responsibility_id=resp.responsibility_id and resp.application_id=680
332: and resp.responsibility_key = l_resource_role
333: and res.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where
334: rel.role_id in (28, 29, 30) and rel.delete_flag = 'N'

Line 355: (select a.email_account_id from iem_agents a, jtf_rs_resource_extns b

351: select Count(*) Total into l_assigned_email_count
352: FROM iem_rt_proc_emails a, iem_rt_media_items b
353: WHERE a.message_id=b.message_id and b.expire='N'
354: and a.resource_id = l_resource_id_tbl(l_index) and a.email_account_id in
355: (select a.email_account_id from iem_agents a, jtf_rs_resource_extns b
356: where a.resource_id = b.resource_id and b.user_id=l_current_user);
357:
358: select Count(*) Total into l_requeue_all_count
359: FROM iem_rt_proc_emails a, iem_rt_media_items b

Line 362: (select email_account_id from iem_agents c, jtf_rs_resource_extns d

358: select Count(*) Total into l_requeue_all_count
359: FROM iem_rt_proc_emails a, iem_rt_media_items b
360: WHERE a.message_id=b.message_id and b.expire='N'
361: and a.resource_id = l_resource_id_tbl(l_index) and a.email_account_id in
362: (select email_account_id from iem_agents c, jtf_rs_resource_extns d
363: where c.resource_id=d.resource_id and d.user_id=l_current_user);
364:
365: select count(*) into l_agent_acct_count from iem_agents where resource_id=l_resource_id_tbl(l_index);
366:

Line 402: select count(*) into l_email_count_flag from iem_agents a, jtf_rs_resource_extns b

398: WHERE a.message_id=b.message_id and b.expire='N'
399: and a.resource_id = l_resource_id_tbl(l_index)
400: and a.email_account_id=l_account_id_tbl(i);
401:
402: select count(*) into l_email_count_flag from iem_agents a, jtf_rs_resource_extns b
403: where a.email_account_id=l_account_id_tbl(i)
404: and a.resource_id = b.resource_id and b.user_id=l_current_user;
405:
406: if (l_email_count_flag = 0) then