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_DIAGNOSTICS dependencies on WF_AGENTS

Line 3115: FROM WF_AGENTS a, WF_SYSTEMS s

3111: cursor c_agent is
3112: SELECT ' ' || a.NAME || '' agent_name ,
3113: ' ' || s.NAME || '' sys_name,
3114: ' ' || a.status ||'' status
3115: FROM WF_AGENTS a, WF_SYSTEMS s
3116: WHERE a.system_guid = s.guid
3117: AND a.name IN ('WF_CONTROL', 'WF_NOTIFICATION_IN', 'WF_NOTIFICATION_OUT',
3118: 'WF_DEFERRED', 'WF_ERROR');
3119:

Line 3129: FROM WF_EVENTS e, WF_SYSTEMS s, WF_EVENT_SUBSCRIPTIONS sub, WF_AGENTS oa, WF_SYSTEMS oas

3125: DECODE(sub.guid, NULL, 'Subscription Not Defined',
3126: DECODE(sub.out_agent_guid, NULL, 'Not Defined',
3127: oa.name || '@' || oas.name)) OUT_AGENT,
3128: sub.status STATUS
3129: FROM WF_EVENTS e, WF_SYSTEMS s, WF_EVENT_SUBSCRIPTIONS sub, WF_AGENTS oa, WF_SYSTEMS oas
3130: WHERE e.NAME IN ('oracle.apps.wf.notification.send.group',
3131: 'oracle.apps.fnd.cp.gsc.bes.control.group',
3132: 'oracle.apps.wf.notification.summary.send')
3133: AND e.guid = sub.event_filter_guid(+)

Line 3476: FROM wf_agents

3472: l_owner varchar2(30);
3473:
3474: CURSOR c_agents IS
3475: SELECT name, queue_name, status
3476: FROM wf_agents
3477: WHERE (name like 'WF%'
3478: OR name like 'ECX%');
3479:
3480: CURSOR c_queue IS

Line 3859: select display_name into l_agent_tmp from wf_agents where guid = l_subs_list(i).SOURCE_AGENT_GUID;

3855: l_cells(j+1) := l_subs_list(i).SOURCE_TYPE;
3856: l_cells(j+2) := l_subs_list(i).SOURCE_AGENT_GUID;
3857:
3858: if (l_subs_list(i).SOURCE_AGENT_GUID is not null) then
3859: select display_name into l_agent_tmp from wf_agents where guid = l_subs_list(i).SOURCE_AGENT_GUID;
3860: l_cells(j+2) := l_agent_tmp;
3861: end if;
3862:
3863: l_cells(j+3) := l_subs_list(i).PHASE;

Line 3867: select display_name into l_agent_tmp from wf_agents where guid = l_subs_list(i).OUT_AGENT_GUID;

3863: l_cells(j+3) := l_subs_list(i).PHASE;
3864: l_cells(j+4) := l_subs_list(i).RULE_DATA;
3865: l_cells(j+5) := l_subs_list(i).OUT_AGENT_GUID;
3866: if (l_subs_list(i).OUT_AGENT_GUID is not null) then
3867: select display_name into l_agent_tmp from wf_agents where guid = l_subs_list(i).OUT_AGENT_GUID;
3868: l_cells(j+5) := l_agent_tmp;
3869: end if;
3870:
3871: l_cells(j+6) := l_subs_list(i).TO_AGENT_GUID;

Line 3873: select display_name into l_agent_tmp from wf_agents where guid = l_subs_list(i).TO_AGENT_GUID;

3869: end if;
3870:
3871: l_cells(j+6) := l_subs_list(i).TO_AGENT_GUID;
3872: if (l_subs_list(i).TO_AGENT_GUID is not null) then
3873: select display_name into l_agent_tmp from wf_agents where guid = l_subs_list(i).TO_AGENT_GUID;
3874: l_cells(j+6) := l_agent_tmp;
3875: end if;
3876:
3877: l_cells(j+7) := l_subs_list(i).RULE_FUNCTION;

Line 3914: FROM wf_active_subscriptions_v wfact, wf_agents aa,

3910: wf_process_type wf_process_type,
3911: wf_process_name wf_process_name,
3912: subscription_parameters parameters,
3913: subscription_on_error_type error_type
3914: FROM wf_active_subscriptions_v wfact, wf_agents aa,
3915: wf_agents ab, wf_agents ac
3916: WHERE event_name = p_event_name
3917: and wfact.subscription_out_agent_guid = aa.guid(+)
3918: and wfact.subscription_to_agent_guid = ab.guid(+)

Line 3915: wf_agents ab, wf_agents ac

3911: wf_process_name wf_process_name,
3912: subscription_parameters parameters,
3913: subscription_on_error_type error_type
3914: FROM wf_active_subscriptions_v wfact, wf_agents aa,
3915: wf_agents ab, wf_agents ac
3916: WHERE event_name = p_event_name
3917: and wfact.subscription_out_agent_guid = aa.guid(+)
3918: and wfact.subscription_to_agent_guid = ab.guid(+)
3919: and wfact.subscription_source_agent_guid = ac.guid(+);