AOL : Query to fetch responsibilities attached to a User

 Query to fetch the responsibilities attached to a FND_USER login.

SELECT t.responsibility_id,

       t.responsibility_name,

       v.RESPONSIBILITY_KEY,

       (select (fa.APPLICATION_SHORT_NAME ||' - '|| fa.APPLICATION_NAME) application_name

          from fnd_application_vl fa

         where fa.APPLICATION_ID = t.application_id) application_name

  FROM FND_RESPONSIBILITY_TL t, fnd_responsibility_vl v

 WHERE t.RESPONSIBILITY_ID IN

       (SELECT RESPONSIBILITY_ID

          FROM FND_USER_RESP_GROUPS

         WHERE USER_ID IN (SELECT USER_ID

                             FROM FND_USER

                            WHERE USER_NAME = 'FNDUSERNAME'))

   and v.RESPONSIBILITY_ID = t.responsibility_id;