ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEBF79D2E0530100007F1FF2 FND Flex Value Set Y 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 US 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 8E2FF36EDE9E79D2E0530100007F1FF2 FND Responsibility Name Y select frv.responsibility_name value, frv.description from fnd_responsibility_vl frv order by frv.responsibility_name US A95C471001B20DD1E0530100007FBF83 GL Ledger (all) Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and gl.object_type_code='L' and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'NONE',1,'PRIMARY',2,'SECONDARY',3,'ALC',4), gl.name D Alle Hauptbücher E Todos los libros de contabilidad F Tous les livres I Tutti i libri contabili US All ledgers 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 835E0E15BDEA4448E0530100007F0409 select ffvs.flex_value_set_name value_set_name, ffvrv.flex_value_rule_name rule_name, ffvrv.description, ffvrv.error_message, &responsibility_column &flexfield_columns xxen_util.user_name(ffvrv.created_by) rule_created_by, xxen_util.client_time(ffvrv.creation_date) rule_creation_date, xxen_util.user_name(ffvrv.last_updated_by) rule_last_updated_by, xxen_util.client_time(ffvrv.last_update_date) rule_last_update_date from fnd_flex_value_sets ffvs, fnd_flex_value_rules_vl ffvrv, (select ffvrl.* from fnd_flex_value_rule_lines ffvrl where '&show_rule_elements'='Y') ffvrl, (select ffvru.* from fnd_flex_value_rule_usages ffvru where '&show_responsibilities'='Y') ffvru, fnd_responsibility_vl frv, (select fifsgv.* from fnd_id_flex_segments_vl fifsgv where '&show_flexfields'='Y') fifsgv, fnd_id_flex_structures_vl fifsv, fnd_id_flexs fif, fnd_application_vl fav where 1=1 and ffvs.flex_value_set_id=ffvrv.flex_value_set_id and ffvrv.flex_value_rule_id=ffvrl.flex_value_rule_id(+) and ffvrv.flex_value_rule_id=ffvru.flex_value_rule_id(+) and ffvru.responsibility_id=frv.responsibility_id(+) and ffvru.application_id=frv.application_id(+) and ffvs.flex_value_set_id=fifsgv.flex_value_set_id(+) and fifsgv.id_flex_code=fifsv.id_flex_code(+) and fifsgv.id_flex_num=fifsv.id_flex_num(+) and fifsgv.application_id=fifsv.application_id(+) and fifsv.application_id=fif.application_id(+) and fifsv.id_flex_code=fif.id_flex_code(+) and fif.application_id=fav.application_id(+) order by ffvrv.flex_value_rule_name, frv.responsibility_name, fav.application_name, fif.id_flex_name, fifsv.id_flex_structure_name, fifsgv.segment_num, ffvrl.include_exclude_indicator desc, ffvrl.flex_value_low Y AR FND Flex Security Rules قواعد أمان قيمة Flexfield ، وعناصر القاعدة (نطاقات قيمة flexfield المضمنة أو المستبعدة) ، والمجالات المرنة حيث يتم استخدام مجموعة القيمة المؤمنة والمسؤوليات التي تم تعيين القاعدة لها. D FND Flex Security Rules Flexfield-Wertesicherheitsregeln, Regelelemente (eingeschlossene oder ausgeschlossene Flexfield-Wertebereiche), Flexfields, in denen die gesicherte Wertemenge verwendet wird, und Verantwortlichkeiten, denen die Regel zugewiesen ist. E FND Flex Security Rules Reglas de seguridad de valores de campos flexibles, elementos de la regla (rangos de valores de campos flexibles incluidos o excluidos), campos flexibles en los que se utiliza el conjunto de valores asegurados y responsabilidades a las que se asigna la regla. F FND Flex Security Rules Règles de sécurité des valeurs flexfield, éléments de règle (plages de valeurs flexfield incluses ou exclues), flexfields où l'ensemble de valeurs sécurisées est utilisé et responsabilités auxquelles la règle est attribuée. I FND Flex Security Rules Regole di sicurezza dei valori dei flexfield, elementi della regola (intervalli di valori dei flexfield inclusi o esclusi), flexfields dove il set di valori protetti è usato e responsabilità a cui la regola è assegnata. JA FND Flex Security Rules フレックスフィールド値セキュリティルール、ルール要素（フレックスフィールド値範囲に含まれるか除外されるか）、セキュリティ保護された値セットが使用されるフレックスフィールド、ルールが割り当てられる責任。 KO FND Flex Security Rules 가변 필드 값 보안 규칙, 규칙 요소 (포함되거나 제외 된 가변 필드 값 범위), 보안 값 세트가 사용되는 가변 필드 및 규칙이 지정된 권한. PTB FND Flex Security Rules Regras de segurança de valor Flexfield, elementos de regra (faixas de valor Flexfield incluídas ou excluídas), flexfields onde o conjunto de valores seguros é usado e responsabilidades a que a regra é atribuída. RU FND Flex Security Rules Flexfield value security rules, элементы правил (включенные или исключенные диапазоны значений Flexfield), гибкие поля, в которых используется набор обеспеченных значений, и обязанности, которые налагаются на правило. S FND Flex Security Rules Flexfield-värdesäkerhetsregler, regelelement (inkluderade eller uteslutna flexfield-värdeintervall), flexfields där det säkra värdet används och ansvar som regeln tilldelas. TR FND Flex Security Rules Flexfield değeri güvenlik kuralları, kural öğeleri (dahil edilen veya hariç tutulan flexfield değer aralıkları), güvenli değer kümesinin kullanıldığı flexfield'lar ve kuralın atandığı sorumluluklar. US FND Flex Value Security Rules Flexfield value security rules, rule elements (included or excluded flexfield value ranges), flexfields where the secured value set is used and responsibilities that the rule is assigned to. ZHS FND Flex Security Rules Flexfield值安全规则、规则元素（包括或排除的flexfield值范围）、使用安全值集的flexfield以及规则被分配的责任。 Enginatics &flexfield_columns &responsibility_column &show_flexfields &show_responsibilities &show_rule_elements 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 US Flexfield 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 F Code Flexfield US Flexfield Code 3 30 1=1 ffvrv.flex_value_rule_name=:rule_name LOV custom Y select distinct ffvrv.flex_value_rule_name value, ffvrv.description from fnd_flex_value_rules_vl ffvrv order by ffvrv.flex_value_rule_name F Nom de la règle US Rule Name 4 40 1=1 ffvs.flex_value_set_name=:value_set_name LOV FND Flex Value Set 8E2FF36EDEBF79D2E0530100007F1FF2 Y 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 Ensemble de valeurs Flex US Flex Value Set 5 50 1=1 frv.responsibility_name=:responsibility LOV FND Responsibility Name 8E2FF36EDE9E79D2E0530100007F1FF2 Y select frv.responsibility_name value, frv.description from fnd_responsibility_vl frv order by frv.responsibility_name F Nom de la responsabilité US Responsibility Name 6 60 1=1 ffvs.flex_value_set_id in ( select fifs.flex_value_set_id from gl_ledgers gl, fnd_id_flex_segments fifs where gl.name=:ledger and fifs.application_id=101 and fifs.id_flex_code='GL#' and gl.chart_of_accounts_id=fifs.id_flex_num ) LOV GL Ledger (all) A95C471001B20DD1E0530100007FBF83 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and gl.object_type_code='L' and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'NONE',1,'PRIMARY',2,'SECONDARY',3,'ALC',4), gl.name F Grand livre US Ledger 7 70 &show_rule_elements Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Afficher les éléments de la règle US Show Rule Elements 8 &flexfield_columns xxen_util.meaning(ffvrl.include_exclude_indicator,'INCLUDE_EXCLUDE',3) include_exclude, ffvrl.flex_value_low, ffvrl.flex_value_high, xxen_util.user_name(ffvrl.created_by) element_created_by, xxen_util.client_time(ffvrl.creation_date) element_creation_date, xxen_util.user_name(ffvrl.last_updated_by) element_last_updated_by, xxen_util.client_time(ffvrl.last_update_date) element_last_update_date, F Afficher les éléments de la règle US Show Rule Elements 9 80 &show_flexfields Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select 'Y' from dual where :$flex$.flexfield is not null or :$flex$.flexfield_code is not null F Afficher les champs flexibles Afficher tous les flexfields qui utilisent l'ensemble des valeurs garanties US Show Flexfields Show all flexfields that make use of the secured value set 10 &flexfield_columns fav.application_name application, fif.id_flex_name flexfield, fif.id_flex_code, fifsv.id_flex_structure_name structure, fifsv.id_flex_num, fifsgv.segment_name, fifsgv.form_left_prompt window_prompt, fifsgv.application_column_name column_name, xxen_util.yes(fifsgv.security_enabled_flag) security_enabled, F Afficher les champs flexibles US Show Flexfields 11 90 &show_responsibilities Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select 'Y' from dual where :$flex$.responsibility_name is not null F Responsabilités du spectacle US Show Responsibilities 12 &responsibility_column frv.responsibility_name responsibility, F Responsabilités du spectacle US Show Responsibilities :$flex$.flexfield Flexfield Show Flexfields :$flex$.flexfield_code Flexfield Code Show Flexfields :$flex$.responsibility_name Responsibility Name Show Responsibilities