Oracle R12 - Security Users, Roles, Responsibilities, Menu and Functions

Oracle R12 -- List of Users
select * from applsys.fnd_user;

Oracle R12 -- List of Roles
SELECT wf.NAME code,    wf.orig_system,  wf.display_name griddata,
    DECODE(SIGN(SYSDATE - NVL(wf.start_date,SYSDATE - 1)),1,DECODE(SIGN(NVL(wf.expiration_date,SYSDATE + 1) - SYSDATE),1,'ACTIVE', 'INACTIVE'), -1,'INACTIVE', 'ACTIVE') status,
    cat.category_lookup_code category_code,
    DECODE(umx_access_roles_pvt.Hierarchyenabled(wf.orig_system),'Y','AddChildRoleAction', '') add_switcher,
    fa.application_name,
    wf.owner_tag,
    wf.partition_id
  FROM wf_all_role_lov_vl wf,  umx_role_categories_v cat,  fnd_application_vl fa
  WHERE wf.NAME      = cat.wf_role_name (+)
  AND wf.owner_tag   = fa.application_short_name (+)
  AND ( (orig_system  = '')
  OR (orig_system     = 'UMX'))--'UMX') )
  AND ( partition_id IN (2,13))
order by 3;

Oracle R12 -- List of Responsibilities
SELECT wf.NAME code,  wf.orig_system,   wf.display_name griddata,
    DECODE(SIGN(SYSDATE - NVL(wf.start_date,SYSDATE - 1)),1,DECODE(SIGN(NVL(wf.expiration_date,SYSDATE + 1) - SYSDATE),1,'ACTIVE', 'INACTIVE'), -1,'INACTIVE', 'ACTIVE') status,
    cat.category_lookup_code category_code,
    DECODE(umx_access_roles_pvt.Hierarchyenabled(wf.orig_system),'Y','AddChildRoleAction', '') add_switcher,
    fa.application_name,
    wf.owner_tag,
    wf.partition_id
  FROM wf_all_role_lov_vl wf,  umx_role_categories_v cat,  fnd_application_vl fa
  WHERE wf.NAME      = cat.wf_role_name (+)
  AND wf.owner_tag   = fa.application_short_name (+)
AND ( (orig_system  = 'FND_RESP')
OR (orig_system     = ''))--'UMX') )
AND ( partition_id IN (2,13))
order by 3;

Oracle R12 -- List of Menus
SELECT menu_id, menu_name, user_menu_name,  description, last_update_date, type
  FROM apps.fnd_menus_vl
  WHERE (type IS NULL)
  OR (type    <>'SECURITY')
ORDER BY USER_MENU_NAME ASC;


Oracle R12 -- List of --Functions/Entitlements
SELECT FunctionEO.function_id,
  FunctionEO.function_name,
  FunctionEO.user_function_name,
  FunctionEO.type,
  FunctionEO.description,
  FunctionEO.creation_date,
  FunctionEO.last_update_date,
  FunctionEO.web_host_name,
  FunctionEO.web_agent_name,
  FunctionEO.web_html_call,
  FunctionEO.web_encrypt_parameters,
  FunctionEO.web_secured,
  FunctionEO.web_icon,
  FunctionEO.application_id,
  FunctionEO.form_id,
  FunctionEO.parameters,
  FunctionEO.object_id,
  FunctionEO.region_application_id,
  FunctionEO.region_code,
  FunctionEO.maintenance_mode_support,
  FunctionEO.context_dependence,
  FunctionEO.jrad_ref_path,
  a.application_name,
  f.user_form_name,
  o.display_name,
  a2.application_name AS RegionApplication
FROM apps.fnd_form_functions_vl FunctionEO,
  apps.fnd_application_vl a, apps.fnd_application_vl a2,
  apps.fnd_form_vl f,  apps.fnd_objects_vl o
WHERE 1=1
AND FunctionEO.application_id        = a.application_id(+)
AND FunctionEO.region_application_id = a2.application_id(+)
AND FunctionEO.form_id               = f.form_id(+)
AND FunctionEO.object_id             = o.object_id(+);

Oracle R12 -- List of --Users to Roles
select * from   APPLSYS.wf_user_role_assignments
where  1=1
AND ROLE_NAME = ASSIGNING_ROLE
AND ROLE_ORIG_SYSTEM = 'UMX'

Oracle R12 -- List of --Users to Responsibilities
select * from   APPLSYS.wf_user_role_assignments
where  1=1
AND ROLE_NAME = ASSIGNING_ROLE
AND ROLE_ORIG_SYSTEM = 'FND_RESP';

Oracle R12 -- List of --Roles to Responsibilities


Oracle R12 -- List of --Responsibilities to Menus
SELECT * FROM APPLSYS.FND_RESPONSIBILITY;

Oracle R12 -- List of --Menus to Functions
select * from apps.FND_MENU_ENTRIES_VL ;