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 320488CD77CF0644E0630100007F868BY select fav.application_name application, fdfv.descriptive_flexfield_name name, fdfv.title, fdfv.application_table_name table_name, fdfv.application_id, fdfv.descriptive_flexfield_name, fc.column_name, fc.description, 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_descriptive_flexs_vl fdfv, fnd_tables ft, fnd_columns fc where fdfv.title='Enter Journals: Lines' and 1=1 and fdfv.descriptive_flexfield_name not like '$SRS$.%' and fav.application_id=fdfv.application_id and fdfv.table_application_id=ft.application_id and fdfv.application_table_name=ft.table_name and ft.application_id=fc.application_id(+) and ft.table_id=fc.table_id(+) and fc.flexfield_usage_code(+)='D' and fdfv.application_id=fc.flexfield_application_id(+) and fdfv.descriptive_flexfield_name=fc.flexfield_name(+) order by fav.application_name, fdfv.title, fc.column_name US FND Descriptive Flexfield Table Columns Shows all active descriptive flexfield table columns. Enginatics 1=1 1 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 2 20 1=1 fdfv.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 3 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 4 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 :$flex$.table_name Table Name Name :$flex$.table_name Table Name Title