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_ROUTING_RULES

Line 3107: from WF_ROUTING_RULES WRR

3103: l_hide_reassign varchar(1);
3104:
3105: cursor rulecurs is
3106: select WRR.RULE_ID, WRR.ACTION, WRR.ACTION_ARGUMENT, WRR.RULE_COMMENT
3107: from WF_ROUTING_RULES WRR
3108: where WRR.ROLE = recip
3109: and sysdate between nvl(WRR.BEGIN_DATE, sysdate-1) and
3110: nvl(WRR.END_DATE, sysdate+1)
3111: and nvl(WRR.MESSAGE_TYPE, msgtype) = msgtype

Line 3120: from WF_ROUTING_RULE_ATTRIBUTES WRRA, WF_ROUTING_RULES WRR,

3116:
3117: cursor attrcurs(ruleid in number) is
3118: select WRRA.NAME, WRRA.TEXT_VALUE, WRRA.NUMBER_VALUE, WRRA.DATE_VALUE,
3119: WMA.TYPE
3120: from WF_ROUTING_RULE_ATTRIBUTES WRRA, WF_ROUTING_RULES WRR,
3121: WF_MESSAGE_ATTRIBUTES WMA
3122: where WRRA.RULE_ID = ruleid
3123: and WRRA.RULE_ID = WRR.RULE_ID
3124: and WRR.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 6737: from wf_routing_rules

6733: l_event_name varchar2(240);
6734:
6735: CURSOR rulecurs is
6736: select action, action_argument
6737: from wf_routing_rules
6738: where role = username
6739: and nvl(message_type, l_messageType) = l_messageType
6740: and nvl(message_name,l_messageName) = l_messageName
6741: and sysdate between nvl(begin_date, sysdate-1) and