SQL Query to list out Responsibilities assigned to a Request Group

By | August 17, 2011
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;
WOW! Did you like this post? We'll send more interesting posts like SQL Query to list out Responsibilities assigned to a Request Group to you!
Enter your Email Address: