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 A30B566296EA7049E0530100007F123E FND Language Code Y select flv.language_code value, flv.description||decode(flv.installed_flag,'B',' (base language)') description from fnd_languages_vl flv where flv.installed_flag in ('I','B') order by flv.installed_flag, flv.language_code 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. 702BF2E844B7178CE053F400140A2D98 select fav.application_name view_application, flv.lookup_type, fltv.description type_description, flv.lookup_code code, flv.language, flv.source_lang source_language, flv.meaning, flv.description, flv.tag, xxen_util.meaning(flv.enabled_flag,'YES_NO',0) enabled_flag, flv.start_date_active, flv.end_date_active, xxen_util.user_name(flv.created_by) created_by, xxen_util.client_time(flv.creation_date) creation_date, xxen_util.user_name(flv.last_updated_by) last_updated_by, xxen_util.client_time(flv.last_update_date) last_update_date, 'xxen_util.meaning(x.'||lower(flv.lookup_type)||','''||flv.lookup_type||''','||flv.view_application_id||') '||lower(flv.lookup_type)||',' sql_text, 'select flvv.lookup_code, flvv.meaning, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type(+)='''||flv.lookup_type||''' and flvv.view_application_id(+)='||flv.view_application_id||' and flvv.security_group_id(+)=0 order by flvv.lookup_code' lookup_values from fnd_application_vl fav0, fnd_application_vl fav, fnd_lookup_types_vl fltv, fnd_lookup_values flv, fnd_languages fl where 1=1 and fav0.application_id=fltv.application_id and fav.application_id=flv.view_application_id and fltv.lookup_type=flv.lookup_type and fltv.view_application_id=flv.view_application_id and flv.security_group_id=0 and flv.language=fl.language_code order by flv.lookup_type, flv.lookup_code, fl.installed_flag, flv.language Y AR FND Lookup Values أنواع وقيم البحث ، على سبيل المثال للعثور على نوع بحث لقيمة أو معنى كود بحث معين. D FND Lookup Values Nachschlagetypen und -werte, z. B. um einen Nachschlagetyp für einen bestimmten Nachschlagecodewert oder eine Bedeutung zu finden. E FND Lookup Values Tipos y valores de búsqueda, por ejemplo, para encontrar un tipo de búsqueda para un valor o significado de código de búsqueda concreto. F FND Lookup Values Types et valeurs de recherche, par exemple pour trouver un type de recherche pour une valeur ou une signification particulière du code de recherche. I FND Lookup Values Tipi e valori di lookup, per esempio per trovare un tipo di lookup per un particolare valore o significato del codice di lookup. JA FND Lookup Values ルックアップ型と値、例えば、特定のルックアップコードの値や意味のルックアップ型を見つけるために。 KO FND Lookup Values 예를 들어 특정 룩업 코드 값 또는 의미에 대한 룩업 유형을 찾기위한 룩업 유형 및 값. PTB FND Lookup Values Tipos e valores de pesquisa, por exemplo, para encontrar um tipo de pesquisa para um determinado valor ou significado de código de pesquisa. RU FND Lookup Values Типы и значения поиска, например, чтобы найти тип поиска для определенного значения или значения кода поиска. S FND Lookup Values Sökningstyper och värden, till exempel för att hitta en uppslagstyp för ett visst uppslagskodvärde eller betydelse. TR FND Lookup Values Arama türleri ve değerleri, örneğin belirli bir arama kodu değeri veya anlamı için bir arama türü bulmak için. US FND Lookup Values Lookup types and values, for example to find a lookup type for a particular lookup code value or meaning. ZHS FND Lookup Values 查找类型和值，例如为特定的查找代码值或意义查找查找类型。 Enginatics 1=1 1 10 1=1 flv.lookup_type=:lookup_type LOV custom Y select fltv.lookup_type value, fav.application_name||': '||nvl(fltv.description,fltv.meaning) description from fnd_application_vl fav, fnd_lookup_types_vl fltv where fav.application_id=fltv.application_id order by fltv.lookup_type US Type 2 20 1=1 fav.application_name=:view_application 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 View Application 3 30 1=1 upper(flv.lookup_code) like '%'||upper(:lookup_code)||'%' LOV custom Y select distinct flvv.lookup_code value, flvv.meaning description from fnd_lookup_values_vl flvv where (:$flex$.type is null or xxen_util.contains(:$flex$.type,flvv.lookup_type)='Y') and flvv.security_group_id=0 order by flvv.lookup_code F Le code contient US Code contains 4 40 1=1 upper(flv.meaning) like '%'||upper(:meaning)||'%' LOV custom Y select distinct flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.security_group_id=0 order by flvv.meaning F La signification contient US Meaning contains 5 50 1=1 upper(flv.description) like '%'||upper(:description)||'%' Char F La description contient US Description contains 6 60 1=1 flv.creation_date>=:creation_date_from Date F Date de création du US Creation Date From 7 70 1=1 flv.creation_date<:creation_date_to+1 Date F Date de création au US Creation Date To 8 80 1=1 flv.created_by=xxen_util.user_id(:created_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 Créé par US Created By 9 90 1=1 flv.language=:language LOV FND Language Code A30B566296EA7049E0530100007F123E Y select flv.language_code value, flv.description||decode(flv.installed_flag,'B',' (base language)') description from fnd_languages_vl flv where flv.installed_flag in ('I','B') order by flv.installed_flag, flv.language_code userenv('lang') F Code de la langue US Language Code 10 100 1=1 not exists (select null from fnd_lookup_values flv2 where flv.lookup_type=flv2.lookup_type and flv.lookup_code=flv2.lookup_code and flv.view_application_id=flv2.view_application_id and flv.security_group_id=flv2.security_group_id and flv2.language=:missing_language and flv2.source_lang=:missing_language ) LOV FND Language Code A30B566296EA7049E0530100007F123E Y select flv.language_code value, flv.description||decode(flv.installed_flag,'B',' (base language)') description from fnd_languages_vl flv where flv.installed_flag in ('I','B') order by flv.installed_flag, flv.language_code F Traduction manquante vers le code de langue US Missing Translation to Lang Code :$flex$.type Type Code contains