Query to fetch Responsibilities attached to a User

The below query will fetch the responsibilities assigned to a particular user.
SELECT
    fu.user_id,
    fu.user_name,
    fr.responsibility_name,
    fr.description,
    fa.application_name
FROM fnd_user fu,
     fnd_user_resp_groups g,
     fnd_application_tl fa,
     fnd_responsibility_tl fr
WHERE
     g.user_id(+) = fu.user_id
     AND g.responsibility_application_id = fa.application_id
     AND fa.application_id = fr.application_id
     AND g.responsibility_id = fr.responsibility_id
     AND fu.user_name  =UPPER('User_Name');

How To Add More Detailed Information In FYI Notifications for Users to See Transaction Details In Self Service

How can users see the Transactional Details in FYI notifications in Self Service?

SOLUTION

Notification recipients can view transaction changes on the FYI Notification page after transactions are either approved or rejected.
The system administrator must add the parameter &pNtfFyiDetails=Y  to the _SS functions.

1. System Administrator responsibility
2. Application > Function
3. Add &pNtfFyiDetails=Y into form parameters after the &pCalledFrom=<FUNCTION>.
4. Save

If this parameter is set to Y, then the FYI Notification page displays a Details region with the Proposed column and a Supporting Documents region.

If any attachments are added to a transaction's Review page, then these attachments appear as a link on the FYI Notification page.
For example, after a manager approves a leave of absence transaction, the recipient who receives the FYI notification can view the absence details that have been approved. The recipient need not navigate to the relevant self-service pages in the application to understand the changes that have been approved.