Reports2017-11-18T12:27:27+00:00

FND User Login Page Favorites

Description
Categories: Application, Enginatics
User's HTML favourites from table icx_custom_menu_entries

select
xxen_util.user_name(icme.user_id) user_name,
frv.responsibility_name responsibility,
icme.display_sequence,
icme.prompt,
icme.url,
nvl(xxen_util.meaning(fffv.type,'FORM_FUNCTION_TYPE',0),icme.function_type) type,
fffv.user_function_name,
fffv.function_name
from
icx_custom_menu_entries icme,
fnd_responsibility_vl frv,
fnd_form_functions_vl fffv
where
1=1 and
icme.responsibility_id=frv.responsibility_id(+) and
icme.responsibility_application_id=frv.application_id(+) and
icme.function_id=fffv.function_id(+)
order by
user_name,
icme.display_sequence

Parameter Name SQL text Validation
User Name
icme.user_id in (select fu.user_id from fnd_user fu where fu.user_name=:user_name)
LOV

By continuing to use the site, you agree to the use of cookies. Accept