FND User Preferences

Description

Categories
Enginatics
Repository
GitHub
User preferences from table fnd_user_preferences

SQL 13 lines

select
fup.user_name,
fup.module_name,
fup.preference_name,
fup.preference_value
from
fnd_user_preferences fup
where
1=1
order by
fup.user_name,
fup.module_name,
fup.preference_name

Parameters 3

ParameterTypeList of values SQL
User NameLOV
fup.user_name=:user_name
Module NameLOV
fup.module_name=:module_name
Preference NameLOV
fup.preference_name=:preference_name