Querty to Get responsibility details

To get details of responsibility
=====================
select ff.form_name,
       fff.USER_FUNCTION_NAME,
       fme.PROMPT,
       fm.MENU_NAME,
       frt.RESPONSIBILITY_NAME
from   fnd_responsibility       fr,
       fnd_responsibility_tl    frt,
       fnd_menus_vl             fm,
       fnd_menu_entries_vl      fme,
       FND_FORM_FUNCTIONS_VL    fff,
       FND_FORM_VL              ff
where  1=1
and    fr.responsibility_id = frt.responsibility_id
and    frt.RESPONSIBILITY_NAME = :RESPONSIBILITY_NAME -- ' Custom Responsibility' 
and    frt.language = 'US'     
--
and    fr.menu_id = fm.menu_id
and    fm.menu_id = fme.menu_id
--
and    fme.function_id  = fff.function_id
--
and    fff.form_id      = ff.form_id


Eg:

FORM_NAME

USER_FUNCTION_NAME

PROMPT

MENU_NAME

RESPONSIBILITY_NAME

Another query
===========

SELECT ffm.FORM_NAME,ffm.USER_FORM_NAME,ff.FUNCTION_NAME,ff.USER_FUNCTION_NAME

  FROM FND_responsibility_vl fr,

       FND_MENUS fm,

       FND_COMPILED_MENU_FUNCTIONS fmf,

       fnd_Form_functions_vl ff,

       FND_FORM_VL ffm

WHERE     fr.menu_id = fm.menu_id

       AND ff.function_id = fmf.function_id

       AND fmf.menu_id = fm.menu_id

       AND FF.form_id=ffm.form_id

       AND fmf.GRANT_FLAG = 'Y'

       --AND ff.FUNCTION_NAME like 'AR_ARXRWMAI_HEADER'

       AND fr.responsibility_name='Application Developer'

Another script for to get concurrent programs list attached to responsibility
==============================================================================

RESPONSIBILITY_NAME

REQUEST_GROUP_NAME

USER_CONCURRENT_PROGRAM_NAME

PROGRAM_TYPE

APPLICATION_NAME

select   responsibility_name, request_group_name,user_concurrent_program_name,

         decode(c.request_unit_type,'P','Program','S','Set','A','Application',c.request_unit_type)program_type,

         e.application_name

from     fnd_responsibility_vl          a ,

         fnd_request_groups             b,

         fnd_request_group_units        c,

         fnd_concurrent_programs_tl     d,

         fnd_application_tl             e

where    1=1

and      a.request_group_id = b.request_group_id

and      b.request_group_id = c.request_group_id

--

and      c.request_unit_id   = d.concurrent_program_id

and      d.LANGUAGE = 'US'

--

and      d.application_id    = e.application_id

and      e.LANGUAGE = 'US'

and      responsibility_name = :resp_name

 

Script to get function attached to responsibilities.

===================================================

SELECT DISTINCT responsibility_id, responsibility_name
    FROM apps.fnd_responsibility_vl a
   WHERE     a.end_date IS NULL
         AND a.menu_id IN
                (    SELECT menu_id
                       FROM apps.fnd_menu_entries_vl
                 START WITH menu_id IN
                               (SELECT menu_id
                                  FROM apps.fnd_menu_entries_vl
                                 WHERE function_id IN
                                          (SELECT function_id
                                             FROM applsys.fnd_form_functions a
                                            WHERE function_name =
                                                     :pc_function_name))
                 CONNECT BY PRIOR menu_id = sub_menu_id)
         AND a.responsibility_id NOT IN
                (SELECT responsibility_id
                   FROM apps.fnd_responsibility_vl
                  WHERE responsibility_id IN
                           (SELECT responsibility_id
                              FROM applsys.fnd_resp_functions resp
                             WHERE action_id IN
                                      (SELECT function_id
                                         FROM applsys.fnd_form_functions a
                                        WHERE function_name = :pc_function_name)))
         AND a.responsibility_id NOT IN
                (SELECT responsibility_id
                   FROM apps.fnd_responsibility_vl
                  WHERE responsibility_id IN
                           (SELECT responsibility_id
                              FROM applsys.fnd_resp_functions resp
                             WHERE action_id IN
                                      (    SELECT menu_id
                                             FROM apps.fnd_menu_entries_vl
                                       START WITH menu_id IN
                                                     (SELECT menu_id
                                                        FROM apps.fnd_menu_entries_vl
                                                       WHERE function_id IN
                                                                (SELECT function_id
                                                                   FROM applsys.fnd_form_functions a
                                                                  WHERE function_name =
                                                                           :pc_function_name))
                                       CONNECT BY PRIOR menu_id = sub_menu_id)))

ORDER BY responsibility_id

query to find responsibility name from form name.
===============================

SELECT responsibility_name

  FROM FND_responsibility_vl fr,

       FND_MENUS fm,

       FND_COMPILED_MENU_FUNCTIONS fmf,

       fnd_Form_functions_vl ff

WHERE     fr.menu_id = fm.menu_id

       AND ff.function_id = fmf.function_id

       AND fmf.menu_id = fm.menu_id

       --AND fmf.GRANT_FLAG = 'Y'

       AND ff.FUNCTION_NAME LIKE '%Form_name%'

Query to find logged in users in r12.
=======================
select last_connect, usr.user_name, resp.responsibility_key, function_type, icx.*
  from apps.icx_sessions icx
  join apps.fnd_user usr on usr.user_id=icx.user_id
  left join apps.fnd_responsibility resp on resp.responsibility_id=icx.responsibility_id
  where last_connect>sysdate-nvl(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'),30)/60/24

    and disabled_flag != 'Y' and pseudo_flag = 'N'