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_NOTIFICATION dependencies on WF_USER_ROLES

Line 4056: from WF_USER_ROLES WUR

4052: rorig_system_id pls_integer;
4053:
4054: cursor role_users_curs is
4055: select WUR.USER_NAME
4056: from WF_USER_ROLES WUR
4057: where WUR.ROLE_ORIG_SYSTEM = rorig_system
4058: and WUR.ROLE_ORIG_SYSTEM_ID = rorig_system_id
4059: and WUR.ROLE_NAME = role;
4060:

Line 5310: from WF_USER_ROLES WUR

5306: into ncount
5307: from WF_NOTIFICATIONS WN
5308: where WN.RECIPIENT_ROLE in
5309: (select WUR.ROLE_NAME
5310: from WF_USER_ROLES WUR
5311: where WUR.USER_NAME = WorkCount.username)
5312: and WN.STATUS = 'OPEN';
5313: else
5314: select count(1)

Line 5319: from WF_USER_ROLES WUR

5315: into ncount
5316: from WF_NOTIFICATIONS WN
5317: where WN.RECIPIENT_ROLE in
5318: (select WUR.ROLE_NAME
5319: from WF_USER_ROLES WUR
5320: where WUR.USER_ORIG_SYSTEM = substr(WorkCount.username, 1, colon-1)
5321: and WUR.USER_ORIG_SYSTEM_ID = substr(WorkCount.username, colon+1)
5322: and WUR.USER_NAME = WorkCount.username)
5323: and WN.STATUS = 'OPEN';