ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 6690A48EEF6E792EE0530100007F7BFDY select fpov.profile_option_name profile_name, fav.application_name application, fpov.user_profile_option_name user_profile_name, fpov.description, &display_value fnd_profile.value(fpov.profile_option_name) value, xxen_util.meaning(fpov.hierarchy_type,'PROFILE_OPTION_HIERARCHIES',0) hierarchy_type, xxen_util.yes(fpov.user_visible_flag) user_access_visible, xxen_util.yes(fpov.user_changeable_flag) user_access_updatable, xxen_util.yes(fpov.site_enabled_flag) site_visible, xxen_util.yes(fpov.site_update_allowed_flag) site_updatable, xxen_util.yes(fpov.app_enabled_flag) application_visible, xxen_util.yes(fpov.app_update_allowed_flag) application_updatable, xxen_util.yes(fpov.resp_enabled_flag) responsibility_visible, xxen_util.yes(fpov.resp_update_allowed_flag) responsibility_updatable, xxen_util.yes(fpov.server_enabled_flag) server_visible, xxen_util.yes(fpov.server_update_allowed_flag) server_updatable, xxen_util.yes(fpov.serverresp_enabled_flag) serverresp_visible, xxen_util.yes(fpov.serverresp_update_allowed_flag) serverresp_updatable, xxen_util.yes(fpov.org_enabled_flag) organization_visible, xxen_util.yes(fpov.org_update_allowed_flag) organization_updatable, xxen_util.yes(fpov.user_enabled_flag) user_visible, xxen_util.yes(fpov.user_update_allowed_flag) user_updatable, fpov.sql_validation, fpov.start_date_active, fpov.end_date_active, xxen_util.user_name(fpov.created_by) created_by, xxen_util.client_time(fpov.creation_date) creation_date, xxen_util.user_name(fpov.last_updated_by) last_updated_by, xxen_util.client_time(fpov.last_update_date) last_update_date from fnd_profile_options_vl fpov, fnd_application_vl fav where 1=1 and fpov.application_id=fav.application_id order by fpov.profile_option_name AR FND Profile Options تعريف خيار الملف الشخصي FND D FND Profile Options Definition der FND-Profiloption E FND Profile Options Definición de la opción del perfil FND F FND Profile Options Définition de l'option de profil FND I FND Profile Options Definizione delle opzioni del profilo FND JA FND Profile Options FNDプロファイルオプション定義 KO FND Profile Options FND 프로파일 옵션 정의 PTB FND Profile Options Definição da opção de perfil FND RU FND Profile Options Определение профиля FND S FND Profile Options Definition av FND-profilalternativ TR FND Profile Options FND profil seçeneği tanımı US FND Profile Options FND profile option definition ZHS FND Profile Options FND配置文件选项定义 Enginatics &display_value 1=1 1 10 1=1 upper(fpov.user_profile_option_name) like upper(:user_profile_option_name)||'%' LOV FND User Profile Name 8E2FF36EDEF679D2E0530100007F1FF2 select fpov.user_profile_option_name value, fpov.profile_option_name description from fnd_profile_options_vl fpov order by fpov.user_profile_option_name F Le nom du profil de l'utilisateur commence par US User Profile Name starts with 2 20 1=1 fpov.profile_option_name like upper(:profile_option_name)||'%' LOV FND System Profile Name 8E2FF36EDEF579D2E0530100007F1FF2 select fpov.profile_option_name value, fpov.user_profile_option_name description from fnd_profile_options_vl fpov order by fpov.profile_option_name F Le nom du profil du système commence par US System Profile Name starts with 3 30 1=1 fav.application_name=:application_name LOV FND Application Name 8E2FF36EDE9879D2E0530100007F1FF2 Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US Application 4 40 1=1 fpov.creation_date>=:creation_date Date US Creation Date From 5 100 1=1 trunc(sysdate) between fpov.start_date_active and nvl(fpov.end_date_active,sysdate) LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y F Afficher uniquement les actifs US Show active only 6 110 &display_value xxen_util.display_profile_option_value(fpov.application_id,fpov.profile_option_id,fnd_profile.value(fpov.profile_option_name)) display_value, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Display Value