ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDF1979D2E0530100007F1FF2 FND Key Flexfield Y select fif.id_flex_name value, fav.application_name||': '||fif.application_table_name||' ('||fif.id_flex_code||')' description from fnd_application_vl fav, fnd_id_flexs fif where fav.application_id=fif.application_id order by fif.id_flex_name US 8E2FF36EDF1879D2E0530100007F1FF2 FND Key Flexfield Code Y select fif.id_flex_code value, fif.id_flex_name||': '||fav.application_name||': '||fif.application_table_name description from fnd_application_vl fav, fnd_id_flexs fif where fav.application_id=fif.application_id order by fif.id_flex_name US A3AB189B606C4736E0530100007FD533 FND Key Flexfield Structure Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code||': '||fifsv.description description from fnd_id_flexs fif, fnd_id_flex_structures_vl fifsv where (fifsv.id_flex_code=:$flex$.fnd_key_flexfield_code or fif.id_flex_name=:$flex$.fnd_key_flexfield) and fif.application_id=fifsv.application_id and fif.id_flex_code=fifsv.id_flex_code order by fifsv.id_flex_structure_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 49A8B1A8037C08ACE0530100007FEB91Y select fav.application_name, fif.id_flex_name title, fif.description, fif.id_flex_code, fif.application_table_name, fif.unique_id_column_name, fif.set_defining_column_name, xxen_util.yes(fifsv.freeze_flex_definition_flag) freeze_flexfield, xxen_util.yes(fifsv.enabled_flag) structure_enabled, fifsv.concatenated_segment_delimiter segment_separator, xxen_util.yes(fifsv.cross_segment_validation_flag) cross_validate, xxen_util.yes(fifsv.freeze_structured_hier_flag) freeze_rollup_group, xxen_util.yes(fifsv.dynamic_inserts_allowed_flag) allow_dynamic_inserts, fifsv.id_flex_structure_code structure_code, fifsv.id_flex_structure_name structure_name, fifsv.id_flex_num, fifsv.concatenated_segment_delimiter delimiter, fifsv.shorthand_prompt, fifsgv.segment_num segment_number, fifsgv.segment_name, fifsgv.form_left_prompt window_prompt, fifsgv.application_column_name column_name, ( select distinct listagg(xxen_util.meaning(fsav.segment_attribute_type,'XLA_FLEXFIELD_SEGMENTS_QUAL',602),', ') within group (order by xxen_util.meaning(fsav.segment_attribute_type,'XLA_FLEXFIELD_SEGMENTS_QUAL',602)) over (partition by fsav.application_id,fsav.id_flex_code,fsav.id_flex_num,fsav.application_column_name) segment_attributes from fnd_segment_attribute_values fsav where fifsgv.application_id=fsav.application_id and fifsgv.id_flex_code=fsav.id_flex_code and fifsgv.id_flex_num=fsav.id_flex_num and fifsgv.application_column_name=fsav.application_column_name and fsav.attribute_value='Y' and fsav.segment_attribute_type<>'GL_GLOBAL' ) flexfield_qualifier, ( select distinct listagg(fsav.segment_attribute_type,', ') within group (order by fsav.segment_attribute_type) over (partition by fsav.application_id,fsav.id_flex_code,fsav.id_flex_num,fsav.application_column_name) segment_attributes from fnd_segment_attribute_values fsav where fifsgv.application_id=fsav.application_id and fifsgv.id_flex_code=fsav.id_flex_code and fifsgv.id_flex_num=fsav.id_flex_num and fifsgv.application_column_name=fsav.application_column_name and fsav.attribute_value='Y' and fsav.segment_attribute_type<>'GL_GLOBAL' ) flexfield_qualifier_code, ffvs.flex_value_set_name value_set_name, xxen_util.yes(fifsgv.enabled_flag) enabled, xxen_util.yes(fifsgv.display_flag) displayed, xxen_util.yes(fifsgv.application_column_index_flag) indexed, xxen_util.yes(fifsgv.required_flag) required, xxen_util.yes(fifsgv.security_enabled_flag) security_enabled, xxen_util.meaning(ffvs.validation_type,'SEG_VAL_TYPES',0) validation_type, ffvt.application_table_name validation_table, ffvt.additional_where_clause where_clause, xxen_util.user_name(fifsgv.created_by) created_by, xxen_util.client_time(fifsgv.creation_date) creation_date, xxen_util.user_name(fifsgv.last_updated_by) last_updated_by, xxen_util.client_time(fifsgv.last_update_date) last_update_date, fifsgv.flex_value_set_id from fnd_application_vl fav, fnd_id_flexs fif, fnd_id_flex_structures_vl fifsv, fnd_id_flex_segments_vl fifsgv, fnd_flex_value_sets ffvs, fnd_flex_validation_tables ffvt where 1=1 and fav.application_id=fif.application_id and fif.application_id=fifsv.application_id(+) and fif.id_flex_code=fifsv.id_flex_code(+) and fifsv.application_id=fifsgv.application_id(+) and fifsv.id_flex_code=fifsgv.id_flex_code(+) and fifsv.id_flex_num=fifsgv.id_flex_num(+) and fifsgv.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, fif.id_flex_name, fifsv.id_flex_structure_name, fifsgv.segment_num AR FND Key Flexfields مفتاح جدول فلكسفيلد ، هيكل ، عمود ومعلومات التحقق من الصحة D FND Key Flexfields Key flexfields Tabelle, Struktur, Spalten- und Validierungsinformationen E FND Key Flexfields Tabla de campos flexibles clave, estructura, columna e información de validación F FND Key Flexfields Tableau des principaux flexfields, structure, colonne et informations de validation I FND Key Flexfields Tabella dei flexfields chiave, struttura, colonna e informazioni di convalida JA FND Key Flexfields キーフレックスフィールドのテーブル、構造、カラム、検証情報 KO FND Key Flexfields 주요 가변 필드 테이블, 구조, 열 및 검증 정보 PTB FND Key Flexfields Tabela, estrutura, coluna e informações de validação dos principais campos flexíveis RU FND Key Flexfields Таблица ключевых гибких полей, структура, колонка и валидационная информация S FND Key Flexfields Nyckelflexfältstabell, struktur, kolumn och valideringsinformation TR FND Key Flexfields Anahtar flexfields tablosu, yapısı, sütunu ve doğrulama bilgileri US FND Key Flexfields Key flexfields table, structure, column and validation information ZHS FND Key Flexfields 关键的flexfields表、结构、列和验证信息。 Enginatics 1=1 1 10 1=1 fif.id_flex_name=:title LOV FND Key Flexfield 8E2FF36EDF1979D2E0530100007F1FF2 Y select fif.id_flex_name value, fav.application_name||': '||fif.application_table_name||' ('||fif.id_flex_code||')' description from fnd_application_vl fav, fnd_id_flexs fif where fav.application_id=fif.application_id order by fif.id_flex_name F Titre US Title 2 20 1=1 fif.id_flex_code=:id_flex_code LOV FND Key Flexfield Code 8E2FF36EDF1879D2E0530100007F1FF2 Y select fif.id_flex_code value, fif.id_flex_name||': '||fav.application_name||': '||fif.application_table_name description from fnd_application_vl fav, fnd_id_flexs fif where fav.application_id=fif.application_id order by fif.id_flex_name select 'GL#' from dual where :$flex$.title is null and :$flex$.table_name is null and :$flex$.window_prompt is null and :$flex$.validation_table_name is null F Code Flexfield US Flexfield Code 3 30 1=1 fifsv.id_flex_structure_name=:id_flex_structure_name LOV FND Key Flexfield Structure A3AB189B606C4736E0530100007FD533 Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code||': '||fifsv.description description from fnd_id_flexs fif, fnd_id_flex_structures_vl fifsv where (fifsv.id_flex_code=:$flex$.fnd_key_flexfield_code or fif.id_flex_name=:$flex$.fnd_key_flexfield) and fif.application_id=fifsv.application_id and fif.id_flex_code=fifsv.id_flex_code order by fifsv.id_flex_structure_name F Nom de la structure US Structure Name 4 40 1=1 fif.application_table_name=:table_name LOV custom Y select fif.application_table_name value, fav.application_name||': '||fif.id_flex_name description from fnd_application_vl fav, fnd_id_flexs fif where fav.application_id=fif.application_id order by fif.application_table_name F Nom de la table US Table Name 5 50 1=1 fifsgv.form_left_prompt=:window_prompt LOV custom Y select fifsgv.form_left_prompt value, fav.application_name||': '||fif.id_flex_name||': '||fifsv.id_flex_structure_name description from fnd_application_vl fav, fnd_id_flexs fif, fnd_id_flex_structures_vl fifsv, fnd_id_flex_segments_vl fifsgv where fav.application_id=fif.application_id and fif.id_flex_code=fifsv.id_flex_code and fif.application_id=fifsv.application_id and fifsv.id_flex_num=fifsgv.id_flex_num and fifsv.id_flex_code=fifsgv.id_flex_code and fifsv.application_id=fifsgv.application_id order by fifsgv.form_left_prompt, fav.application_name||': '||fif.id_flex_name||': '||fifsv.id_flex_structure_name F Invitation à la fenêtre US Window Prompt 6 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 :$flex$.fnd_key_flexfield Title Structure Name :$flex$.fnd_key_flexfield_code Flexfield Code Structure Name :$flex$.table_name Table Name Flexfield Code :$flex$.title Title Flexfield Code :$flex$.validation_table_name Validation Table Name Flexfield Code :$flex$.window_prompt Window Prompt Flexfield Code