Find Request Group

/* Lokanadham */

select distinct fcpl.user_concurrent_program_name,

                frg.request_group_id,

                fcp.concurrent_program_name,

                fapp.application_name,

                frg.request_group_name,

                fnrtl.responsibility_name

  from apps.fnd_request_groups frg,

       apps.fnd_application_tl fapp,

       apps.fnd_request_group_units frgu,

       apps.fnd_concurrent_programs fcp,

       apps.fnd_concurrent_programs_tl fcpl,

       apps.fnd_responsibility fnr,

       apps.fnd_responsibility_tl fnrtl

 where     frg.application_id = fapp.application_id

       and frg.application_id = frgu.application_id

       and frg.request_group_id = frgu.request_group_id

       and frg.request_group_id = fnr.request_group_id

       and frg.application_id = fnr.application_id

       and fnr.responsibility_id = fnrtl.responsibility_id

       and frgu.request_unit_id = fcp.concurrent_program_id

       and frgu.unit_application_id = fcp.application_id

       and fcp.concurrent_program_id = fcpl.concurrent_program_id

       and fcpl.user_concurrent_program_name like '%Bursting%'

       and fnrtl.language = 'US'

       and fapp.language = 'US'

--and FRG.request_group_name ='All Reports';

Find Request Group

/* Formatted on 12/31/2013 10:26:58 AM (QP5 v5.163.1008.3004) */

  SELECT responsibility_name,

         frg.request_group_name,

         fcpv.user_concurrent_program_name,

         fcpv.description

    FROM fnd_request_groups frg,

         fnd_request_group_units frgu,

         fnd_concurrent_programs_vl fcpv,

         fnd_responsibility_vl frv

   WHERE     frgu.request_unit_type = 'P'

         AND frgu.request_group_id = frg.request_group_id

         AND frgu.request_unit_id = fcpv.concurrent_program_id

         AND frv.request_group_id = frg.request_group_id

         AND responsibility_name = NVL (:RESP_NAME, responsibility_name)

         AND frg.request_group_name = NVL (:RG_NAME, frg.request_group_name)

         AND fcpv.user_concurrent_program_name =

                NVL (:USER_CP_NAME, fcpv.user_concurrent_program_name)

ORDER BY responsibility_name;

Data Group, Menu, Request Group Importance While Creating Responsibility

When you define a responsibility, you assign to it some or all of the components described below.
1. Menu (Required)
A menu is a hierarchical arrangement of application functions (forms). In the definition of a responsibility, the specified menu defines what is displayed in the navigator. The specified menu does not necessarily define the functions that can be accessed by the responsibility, which are granted.

2. Data Group (Required)
A data group defines the mapping between Oracle Applications products and ORACLE database IDs. A data group determines which Oracle database accounts a responsibility's forms, concurrent programs, and reports connect to.
Oracle Application Framework functionality does not support data groups.
For almost all cases, you should accept the default value in defining a responsibility.

3. Function and Menu Exclusions (Optional)
A responsibility may optionally have function and menu exclusion rules associated with it to restrict the application functionality enabled for that responsibility

4. Responsibilities and Request Security Groups
Note: The Request Security Groups feature is for backward compatibility only.
When a request group is assigned to a responsibility, it becomes a request security group.
From a standard submission form, such as the Submit Requests form, the choice of concurrent programs and request sets to run are those in the user's responsibility's request security group.  If you do not include the Submit Requests form on the menu for a responsibility, then you do not need to assign a request security group to the responsibility.

Responsibilities and Function Security
Oracle Applications architecture may aggregate several related business functions into a single form. Parts of an application's functionality may be identified as individual Oracle Applications functions, which can then be secured (i.e. included or excluded from a responsibility).