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_ROLE_RELATIONS

Line 274: and res.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where

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'
276: and rel.role_resource_type = 'RS_INDIVIDUAL'
277: -- and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
278: -- and trunc(nvl(rel.end_date_active, sysdate))

Line 290: and res.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where

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'
292: and rel.role_resource_type = 'RS_INDIVIDUAL'
293: -- and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
294: -- and trunc(nvl(rel.end_date_active, sysdate))

Line 318: and res.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where

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'
320: and rel.role_resource_type = 'RS_INDIVIDUAL'
321: and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
322: and trunc(nvl(rel.end_date_active, sysdate)) )

Line 333: and res.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where

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'
335: and rel.role_resource_type = 'RS_INDIVIDUAL'
336: and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
337: and trunc(nvl(rel.end_date_active, sysdate)) )