Tuesday, September 10, 2013

Query to list out Responsibilities assigned to a Request Group

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 '%'
--AND responsibility_name LIKE '%'
ORDER BY request_group_name,
responsibility_name

No comments:

Post a Comment

Oracle Database & Applications R12.2 Log file locations

Many times, we forget the path for the log files since there are too many.  Below is the list of frequently used log files which can help us...