Here is the query to get request group details of concurrent program in Oracle applications
select fcp.user_concurrent_program_name,
fcp.concurrent_program_name,
frg.request_group_name
from apps.fnd_request_groups frg,
apps.fnd_request_group_units frgu,
apps.fnd_concurrent_programs_vl fcp
where frgu.request_unit_id = fcp.concurrent_program_id
and frg.request_group_id = frgu.request_group_id
and fcp.user_concurrent_program_name = '&p_user_concurrent_program_name'
select fcp.user_concurrent_program_name,
fcp.concurrent_program_name,
frg.request_group_name
from apps.fnd_request_groups frg,
apps.fnd_request_group_units frgu,
apps.fnd_concurrent_programs_vl fcp
where frgu.request_unit_id = fcp.concurrent_program_id
and frg.request_group_id = frgu.request_group_id
and fcp.user_concurrent_program_name = '&p_user_concurrent_program_name'