To get list of responsibilities.

SELECT (SELECT application_short_name

FROMfnd_application fa

WHERE fa.application_id = frt.application_id) application,

frt.responsibility_id, frt.responsibility_name

FROM apps.fnd_responsibility_tl frt;