Tuesday, August 11, 2015

Query to find Oracle Users having access to a responsibility

SELECT fu.user_name,
       frt.responsibility_name,
       furg.start_date resp_start_date,
       furg.end_date resp_end_date
  FROM apps.fnd_user_resp_groups furg,
       apps.fnd_responsibility fr,
       apps.fnd_responsibility_tl frt,
       apps.fnd_user fu
 WHERE     1 = 1
       AND fu.user_id = furg.user_id
       AND furg.responsibility_id = fr.responsibility_id
       AND frt.responsibility_id = fr.responsibility_id
       AND frt.responsibility_name LIKE 'XXX Resp Name%'
       order by frt.responsibility_name,fu.user_name

No comments:

Post a Comment

Unix commands to get the count of files

 ls -l *.rdf | wc -l