Workflow Business Event and Subscription details SQL Query

/*Workflow Business Event and Subscription details SQL Query*/
SELECT we.guid event_guid,we.NAME, we.status event_status, wes.status subscription_status,
       NVL (wes.phase, 0) subscription_phase,
       wes.licensed_flag subscription_licensed_flag,
       we.licensed_flag event_licensed_flag,
       wes.guid subscription_guid,
        wes.rule_function,
       wes.on_error_code, wes.action_code, wes.customization_level,
       wes.owner_name subscription_owner_name,
       wes.owner_tag subscription_owner_tag,
       wes.source_type subscription_source_type,
       wes.rule_data subscription_rule_data, we.owner_name event_owner_name,
       we.owner_tag event_owner_tag,
       we.security_group_id event_security_group_id
FROM   wf_events we, wf_event_subscriptions wes
 WHERE 1 = 1
   AND we.NAME IN
          ('oracle.apps.wf.notification.send',
           'oracle.apps.wf.notification.respond',
           'oracle.apps.wf.notification.reassign'
          )
   AND wes.event_filter_guid = we.guid