Find responsibility name of a program

 Use below query to find the responsibility of a concurrent program

Select fcpt.user_concurrent_program_name,

frg.request_group_name,

frt.responsibility_name

From apps.fnd_Responsibility fr,

apps.fnd_responsibility_tl frt,

apps.fnd_request_groups frg,

apps.fnd_request_group_units frgu,

apps.fnd_concurrent_programs_tl fcpt

Where fcpt.user_concurrent_program_name =  <Insert Program name here>

and fcpt.concurrent_program_id = frgu.request_unit_id

and frgu.request_group_id = frg.request_group_id

and frg.request_group_id = fr.request_group_id

and fr.responsibility_id = frt.responsibility_id

Order By 2

;