--Oracle Workflow Events Query
SELECT a.*,
a.msg_state,
a.user_data.event_name,
TRUNC (a.user_data.send_date)
FROM applsys.aq$wf_deferred a
WHERE a.user_data.send_date > SYSDATE - 1 / 24
AND a.user_data.event_name IN
('oracle.apps.gmi.inv.po.receipt',
'oracle.apps.gml.po.receipt.created',
'oracle.apps.gmi.inventory.created')
ORDER BY 1, 2
SELECT w_even.name,
w_even.status event_status,
w_e_subs.status subscription_status,
NVL (w_e_subs.phase, 0) subscription_phase,
w_e_subs.rule_function
FROM wf_events w_even, wf_event_subscriptions w_e_subs
WHERE w_even.name IN
('oracle.apps.gmi.inv.po.receipt',
'oracle.apps.gml.po.receipt.created',
'oracle.apps.gmi.inventory.created')
AND w_e_subs.event_filter_guid = w_even.guid;