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 FND_RESPONSIBILITY

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'