ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US ACEC4D19ACC13F25E0530100007F253E select fav.application_short_name, fav.application_name, ft.table_name, fc.column_name, fc.description column_description, xxen_util.meaning(fc.column_type,'COLUMN_TYPE',0)||case when fc.column_type in ('C','U','V') then ' ('||fc.width||')' end column_type, xxen_util.meaning(fc.null_allowed_flag,'YES_NO',0) null_allowed, fpk.primary_key_name, fpkc.primary_key_sequence, fc.flexfield_name, fdfv.title flexfield_title, fc.column_type column_type_code, xxen_util.user_name(fc.created_by) created_by, xxen_util.client_time(fc.creation_date) creation_date, xxen_util.user_name(fc.last_updated_by) last_updated_by, xxen_util.client_time(fc.last_update_date) last_update_date from fnd_application_vl fav, fnd_tables ft, fnd_columns fc, fnd_primary_key_columns fpkc, fnd_primary_keys fpk, fnd_descriptive_flexs_vl fdfv where 1=1 and fav.application_id=ft.application_id and ft.application_id=fc.application_id and ft.table_id=fc.table_id and fc.application_id=fpkc.application_id(+) and fc.table_id=fpkc.table_id(+) and fc.column_id=fpkc.column_id(+) and fc.flexfield_application_id=fdfv.application_id(+) and fc.flexfield_name=fdfv.descriptive_flexfield_name(+) and fpkc.application_id=fpk.application_id(+) and fpkc.table_id=fpk.table_id(+) and fpkc.primary_key_id=fpk.primary_key_id(+) order by ft.table_name, fc.column_sequence, fpkc.primary_key_sequence Y AR FND Tables and Columns جداول FND المسجلة والأعمدة والمفاتيح الأولية وحقولها المرنة D FND Tables and Columns Registrierte FND-Tabellen, Spalten, Primärschlüssel und deren Flexfields E FND Tables and Columns Tablas FND registradas, columnas, claves primarias y sus campos flexibles F FND Tables and Columns Tableaux, colonnes, clés primaires et leurs flexfields I FND Tables and Columns Tabelle FND registrate, colonne, chiavi primarie e loro flexfields JA FND Tables and Columns 登録されたFNDテーブル、カラム、主キーとそのフレックスフィールド KO FND Tables and Columns 등록 된 FND 테이블, 열, 기본 키 및 해당 가변 필드 PTB FND Tables and Columns Tabelas FND registradas, colunas, chaves primárias e seus campos flexiveis RU FND Tables and Columns Зарегистрированные таблицы ФНД, столбцы, первичные ключи и их флекс-поля S FND Tables and Columns Registrerade FND-tabeller, kolumner, primära nycklar och deras flexfält TR FND Tables and Columns Kayıtlı FND tabloları, sütunlar, birincil anahtarlar ve bunların esnek alanları US FND Tables and Columns Registered FND tables, columns, primary keys and their flexfields ZHS FND Tables and Columns 注册的FND表、列、主键及其弹性字段。 Enginatics 1=1 1 10 1=1 ft.table_name=:table_name LOV custom Y 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 2 20 1=1 fc.column_name like upper(:colum_name) Char F Nom de la colonne comme US Column Name like 3 30 1=1 fpkc.primary_key_sequence is not null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Colonnes clés uniquement US Key Columns only