APPS.WF_DIAGNOSTICS dependencies on WF_SYSTEMS

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 4089: select name into l_result from wf_systems where guid=l_cells(2);

4085: Get_Table(l_cells, 2, 'V', l_result);
4086: l_temp := l_temp || l_result;
4087:
4088: l_cells(1) := '35%:WORKFLOW SYSTEM NAME';
4089: select name into l_result from wf_systems where guid=l_cells(2);
4090: l_cells(2) := l_result;
4091: Get_Table(l_cells, 2, 'V', l_result);
4092: l_temp := l_temp || l_result;
4093: