Find Responsibility_Name using Concurrent_program_name

Overview:

    Using below script you will get Responsibility Name and Request Group Name using Concurrent Program Name.

SELECT frt.responsibility_name

     , fcpt.user_concurrent_program_name

     , frg.request_group_name

FROM   fnd_Responsibility fr

     , fnd_responsibility_tl frt

     , fnd_request_groups frg

     , fnd_request_group_units frgu

     , fnd_concurrent_programs_tl fcpt

WHERE  frt.responsibility_id       = fr.responsibility_id

  AND frg.request_group_id          = fr.request_group_id

  AND frgu.request_group_id        = frg.request_group_id

  AND fcpt.concurrent_program_id = frgu.request_unit_id

  AND frt.LANGUAGE                   = USERENV('LANG')

  AND fcpt.LANGUAGE                 = USERENV('LANG')

  AND fcpt.user_concurrent_program_name = 'Application developer';