Query to find package name from business event

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 like '%oracle.apps.ont%' -- Business Event name
  and w_e_subs.event_filter_guid = w_even.guid;

Command to find a files containing a text string in linux

 grep -rwli "string_to_search" xxsss/12.0.0/bin

Query to find out the concurrent program name from Request Set

SELECT DISTINCT frst.request_set_id,

  frst.user_request_set_name request_set,

  frst.description description,

  frsst.request_set_stage_id,

  frsst.user_stage_name stage_name,

  frsst.description stage_description,

  fcp.user_concurrent_program_name  

FROM apps.fnd_request_sets_tl frst,

  apps.fnd_request_set_stages_tl frsst,

  apps.fnd_request_set_programs frsp,

  apps.fnd_concurrent_programs_tl fcp

WHERE frst.application_id =frsst.set_application_id

AND frst.request_set_id   = frsst.request_set_id

AND frst.request_set_id = frsp.request_set_id

AND frsst.request_set_stage_id = frsp.request_set_stage_id

AND frsp.concurrent_program_id = fcp.concurrent_program_id

AND frst.language =userenv('LANG')

AND fcp.language =userenv('LANG')

AND upper(frst.user_request_set_name) like '%'||upper('Request Set Name')||'%'

order by frst.user_request_set_name, frsst.request_set_stage_id;

Query to findout the Request Set from concurrent program

SELECT DISTINCT frst.request_set_id,

  frst.user_request_set_name request_set,

  frst.description description,

  frsst.request_set_stage_id,

  frsst.user_stage_name stage_name,

  frsst.description stage_description,

  fcp.user_concurrent_program_name  

FROM apps.fnd_request_sets_tl frst,

  apps.fnd_request_set_stages_tl frsst,

  apps.fnd_request_set_programs frsp,

  apps.fnd_concurrent_programs_tl fcp

WHERE frst.application_id =frsst.set_application_id

AND frst.request_set_id   = frsst.request_set_id

AND frst.request_set_id = frsp.request_set_id

AND frsst.request_set_stage_id = frsp.request_set_stage_id

AND frsp.concurrent_program_id = fcp.concurrent_program_id

AND frst.language =userenv('LANG')

AND fcp.language =userenv('LANG')

AND upper(fcp.user_concurrent_program_name) LIKE '%'||upper('Concurrent Program Name')||'%'

order by frst.user_request_set_name, frsst.request_set_stage_id;