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

SQL Query to Find Oracle Web ADI Importer Package Procedure Name

 SELECT ba.attribute2     wed_adi_package_procedure_name   FROM apps.bne_attributes      ba,        apps.bne_param_lists_b   bplb,        ap...