27 Oct 2008

Query to get request group details of concurrent program

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'