DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on WF_EVENT_SUBSCRIPTIONS

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(+)