Posted By

theonlyalterego on 05/26/11


Tagged

sql Oracle PLSQL OAF


Versions (?)

Oracle Application - List Responsibilities and Responsibility Keys that are assigned to a user


 / Published in: PL/SQL
 

URL: http://forums.oracle.com/forums/thread.jspa?threadID=953780

I found this today and it's very useful for finding the responsibility key when trying ot run OAF from JDev.

  1. SELECT r.responsibility_name,r.responsibility_key, fa.APPLICATION_SHORT_NAME, r.version, u.user_name, u.description, r.start_date, r.end_date
  2. FROM apps_fnd.fnd_user_v u,
  3. apps_fnd.fnd_user_resp_groups ur,
  4. fnd_responsibility_vl r,
  5. fnd_application_tl a,
  6. fnd_application fa
  7. ur .responsibility_id = r.responsibility_id
  8. AND u.user_id = ur.user_id
  9. AND fa.APPLICATION_ID = a.APPLICATION_ID
  10. AND r.application_id = a.application_id
  11. AND ( u.user_name = UPPER (:user_name) OR UPPER(u.description) LIKE UPPER('%'||:user_name||'%'))
  12. ORDER BY 5,3,2,1

Report this snippet  

You need to login to post a comment.