SQL Query to list out Responsibilities assigned to a Request Group

1
2
3
4
5
6
7
8
9
10
11
12
13
14

/**************************************************************************
 *PURPOSE: To list out Responsibilities assigned to a Request Group       *
 *PARAMETERS: Responsibility Name (or) Request Group Name                 *
 *AUTHOR: Shailender Thallam                                              *
 **************************************************************************/
 SELECT responsibility_name ,
  request_group_name        ,
  frg.description
   FROM fnd_request_groups frg,
  fnd_responsibility_vl frv
  WHERE frv.request_group_id = frg.request_group_id
  --AND request_group_name LIKE 'US SHRMS Reports % Processes'
AND responsibility_name LIKE 'Benefits Administrator'
ORDER BY responsibility_name;

/************************************************************************** *PURPOSE: To list out Responsibilities assigned to a Request Group * *PARAMETERS: Responsibility Name (or) Request Group Name * *AUTHOR: Shailender Thallam * **************************************************************************/ SELECT responsibility_name , request_group_name , frg.description FROM fnd_request_groups frg, fnd_responsibility_vl frv WHERE frv.request_group_id = frg.request_group_id --AND request_group_name LIKE 'US SHRMS Reports % Processes' AND responsibility_name LIKE 'Benefits Administrator' ORDER BY responsibility_name;