To get report responsibility

SELECT DISTINCT

fcpt.user_concurrent_program_name,

frg.request_group_name,

fcp.concurrent_program_name,

frt.responsibility_name,

fat.application_name

FROM
fnd_request_group_units frgu,

fnd_concurrent_programs fcp,

fnd_concurrent_programs_tl fcpt,

fnd_request_groups frg,

fnd_executables fe,

fnd_responsibility fr,

fnd_responsibility_tl frt,
fnd_application_tl fat

WHERE 1 = 1

AND fat.application_id = frgu.application_id

AND frgu.request_unit_id = fcp.concurrent_program_id

AND frgu.request_group_id = frg.request_group_id

AND fe.executable_id = fcp.executable_id

AND fcp.concurrent_program_id = fcpt.concurrent_program_id

AND frg.request_group_id = fr.request_group_id

AND fr.responsibility_id = frt.responsibility_id

AND fcpt.user_concurrent_program_name like '&Report Name'

;