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.WF_MAIL dependencies on WF_USER_ROLES

Line 447: from wf_roles r, wf_user_roles ur

443:
444: cursor c_roles(parent in varchar2)
445: is
446: select name, email_address
447: from wf_roles r, wf_user_roles ur
448: where ur.role_name = parent
449: and r.name = ur.user_name;
450:
451: begin

Line 1561: from wf_user_roles wur

1557: and ias.item_key = itemKey) intf, wf_notifications ntf
1558: where intf.notification_id = ntf.group_id)
1559: where role <> current_role
1560: and role not in (select wur.role_name
1561: from wf_user_roles wur
1562: where wur.user_name = current_role
1563: and wur.user_orig_system = orig_sys
1564: and wur.user_orig_system_id = orig_sysid)
1565: -- sacsharm bug 2887904 latest participant first

Line 5680: from WF_USER_ROLES UR

5676: and RECIPIENT_ROLE IN
5677: (select role from dual
5678: union
5679: select UR.ROLE_NAME
5680: from WF_USER_ROLES UR
5681: where UR.USER_ORIG_SYSTEM = rorig_system
5682: and UR.USER_ORIG_SYSTEM_ID = rorig_system_id
5683: and UR.USER_NAME = role)
5684: order by PRIORITY desc, DUE_DATE asc, NOTIFICATION_ID asc ;