About ERP Times

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'