select r.responsibility_name "Job Function Name",
fd.user_function_name "Task Name",
a.application_name "Application Name"
from apps.fnd_application_vl a,
apps.fnd_responsibility_vl r,
apps.fnd_menus_vl m,
apps.fnd_menu_entries_vl f,
apps.fnd_form_functions_vl fd
where a.application_id = r.application_id
and r.created_by = 1
and r.end_date is null
and r.menu_id = m.menu_id
and m.menu_id = f.menu_id
and f.function_id = fd.function_id
and r.responsibility_name in (select frtl.responsibility_name
from apps.fnd_responsibility_tl frtl, apps.fnd_user_resp_groups furg,
apps.fnd_user fu where furg.responsibility_id = frtl.responsibility_id
and furg.responsibility_application_id = frtl.application_id
and furg.start_date <=sysdate
and nvl(furg.end_date,sysdate) >=sysdate
and frtl.language = 'US'
and furg.user_id = fu.user_id
and fu.user_name='&User');