El siguiente query nos brinda información de que menús o funciones se han agregado por responsabilidad en la opción de exclusiones de Menú, esto nos puede servir para tener un control o un listado de que opciones se han quitado a cierta responsabilidad de acuerdo al perfil del usuario.
select res.responsibility_name responsabilidad,
app.application_name aplicacion,
res.responsibility_key
clave_responsabilidad,
decode(exc.rule_type,'F','Function','M', 'Menu',
rule_type)tipo_exclusion,
decode(exc.rule_type,'F',(select function_name || ',' || fnc.USER_FUNCTION_NAME
from fnd_form_functions_vl fnc
where fnc.function_id = exc.action_id
)
,'M',(select menu_name || ',' ||
imn.USER_MENU_NAME
from fnd_menus_vl imn
where imn.menu_id = exc.action_id
)
, to_char(exc.action_id)
) menu_funcion_excluida
from apps.fnd_responsibility_vl res
, apps.fnd_application_vl app
, apps.fnd_data_groups dat
, apps.fnd_menus_vl mnu
, apps.fnd_request_groups req
, apps.fnd_application_vl apd
, apps.fnd_application_vl apr
, apps.fnd_resp_functions exc
where res.application_id =
app.application_id
and res.data_group_id =
dat.data_group_id
and res.data_group_application_id = apd.application_id
and res.menu_id =
mnu.menu_id
and req.request_group_id =
res.request_group_id
and req.application_id =
res.group_application_id
and apr.application_id =
req.application_id
and exc.application_id =
res.application_id
and exc.responsibility_id =
res.responsibility_id
and res.responsibility_name ='&responsabilidad'
No hay comentarios:
Publicar un comentario