APPS.WF_DIAGNOSTICS dependencies on WF_SYSTEMS

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

3734: Get_Table(l_cells, 2, 'V', l_result);
3735: l_temp := l_temp || l_result;
3736:
3737: l_cells(1) := '35%:WORKFLOW SYSTEM NAME';
3738: select name into l_result from wf_systems where guid=l_cells(2);
3739: l_cells(2) := l_result;
3740: Get_Table(l_cells, 2, 'V', l_result);
3741: l_temp := l_temp || l_result;
3742: