advanced code snippet search

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.

Expand | Embed | Plain Text 
  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.     WHERE
  8.     ur .responsibility_id = r.responsibility_id
  9.     AND u.user_id = ur.user_id
  10.     AND fa.APPLICATION_ID = a.APPLICATION_ID
  11.     AND r.application_id = a.application_id
  12.     AND ( u.user_name = UPPER (:user_name) OR UPPER(u.description) LIKE UPPER('%'||:user_name||'%'))
  13.     ORDER BY 5,3,2,1

Report this snippet  

You need to login to post a comment.