FND Profile Options

Description

Categories
Enginatics
Repository
GitHub
FND profile option definition

SQL 39 lines

Parameters 6

ParameterTypeList of values SQL
User Profile Name starts withLOV
upper(fpov.user_profile_option_name) like upper(:user_profile_option_name)||'%'
System Profile Name starts withLOV
fpov.profile_option_name like upper(:profile_option_name)||'%'
ApplicationLOV
fav.application_name=:application_name
Creation Date FromDate
fpov.creation_date>=:creation_date
Show active onlyLOV Oracle
trunc(sysdate) between fpov.start_date_active and nvl(fpov.end_date_active,sysdate)
Show Display ValueLOV
xxen_util.display_profile_option_value(fpov.application_id,fpov.profile_option_id,fnd_profile.value(fpov.profile_option_name)) display_value,