ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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 49A8B1A8036608ACE0530100007FEB91 select ffvs.flex_value_set_name, ffvs.description, xxen_util.meaning(ffvs.longlist_flag,'FLEX_VALUESET_LONGLIST_FLAG',0) list_type, xxen_util.meaning(ffvs.security_enabled_flag,'FLEX_VST_SECURITY_ENABLED_FLAG',0) security_type, xxen_util.meaning(ffvs.format_type,'FIELD_TYPE',0) format_type, ffvs.maximum_size, xxen_util.meaning(decode(ffvs.alphanumeric_allowed_flag,'N','Y'),'YES_NO',0) numbers_only, xxen_util.yes(ffvs.uppercase_only_flag) uppercase_only, xxen_util.meaning(ffvs.validation_type,'SEG_VAL_TYPES',0) validation_type, (select ffvs0.flex_value_set_name from fnd_flex_value_sets ffvs0 where ffvs.parent_flex_value_set_id=ffvs0.flex_value_set_id) parent_value_set, ffvs.dependant_default_value, ffvs.dependant_default_meaning dependant_default_description, &col_usages &col_values fav.application_name table_application, ffvt.application_table_name table_name, ffvt.value_column_name, xxen_util.meaning(ffvt.value_column_type,'COLUMN_TYPE',0) value_column_type, ffvt.value_column_size, ffvt.meaning_column_name, xxen_util.meaning(ffvt.meaning_column_type,'COLUMN_TYPE',0) meaning_column_type, ffvt.meaning_column_size, ffvt.id_column_name, xxen_util.meaning(ffvt.id_column_type,'COLUMN_TYPE',0) id_column_type, ffvt.id_column_size, &additional_where_clause where_order_by, ffvt.additional_quickpick_columns additional_columns, &lov_query xxen_util.user_name(ffvs.created_by) created_by, xxen_util.client_time(ffvs.creation_date) creation_date, xxen_util.user_name(ffvs.last_updated_by) last_updated_by, xxen_util.client_time(ffvs.last_update_date) last_update_date, ffvs.validation_type validation_type_code, ffvs.flex_value_set_id from fnd_flex_value_sets ffvs, fnd_flex_validation_tables ffvt, fnd_application_vl fav, (select ffvv.* from fnd_flex_values_vl ffvv where '&show_values'='Y') ffvv, ( select fdfcuv.flex_value_set_id, fav.application_name usage_application, 'Descriptive Flexfield' usage_type, fdfv.title usage_title, fdfcuv.descriptive_flex_context_code usage_context, fdfcuv.end_user_column_name usage_column_name, fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv, fnd_descriptive_flexs_vl fdfv, fnd_application_vl fav where '&show_usages'='Y' and fdfcuv.descriptive_flexfield_name not like '$SRS$.%' and fdfcuv.application_id=fdfv.application_id and fdfcuv.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfcuv.application_id=fav.application_id union all select fifs.flex_value_set_id, fav.application_name usage_application, 'Key Flexfield' usage_type, fif.id_flex_name usage_title, fifsv.id_flex_structure_name usage_context, fifs.segment_name usage_column_name, fifs.form_left_prompt prompt from fnd_id_flex_segments_vl fifs, fnd_id_flex_structures_vl fifsv, fnd_id_flexs fif, fnd_application_vl fav where '&show_usages'='Y' and fifs.application_id=fifsv.application_id and fifs.id_flex_code=fifsv.id_flex_code and fifs.id_flex_num=fifsv.id_flex_num and fifs.application_id=fif.application_id and fifs.id_flex_code=fif.id_flex_code and fifs.application_id=fav.application_id union all select fdfcuv.flex_value_set_id, fav.application_name usage_application, 'Concurrent Program' usage_type, fcpv.user_concurrent_program_name usage_title, to_char(fdfcuv.column_seq_num) usage_context, fdfcuv.end_user_column_name usage_column_name, fdfcuv.form_left_prompt prompt from fnd_descr_flex_col_usage_vl fdfcuv, fnd_concurrent_programs_vl fcpv, fnd_application_vl fav where '&show_usages'='Y' and fdfcuv.descriptive_flexfield_name like '$SRS$.%' and fdfcuv.application_id=fcpv.application_id and substr(fdfcuv.descriptive_flexfield_name,7)=fcpv.concurrent_program_name and fdfcuv.application_id=fav.application_id ) x where 1=1 and ffvs.flex_value_set_name not like '$FLEX$.%' and ffvs.flex_value_set_id=ffvt.flex_value_set_id(+) and ffvt.table_application_id=fav.application_id(+) and ffvs.flex_value_set_id=ffvv.flex_value_set_id(+) and ffvs.flex_value_set_id=x.flex_value_set_id(+) order by ffvs.flex_value_set_name, x.usage_type, x.usage_title, x.usage_context, x.usage_column_name, ffvv.flex_value Y AR FND Flex Value Sets, Usages and Values مجموعات القيم والقيم بما في ذلك الاستخدامات ونوع التحقق ونوع التنسيق وجدول التحقق من الصحة والأعمدة وما إلى ذلك. D FND Flex Value Sets, Usages and Values Wertesätze und Werte einschließlich Verwendungen, Validierungstyp, Formattyp, Validierungstabelle, Spalten usw. E FND Flex Value Sets, Usages and Values Conjuntos de valores y valores incluyendo usos, tipo de validación, tipo de formato, tabla de validación, columnas, etc. F FND Flex Value Sets, Usages and Values Les ensembles de valeurs et les valeurs, y compris les usages, le type de validation, le type de format, le tableau de validation, les colonnes, etc. I FND Flex Value Sets, Usages and Values Insiemi di valori e valori compresi gli usi, il tipo di convalida, il tipo di formato, la tabella di convalida, le colonne, ecc. JA FND Flex Value Sets, Usages and Values 使用法、バリデーションタイプ、フォーマットタイプ、バリデーションテーブル、カラムなどを含む値セットと値。 KO FND Flex Value Sets, Usages and Values 사용법, 유효성 검사 유형, 형식 유형, 유효성 검사 테이블, 열 등을 포함한 값 집합 및 값 PTB FND Flex Value Sets, Usages and Values Conjuntos de valores e valores incluindo usos, tipo de validação, tipo de formato, tabela de validação, colunas, etc. RU FND Flex Value Sets, Usages and Values Наборы значений и значения, включая использование, тип валидации, тип формата, таблицу валидации, колонки и т.д. S FND Flex Value Sets, Usages and Values Värdeuppsättningar och värden inklusive användning, valideringstyp, formattyp, valideringstabell, kolumner etc. TR FND Flex Value Sets, Usages and Values Kullanımlar, doğrulama türü, biçim türü, doğrulama tablosu, sütunlar vb. Dahil değer kümeleri ve değerleri. US FND Flex Value Sets, Usages and Values Value sets and values including usages, validation type, format type, validation table, columns etc. ZHS FND Flex Value Sets, Usages and Values 值集和值，包括用途、验证类型、格式类型、验证表、列等。 Enginatics &additional_where_clause &col_usages &col_values &lov_query &show_usages &show_values 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 (lower(ffvs.flex_value_set_name) like lower(:value_set_name) or lower(ffvs.description) like lower(:value_set_name)) LOV custom select ffvs.flex_value_set_name value, decode(ffvs.validation_type, 'D','Dependent', 'I','Independent', 'N','None', 'P','Pair', 'U','Special', 'F','Table', 'X','Translatable Independent', 'Y','Translatable Dependent' )||': '||ffvs.description description from fnd_flex_value_sets ffvs where ffvs.flex_value_set_name not like '$FLEX$.%' order by ffvs.flex_value_set_name F Nom du jeu de valeurs Flex comme US Flex Value Set Name like 3 20 &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 4 30 &show_usages Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les utilisations US Show Usages 5 &col_usages x.usage_application, x.usage_type, x.usage_title, x.usage_context, x.usage_column_name, x.prompt, F Afficher les utilisations US Show Usages 6 40 &show_values Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les valeurs US Show Values 7 &col_values ffvv.flex_value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end value_description, F Afficher les valeurs US Show Values 8 50 1=1 ffvs.validation_type=xxen_util.lookup_code(:validation_type,'SEG_VAL_TYPES',0) LOV custom Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='SEG_VAL_TYPES' and flvv.view_application_id=0 and flvv.security_group_id=0 order by flvv.meaning F Type de validation US Validation Type 9 60 1=1 lower(ffvt.application_table_name) like lower(: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 US Table Name 10 70 1=1 ffvs.last_update_date>=:last_update_date_from Date US Last Update Date From