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 8E2FF36EDE8979D2E0530100007F1FF2 FND Table Name (wildcard) select ft.table_name value, fav.application_name description from fnd_tables ft, fnd_application_vl fav where ft.application_id=fav.application_id order by ft.table_name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 49A8B1A8036E08ACE0530100007FEB91 select fav.application_name application, fdfv.descriptive_flexfield_name flexfield_name, fdfv.title, fdfv.application_table_name table_name, fdfcv.descriptive_flex_context_code context_code, fdfcv.descriptive_flex_context_name context_name, fdfcv.description context_description, xxen_util.yes(fdfcv.enabled_flag) context_enabled, fdfcuv.column_seq_num seq_num, fdfcuv.form_left_prompt window_prompt, fdfcuv.application_column_name table_column, ffvs.flex_value_set_name value_set_name, xxen_util.yes(fdfcuv.enabled_flag) enabled, xxen_util.yes(fdfcuv.display_flag) displayed, xxen_util.yes(fdfcuv.required_flag) required, xxen_util.yes(fdfcuv.security_enabled_flag) security_enabled, xxen_util.meaning(ffvs.format_type,'FIELD_TYPE',0) format_type, xxen_util.meaning(ffvs.validation_type,'SEG_VAL_TYPES',0) validation_type, ffvt.application_table_name validation_table, ffvt.id_column_name, ffvt.id_column_size, ffvt.id_column_type, ffvt.value_column_name, ffvt.value_column_size, ffvt.value_column_type, ffvt.meaning_column_name, ffvt.meaning_column_size, ffvt.meaning_column_type, &additional_where_clause where_clause, &lov_query xxen_util.user_name(fdfcuv.created_by) created_by, xxen_util.client_time(fdfcuv.creation_date) creation_date, xxen_util.user_name(fdfcuv.last_updated_by) last_updated_by, xxen_util.client_time(fdfcuv.last_update_date) last_update_date, fdfv.application_id from fnd_application_vl fav, fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv, fnd_descr_flex_col_usage_vl fdfcuv, fnd_flex_value_sets ffvs, fnd_flex_validation_tables ffvt where 1=1 and fdfv.descriptive_flexfield_name not like '$SRS$.%' and fav.application_id=fdfv.application_id and fdfv.application_id=fdfcv.application_id(+) and fdfv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name(+) and fdfcv.application_id=fdfcuv.application_id(+) and fdfcv.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name(+) and fdfcv.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code(+) and fdfcuv.flex_value_set_id=ffvs.flex_value_set_id(+) and decode(ffvs.validation_type,'F',ffvs.flex_value_set_id)=ffvt.flex_value_set_id(+) order by fav.application_name, fdfv.title, fdfcv.descriptive_flex_context_name, fdfcuv.column_seq_num Y AR FND Descriptive Flexfields الجدول المرن الوصفي والسياق والعمود ومعلومات التحقق من الصحة D FND Descriptive Flexfields Beschreibende Flexfields-Tabelle, Kontext-, Spalten- und Validierungsinformationen E FND Descriptive Flexfields Información descriptiva de la tabla, el contexto, la columna y la validación de los campos flexibles F FND Descriptive Flexfields Tableau descriptif des flexfields, contexte, colonne et informations de validation I FND Descriptive Flexfields Tabella descrittiva dei flexfields, contesto, colonna e informazioni di validazione JA FND Descriptive Flexfields 記述的なフレックスフィールドのテーブル、コンテキスト、カラム、検証情報 KO FND Descriptive Flexfields 보조 가변 필드 테이블, 컨텍스트, 열 및 검증 정보 PTB FND Descriptive Flexfields Tabela descritiva de flexfields, contexto, coluna e informações de validação RU FND Descriptive Flexfields Описательная таблица гибких полей, контекст, колонка и валидационная информация S FND Descriptive Flexfields Beskrivande flexfields tabell, sammanhang, kolumn och valideringsinformation TR FND Descriptive Flexfields Açıklayıcı flexfields tablosu, bağlam, sütun ve doğrulama bilgileri US FND Descriptive Flexfields Descriptive flexfields table, context, column and validation information ZHS FND Descriptive Flexfields 描述性flexfields表、上下文、列和验证信息。 Enginatics &additional_where_clause &lov_query 1=1 1 -10 &additional_where_clause select case when fnd_release.major_version>=12 and fnd_release.minor_version>=2 then 'ffvt.additional_where_clause' else 'xxen_util.long_to_clob(''fnd_flex_validation_tables'',''additional_where_clause'',ffvt.rowid)' end from dual Char x US Additional Where Clause 2 10 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 3 20 1=1 fdfcv.descriptive_flexfield_name=:name LOV custom Y select fdfv.descriptive_flexfield_name value, fav.application_name||': '||fdfv.application_table_name description from fnd_application_vl fav, fnd_descriptive_flexs_vl fdfv where (:$flex$.table_name is null or xxen_util.contains(:$flex$.table_name,fdfv.application_table_name)='Y') and fav.application_id=fdfv.application_id and fdfv.descriptive_flexfield_name not like '$SRS$%' order by fdfv.descriptive_flexfield_name F Nom US Name 4 30 1=1 fdfv.title=:title LOV custom Y select fdfv.title value, fav.application_name||': '||fdfv.application_table_name description from fnd_application_vl fav, fnd_descriptive_flexs_vl fdfv where (:$flex$.table_name is null or xxen_util.contains(:$flex$.table_name,fdfv.application_table_name)='Y') and fav.application_id=fdfv.application_id and fdfv.descriptive_flexfield_name not like '$SRS$%' order by fdfv.title F Titre US Title 5 40 1=1 fdfv.application_table_name=:table_name LOV custom Y select fdfv.application_table_name value, fav.application_name||': '||fdfv.title description from fnd_application_vl fav, fnd_descriptive_flexs_vl fdfv where fav.application_id=fdfv.application_id and fdfv.descriptive_flexfield_name not like '$SRS$%' order by fdfv.application_table_name F Nom de la table US Table Name 6 50 1=1 fdfcuv.form_left_prompt=:window_prompt LOV custom Y select fdfcuv.form_left_prompt value, fav.application_name||': '||fdfv.title||': '||fdfcv.descriptive_flex_context_name description from fnd_descr_flex_col_usage_vl fdfcuv, fnd_descr_flex_contexts_vl fdfcv, fnd_descriptive_flexs_vl fdfv, fnd_application_vl fav where fdfcuv.descriptive_flexfield_name not like '$SRS$.%' and fdfcuv.application_id=fdfcv.application_id and fdfcuv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfcv.descriptive_flex_context_code and fdfcv.application_id=fdfv.application_id and fdfcv.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfv.application_id=fav.application_id order by fdfcuv.form_left_prompt, fav.application_name||': '||fdfv.title||': '||fdfcv.descriptive_flex_context_name F Invitation à la fenêtre US Window Prompt 7 60 1=1 lower(ffvt.application_table_name) like lower(:validation_table_name) LOV FND Table Name (wildcard) 8E2FF36EDE8979D2E0530100007F1FF2 select ft.table_name value, fav.application_name description from fnd_tables ft, fnd_application_vl fav where ft.application_id=fav.application_id order by ft.table_name F Nom de la table de validation US Validation Table Name 8 70 &lov_query xxen_report_ebs.oracle_lov_query(ffvs.flex_value_set_id) lov_query, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show LOV Query :$flex$.table_name Table Name Name :$flex$.table_name Table Name Title