Concurrent Program and attached Responsibility and Request Group Query

select * from fnd_concurrent_programs_tl
where user_concurrent_program_name like 'XXX%Sales%'

 'XXX GL Extract Report%'

SELECT frt.responsibility_name,
               frg.request_group_name,
               frg.description,
               fcpt.user_concurrent_program_name
  FROM fnd_request_groups frg
             ,fnd_request_group_units frgu
             ,fnd_concurrent_programs fcp
             ,fnd_concurrent_programs_tl fcpt
             ,fnd_responsibility_tl frt
             ,fnd_responsibility frs
 WHERE frgu.unit_application_id = fcp.application_id
 AND   frgu.request_unit_id = fcp.concurrent_program_id
 AND   frg.request_group_id = frgu.request_group_id
 AND   frg.application_id = frgu.application_id
 AND   fcpt.source_lang = USERENV('LANG')
 AND   fcp.application_id = fcpt.application_id
 AND   fcp.concurrent_program_id = fcpt.concurrent_program_id
 AND   frs.application_id = frt.application_id
 AND   frs.responsibility_id = frt.responsibility_id
 AND   frt.source_lang = USERENV('LANG')
 AND   frs.request_group_id = frg.request_group_id
 AND   frs.application_id = frg.application_id
-- AND   fcp.concurrent_program_name = <shortname>
 AND   (fcpt.user_concurrent_program_name)  like 'U%Credi%'
 --and frt.responsibility_name like '%Paper%'


 select * from fnd_concurrent_programs
 where CONCURRENT_PROGRAM_ID = 133344

 where concurrent_program_name = 'XXX GL Extract Report'

 select fcp.user_concurrent_program_name
,fcr.request_date
,fu.user_name
,fcr.actual_start_date
,fcr.actual_completion_date
,fcr.phase_code
,fcr.status_code
,fcr.argument1
,fcr.argument2
,fcr.argument3
from fnd_concurrent_programs_vl fcp
,fnd_concurrent_requests fcr
,fnd_user fu
where fcp.user_concurrent_program_name like 'U%Sales%'
and fcp.concurrent_program_id = fcr.concurrent_program_id
and fcr.requested_by = fu.user_id
order by fcr.actual_completion_date desc



SELECT * FROM ALL_OBJECTS
WHERE OBJECT_NAME = 'XXXX_GL_EXT_MUL_PERIOD_PROC'



select variable_name, value
from fnd_env_context
where variable_name like '%\_TOP' escape '\'
and concurrent_process_id = (select max(concurrent_process_id) from fnd_env_context)
order by 1;