Posted By

theonlyalterego on 05/26/11

Tagged

sql
Oracle

Versions (?)

Last Edited at 05/26/11 12:17am

Statistics

Viewed 1804 times

Favorited by 0 user(s)

Related snippets

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

/ Published in: PL/SQL

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

Copy this code and paste it in your HTML

SELECT r.responsibility_name,r.responsibility_key, fa.APPLICATION_SHORT_NAME, r.version, u.user_name, u.description, ur.start_date, ur.end_date
        FROM apps_fnd.fnd_user_v u,
        apps_fnd.fnd_user_resp_groups_direct ur,
        fnd_responsibility_vl r,
        fnd_application_tl a,
        fnd_application fa
        WHERE
        ur .responsibility_id = r.responsibility_id
        AND u.user_id = ur.user_id
        AND fa.APPLICATION_ID = a.APPLICATION_ID
        AND r.application_id = a.application_id
        AND ( u.user_name = UPPER (:user_name) OR UPPER(u.description) LIKE UPPER('%'||:user_name||'%'))
        ORDER BY 5,3,2,1;