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 3198: from WF_ROUTING_RULES WRR

3194: l_from_role WF_NOTIFICATIONS.FROM_ROLE%TYPE;
3195:
3196: cursor rulecurs is
3197: select WRR.RULE_ID, WRR.ACTION, WRR.ACTION_ARGUMENT, WRR.RULE_COMMENT
3198: from WF_ROUTING_RULES WRR
3199: where WRR.ROLE = recip
3200: and sysdate between nvl(WRR.BEGIN_DATE, sysdate-1) and
3201: nvl(WRR.END_DATE, sysdate+1)
3202: and nvl(WRR.MESSAGE_TYPE, msgtype) = msgtype

Line 3211: from WF_ROUTING_RULE_ATTRIBUTES WRRA, WF_ROUTING_RULES WRR,

3207:
3208: cursor attrcurs(ruleid in number) is
3209: select WRRA.NAME, WRRA.TEXT_VALUE, WRRA.NUMBER_VALUE, WRRA.DATE_VALUE,
3210: WMA.TYPE
3211: from WF_ROUTING_RULE_ATTRIBUTES WRRA, WF_ROUTING_RULES WRR,
3212: WF_MESSAGE_ATTRIBUTES WMA
3213: where WRRA.RULE_ID = ruleid
3214: and WRRA.RULE_ID = WRR.RULE_ID
3215: and WRR.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 7195: from wf_routing_rules

7191: l_sysComment varchar2(320);
7192:
7193: CURSOR rulecurs is
7194: select action, action_argument
7195: from wf_routing_rules
7196: where role = l_more_info_role
7197: and nvl(message_type, l_messageType) = l_messageType
7198: and nvl(message_name,l_messageName) = l_messageName
7199: and sysdate between nvl(begin_date, sysdate-1) and

Line 7434: from wf_routing_rules

7430: cnt number := 1; --Used to call UpdateInfo() for the first time, that means one time.
7431:
7432: CURSOR rulecurs is
7433: select action, action_argument
7434: from wf_routing_rules
7435: where role = username
7436: and nvl(message_type, l_messageType) = l_messageType
7437: and nvl(message_name,l_messageName) = l_messageName
7438: and sysdate between nvl(begin_date, sysdate-1) and