SELECT fsc.component_name
,dq.owner
,dq.queue_table
,fsc.correlation_id
FROM applsys.fnd_svc_components fsc
,applsys.wf_agents wa
,dba_queues dq
WHERE fsc.inbound_agent_name || fsc.outbound_agent_name = wa.name
AND dq.owner || '.' || dq.name = wa.queue_name
AND fsc.component_type LIKE 'WF_%AGENT%'
No comments:
Post a Comment