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.IEX_COLLECTORS_TO_RESOURCE dependencies on JTF_RS_ROLE_RELATIONS

Line 252: jtf_rs_resource_extns jtfrs,JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtv

248: BEGIN
249: SELECT 1
250: INTO l_check
251: FROM
252: jtf_rs_resource_extns jtfrs,JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtv
253: WHERE
254: jtrr.role_resource_id = jtfrs.resource_id
255: AND jtv.role_id = jtrr.role_id
256: AND jtv.ROLE_CODE = 'IEX_AGENT'

Line 339: FROM JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtv,

335: SELECT employee_id,inactive_date,description,name,resource_id FROM
336: ar_collectors ac
337: WHERE employee_id is not null
338: AND employee_id not in (SELECT jtr.source_id
339: FROM JTF_RS_ROLE_RELATIONS jtrr, JTF_RS_ROLES_B jtv,
340: JTF_RS_RESOURCE_EXTNS jtr
341: WHERE jtv.ROLE_CODE = 'IEX_AGENT' AND jtv.role_id = jtrr.role_id
342: AND jtrr.role_resource_id = jtr.resource_id
343: AND jtrr.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'

Line 509: FROM JTF_RS_ROLE_RELATIONS_VL JRR,

505:
506: -- Check whether Collections Role Exists for the Resource and Create if Role does'nt exist.
507: BEGIN
508: SELECT ROLE_ID INTO L_CHECK_ROLE
509: FROM JTF_RS_ROLE_RELATIONS_VL JRR,
510: JTF_RS_RESOURCE_EXTNS JRE
511: WHERE
512: JRE.SOURCE_ID = L_EMPLOYEE_ID(I)
513: AND JRR.ROLE_RESOURCE_ID = JRE.RESOURCE_ID