Query to find Request set attached to responsibility in oracle apps

Hi Friends, we are going to discuss about the Query to find Request set attached to responsibility in oracle apps. We will share the detail sql query to extract the request set and to which responsibility it attached. We will get the responsibility wise request set details in the query. We will also try to share the important tables which helps to store the responsibilities and its attached request set information's. This is one of the useful sql query to extract the responsibility and the request set attached. Using this query , we can develop the custom report which helps to provide the responsibility and its attached request sets. Please find below the complete detail about the Query to find Request set attached to responsibility in oracle apps

Query to find Request set attached to responsibility in oracle apps

Important tables used in the Query to find Request set attached to responsibility in oracle apps

 1.fnd_responsibility

 2.fnd_responsibility_tl

 3.fnd_request_groups

 4.fnd_request_group_units

 5.fnd_request_sets_vl 

Detail SQL Query to find Request set attached to responsibility in oracle apps

Here below is the detail sql query to find the request set attached to which responsibility in oracle

SELECT DISTINCT frt.responsibility_name,

   frg.request_group_name,

   frsv.user_request_set_name,

   frsv.request_set_name

         FROM fnd_responsibility fr,

              fnd_responsibility_tl frt,

              fnd_request_groups frg,

              fnd_request_group_units frgu,

              fnd_request_sets_vl frsv

        WHERE fr.request_group_id = frg.request_group_id

          AND fr.responsibility_id = frt.responsibility_id

          AND frg.request_group_id = frgu.request_group_id

          AND frgu.request_unit_id = frsv.request_set_id

          AND frsv.request_set_name=:P_REQUEST_SET_NAME

Query to find Request set attached to responsibility in oracle apps

Query to find Request set attached to responsibility in oracle apps