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 3466: FROM WF_AGENTS a, WF_SYSTEMS s

3462: cursor c_agent is
3463: SELECT ' ' || a.NAME || '' agent_name ,
3464: ' ' || s.NAME || '' sys_name,
3465: ' ' || a.status ||'' status
3466: FROM WF_AGENTS a, WF_SYSTEMS s
3467: WHERE a.system_guid = s.guid
3468: AND a.name IN ('WF_CONTROL', 'WF_NOTIFICATION_IN', 'WF_NOTIFICATION_OUT',
3469: 'WF_DEFERRED', 'WF_ERROR');
3470:

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

3476: DECODE(sub.guid, NULL, 'Subscription Not Defined',
3477: DECODE(sub.out_agent_guid, NULL, 'Not Defined',
3478: oa.name || '@' || oas.name)) OUT_AGENT,
3479: sub.status STATUS
3480: FROM WF_EVENTS e, WF_SYSTEMS s, WF_EVENT_SUBSCRIPTIONS sub, WF_AGENTS oa, WF_SYSTEMS oas
3481: WHERE e.NAME IN ('oracle.apps.wf.notification.send.group',
3482: 'oracle.apps.fnd.cp.gsc.bes.control.group',
3483: 'oracle.apps.wf.notification.summary.send')
3484: AND e.guid = sub.event_filter_guid(+)

Line 3827: FROM wf_agents

3823: l_owner varchar2(30);
3824:
3825: CURSOR c_agents IS
3826: SELECT name, queue_name, status
3827: FROM wf_agents
3828: WHERE (name like 'WF%'
3829: OR name like 'ECX%');
3830:
3831: CURSOR c_queue IS

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

4206: l_cells(j+1) := l_subs_list(i).SOURCE_TYPE;
4207: l_cells(j+2) := l_subs_list(i).SOURCE_AGENT_GUID;
4208:
4209: if (l_subs_list(i).SOURCE_AGENT_GUID is not null) then
4210: select display_name into l_agent_tmp from wf_agents where guid = l_subs_list(i).SOURCE_AGENT_GUID;
4211: l_cells(j+2) := l_agent_tmp;
4212: end if;
4213:
4214: l_cells(j+3) := l_subs_list(i).PHASE;

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

4214: l_cells(j+3) := l_subs_list(i).PHASE;
4215: l_cells(j+4) := l_subs_list(i).RULE_DATA;
4216: l_cells(j+5) := l_subs_list(i).OUT_AGENT_GUID;
4217: if (l_subs_list(i).OUT_AGENT_GUID is not null) then
4218: select display_name into l_agent_tmp from wf_agents where guid = l_subs_list(i).OUT_AGENT_GUID;
4219: l_cells(j+5) := l_agent_tmp;
4220: end if;
4221:
4222: l_cells(j+6) := l_subs_list(i).TO_AGENT_GUID;

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

4220: end if;
4221:
4222: l_cells(j+6) := l_subs_list(i).TO_AGENT_GUID;
4223: if (l_subs_list(i).TO_AGENT_GUID is not null) then
4224: select display_name into l_agent_tmp from wf_agents where guid = l_subs_list(i).TO_AGENT_GUID;
4225: l_cells(j+6) := l_agent_tmp;
4226: end if;
4227:
4228: l_cells(j+7) := l_subs_list(i).RULE_FUNCTION;

Line 4265: FROM wf_active_subscriptions_v wfact, wf_agents aa,

4261: wf_process_type wf_process_type,
4262: wf_process_name wf_process_name,
4263: subscription_parameters parameters,
4264: subscription_on_error_type error_type
4265: FROM wf_active_subscriptions_v wfact, wf_agents aa,
4266: wf_agents ab, wf_agents ac
4267: WHERE event_name = p_event_name
4268: and wfact.subscription_out_agent_guid = aa.guid(+)
4269: and wfact.subscription_to_agent_guid = ab.guid(+)

Line 4266: wf_agents ab, wf_agents ac

4262: wf_process_name wf_process_name,
4263: subscription_parameters parameters,
4264: subscription_on_error_type error_type
4265: FROM wf_active_subscriptions_v wfact, wf_agents aa,
4266: wf_agents ab, wf_agents ac
4267: WHERE event_name = p_event_name
4268: and wfact.subscription_out_agent_guid = aa.guid(+)
4269: and wfact.subscription_to_agent_guid = ab.guid(+)
4270: and wfact.subscription_source_agent_guid = ac.guid(+);