ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9879D2E0530100007F1FF2 FND Application Name Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US 8E2FF36EDEBE79D2E0530100007F1FF2 FND Application Short Name Y select fav.application_short_name value, fav.application_name description from fnd_application_vl fav order by fav.application_short_name US 8E2FF36EDEF579D2E0530100007F1FF2 FND System Profile Name select fpov.profile_option_name value, fpov.user_profile_option_name description from fnd_profile_options_vl fpov order by fpov.profile_option_name US 8E2FF36EDE8479D2E0530100007F1FF2 FND User Name Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US FND user names, excluding iRecruitment candidates. 8E2FF36EDEF679D2E0530100007F1FF2 FND User Profile Name 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 US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 49A8B1A8038C08ACE0530100007FEB91 select fpo.user_profile_option_name, fav0.application_name, decode(fpov.level_id,10001,'Site',10002,'Application', 10003,'Responsibility', 10004,'User', 10005,'Server',10006,'Operating Unit', 10007,decode(to_char(fpov.level_value2),'-1','Responsibility',decode(to_char(fpov.level_value),'-1','Server','Server+Resp')) ) level_, decode(fpov.level_id,10001,null,10002,fav.application_name,10003,frv.responsibility_name,10004,xxen_util.user_name(decode(fpov.level_id,10004,fpov.level_value)),10005,fn.node_name,10006,haouv.name, 10007,decode(to_char(fpov.level_value2),'-1',frv.responsibility_name,decode(to_char(fpov.level_value),'-1',fn.node_name,fn.node_name||' - '||frv.responsibility_name)) ) level_name, xxen_util.display_profile_option_value(fpo.application_id,fpo.profile_option_id,fpov.profile_option_value) profile_option_value, fpov.profile_option_value system_profile_option_value, 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, fpo.profile_option_name system_profile_option_name, fpo.profile_option_id, fpov.level_value, fpov.level_value2 from fnd_application_vl fav0, fnd_profile_options_vl fpo, fnd_profile_option_values fpov, fnd_responsibility_vl frv, fnd_user fu, fnd_application_vl fav, hr_all_organization_units_vl haouv, fnd_nodes fn where 1=1 and fav0.application_id=fpo.application_id and fpo.profile_option_id=fpov.profile_option_id and fpo.application_id=fpov.application_id and decode(fpov.level_id,10002,fpov.level_value)=fav.application_id(+) and case when fpov.level_id in (10003,10007) then fpov.level_value end=frv.responsibility_id(+) and case when fpov.level_id in (10003,10007) then fpov.level_value_application_id end=frv.application_id(+) and decode(fpov.level_id,10004,fpov.level_value)=fu.user_id(+) and decode(fpov.level_id,10005,fpov.level_value,10007,fpov.level_value2)=fn.node_id(+) and decode(fpov.level_id,10006,fpov.level_value)=haouv.organization_id(+) order by fpo.user_profile_option_name, fpov.level_id, decode(fpov.level_id,10001,null,10002,fav.application_name, 10003,frv.responsibility_name, 10004,xxen_util.user_name(decode(fpov.level_id,10004,fpov.level_value)), 10005,fn.node_name,10006,haouv.name) Y :User_Profile_Name_starts_with is not null or :User_Profile_Name_any_lang is not null or :Setup_Level is not null or :Setup_Level_Value is not null or :Application_Name is not null or :Application_Short_Name is not null or :System_Profile_Name_starts_wi is not null or :Last_Update_Date_From is not null or :Last_Update_Date_To is not null or :Last_Updated_By is not null or :Profile_System_Value_like is not null or :Redundant is not null AR FND Profile Option Values قيم خيار الملف الشخصي على جميع مستويات الإعداد. بخلاف برنامج Oracle SQL النصي من الملاحظة 201945.1 ، يعرض هذا التقرير أيضًا قيمة خيار ملف تعريف المستخدم المرئي بالإضافة إلى قيمة خيار ملف تعريف النظام الداخلي. D FND Profile Option Values Profiloptionswerte auf allen Einrichtungsebenen. Im Gegensatz zum SQL-Skript von Oracle aus Hinweis 201945.1 zeigt dieser Bericht neben dem internen Systemprofiloptionswert auch den für den Benutzer sichtbaren Profiloptionswert an. E FND Profile Option Values Valores de opción de perfil en todos los niveles de configuración. A diferencia del script SQL de Oracle de la nota 201945.1, este informe también muestra el valor de la opción de perfil visible para el usuario, además del valor de la opción de perfil del sistema interno. F FND Profile Option Values Valeurs des options de profil à tous les niveaux de configuration. Contrairement au script SQL d'Oracle de la note 201945.1, ce rapport indique également la valeur d'option de profil visible par l'utilisateur en plus de la valeur d'option de profil du système interne. I FND Profile Option Values Valori delle opzioni del profilo su tutti i livelli di configurazione. A differenza dello script SQL di Oracle della nota 201945.1, questo rapporto mostra anche il valore dell'opzione del profilo visibile dall'utente oltre al valore dell'opzione del profilo interno del sistema. JA FND Profile Option Values すべてのセットアップ レベルのプロファイル オプション値 note 201945.1のオラクルのSQLスクリプトとは異なり、このレポートでは、内部システムのプロファイルオプション値に加えて、ユーザーが見えるプロファイルオプション値も表示されます。 KO FND Profile Option Values 모든 설정 수준의 프로필 옵션 값. 노트 201945.1의 Oracle SQL 스크립트와 달리이 보고서는 내부 시스템 프로필 옵션 값과 함께 사용자에게 표시되는 프로필 옵션 값도 표시합니다. PTB FND Profile Option Values Valores de opção de perfil em todos os níveis de configuração. Ao contrário do script SQL da Oracle da nota 201945.1, este relatório também mostra o valor da opção de perfil visível do usuário, além do valor da opção de perfil do sistema interno. RU FND Profile Option Values Значения опций профиля на всех уровнях настройки. В отличие от SQL-скрипта Oracle из примечания 201945.1, в этом отчете в дополнение к внутреннему значению опции системного профиля также отображается видимое пользователю значение опции профиля. S FND Profile Option Values Profilalternativ på alla installationsnivåer. Till skillnad från Oracles SQL-skript från noten 201945.1 visar den här rapporten också användarens synliga profilalternativvärde utöver det interna systemprofilalternativet. TR FND Profile Option Values Tüm kurulum seviyelerinde profil seçeneği değerleri. Oracle'ın 201945.1 notundaki SQL komut dosyasından farklı olarak, bu rapor ayrıca dahili sistem profili seçeneği değerine ek olarak kullanıcının gördüğü profil seçeneği değerini de gösterir. US FND Profile Option Values Profile option values on all setup levels. Unlike Oracle's SQL script from note 201945.1, this report also shows the user visible profile option value in addition to the internal system profile option value. ZHS FND Profile Option Values 所有设置级别的配置文件选项值。 与Oracle注201945.1的SQL脚本不同，该报告除了显示内部系统配置文件选项值外，还显示用户可见的配置文件选项值。 Enginatics 1=1 1 10 1=1 upper(fpo.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 fpo.profile_option_name in (select fpot.profile_option_name from fnd_profile_options_tl fpot where fpot.user_profile_option_name=:user_profile_name_any_lang) LOV custom Y select distinct fpot.user_profile_option_name value, fpot.profile_option_name||': '||fpot.language description from fnd_profile_options_tl fpot where fpot.user_profile_option_name is not null order by fpot.profile_option_name||': '||fpot.language F Nom du profil de l'utilisateur n'importe quelle langue US User Profile Name any lang 3 30 1=1 fpov.level_id=decode(:setup_level,'Site',10001,'Application',10002,'Responsibility',10003,'User',10004,'Server',10005,'Operating Unit',10006) LOV custom Y select 'Site' value, null description from dual union all select 'Application' value, null description from dual union all select 'Responsibility' value, null description from dual union all select 'User' value, null description from dual union all select 'Server' value, null description from dual union all select 'Operating Unit' value, null description from dual F Niveau de configuration US Setup Level 4 40 1=1 upper(decode(fpov.level_id,10002,fav.application_name, 10003,frv.responsibility_name, 10004,fu.user_name, 10005,'serverx',10006,haouv.name)) like upper(:setup_level_value) LOV custom Y select x.* from ( select fav.application_name value, 'APPLICATION: '||fav.application_short_name description from fnd_application_vl fav union all select hou.name value, 'OPERATING_UNIT' from hr_operating_units hou union all select frv.responsibility_name value, 'RESPONSIBILITY' description from fnd_responsibility_vl frv union all select fu.user_name value, 'USER'||nvl2(nvl(fu.description,fu.email_address),': '||nvl(fu.description,fu.email_address),null) description from fnd_user fu ) x where :$flex$.setup_level is null or x.description like upper(translate(:$flex$.setup_level,' ','_'))||'%' order by x.description, x.value F Valeur du niveau de paramétrage US Setup Level Value 5 50 1=1 fav0.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 F Nom de l'application US Application Name 6 60 1=1 fav0.application_short_name=:application_short_name LOV FND Application Short Name 8E2FF36EDEBE79D2E0530100007F1FF2 Y select fav.application_short_name value, fav.application_name description from fnd_application_vl fav order by fav.application_short_name F Nom court de l'application US Application Short Name 7 70 1=1 fpo.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 8 80 1=1 fpov.last_update_date>=:updated_from Date F Date de la dernière mise à jour du US Last Update Date From 9 90 1=1 fpov.last_update_date<:updated_to+1 Date F Date de la dernière mise à jour au US Last Update Date To 10 100 1=1 fpov.last_updated_by=xxen_util.user_id(:last_updated_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name F Dernière mise à jour par US Last Updated By 11 110 1=1 fpov.profile_option_value like :profile_option_value Char F Profil Système Valeur comme US Profile System Value like 12 120 1=1 fpov.level_id<>10001 and exists ( select null from fnd_profile_option_values fpov2 where fpov.profile_option_value=fpov2.profile_option_value and fpov.application_id=fpov2.application_id and fpov.profile_option_id=fpov2.profile_option_id and fpov2.level_id=10001 and fpov2.level_value=0 ) and 'Yes'=:redundant LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Redondant US Redundant :$flex$.setup_level Setup Level Setup Level Value