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;

SELECT r.responsibility_name,r.responsibility_key, fa.APPLICATION_SHORT_NAME, r.version, u.user_name, u.description, r.start_date, r.end_date
    FROM apps_fnd.fnd_user_v u,
    apps_fnd.fnd_user_resp_groups 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

SELECT r.responsibility_name,r.responsibility_key, fa.APPLICATION_SHORT_NAME, r.version, u.user_name, u.description
    FROM apps_fnd.fnd_user_v u,
    apps_fnd.fnd_user_resp_groups 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

SELECT r.responsibility_name,r.responsibility_key, fa.APPLICATION_SHORT_NAME, r.version, u.user_name, u.description
    FROM apps_fnd.fnd_user_v u,
    apps_fnd.fnd_user_resp_groups 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

SELECT  r.responsibility_name,r.responsibility_key, fa.APPLICATION_SHORT_NAME, r.version
    FROM apps_fnd.fnd_user_v u,
         apps_fnd.fnd_user_resp_groups 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)
ORDER BY 1

SELECT r.responsibility_key, fa.APPLICATION_SHORT_NAME, r.version
    FROM apps_fnd.fnd_user_v u,
         apps_fnd.fnd_user_resp_groups ur,
         fnd_responsibility 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)
ORDER BY 1

SELECT r.responsibility_key, fa.APPLICATION_SHORT_NAME
    FROM fnd_user u,
         fnd_user_resp_groups ur,
         fnd_responsibility r,
         fnd_application_tl a,
         fnd_application fa
   WHERE     r.version = 'W'
         AND 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)
ORDER BY 1

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.

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

sql, Oracle

PL/SQL