Queries To Know Form and Reports Responsibility

1. query to know form attached to which responsibility

 SELECT d.responsibility_name,bb.FORM_NAME fmx_name,c.FUNCTION_NAME function_name
FROM fnd_menu_entries a,
fnd_menu_entries_vl b,
fnd_form_functions c,
fnd_responsibility_vl d,
fnd_form bb
WHERE a.menu_id = b.menu_id
AND a.function_id = b.function_id
AND b.function_id = c.function_id
AND a.menu_id = d.menu_id
and bb.FORM_ID=c.FORM_ID
AND c.function_name = :function_name
and bb.FORM_NAME=:fmx_name

2. query to know request attached to which responsibility

SELECT fc.user_concurrent_program_name, fr.request_group_name,frv.APPLICATION_ID,fc.CONCURRENT_PROGRAM_NAME,

       frv.responsibility_name

  FROM fnd_request_groups fr,

       fnd_request_group_units frg,

       fnd_concurrent_programs_vl fc,

       fnd_responsibility_vl frv

 WHERE fr.request_group_id = frg.request_group_id

   AND frg.request_unit_id = fc.concurrent_program_id

   AND fr.request_group_id = frv.request_group_id

   AND fc.user_concurrent_program_name = 'REQUEST NAME'