FND Descriptive Flexfields

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Descriptive flexfields table, context, column and validation information
Run FND Descriptive Flexfields and other Oracle EBS reports with Blitz Report™ on our demo environment
select
fav.application_name application,
fdfcv.descriptive_flexfield_name name,
fdfv.title,
fdfv.application_table_name table_name,
fdfcv.descriptive_flex_context_code context_code,
fdfcv.descriptive_flex_context_name context_name,
fdfcv.description context_description,
fdfcuv.column_seq_num seq_num,
fdfcuv.form_left_prompt window_prompt,
fdfcuv.application_column_name table_column,
ffvs.flex_value_set_name value_set_name,
xxen_util.meaning(decode(fdfcuv.enabled_flag,'Y','Y'),'YES_NO',0) enabled,
xxen_util.meaning(decode(fdfcuv.display_flag,'Y','Y'),'YES_NO',0) displayed,
xxen_util.meaning(decode(fdfcuv.required_flag,'Y','Y'),'YES_NO',0) required,
xxen_util.meaning(decode(fdfcuv.security_enabled_flag,'Y','Y'),'YES_NO',0) 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(fdfcuv.created_by) created_by,
xxen_util.client_time(fdfcuv.creation_date) creation_date,
xxen_util.user_name(fdfcuv.last_updated_by) last_updated_by,
xxen_util.client_time(fdfcuv.last_update_date) last_update_date,
fdfv.application_id,
fdfv.descriptive_flexfield_name
from
fnd_application_vl fav,
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfcv,
fnd_descr_flex_col_usage_vl fdfcuv,
fnd_flex_value_sets ffvs,
fnd_flex_validation_tables ffvt
where
1=1 and
fdfv.descriptive_flexfield_name not like '$SRS$.%' and
fav.application_id=fdfv.application_id and
fdfv.application_id=fdfcv.application_id and
fdfv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and
fdfcv.application_id=fdfcuv.application_id(+) and
fdfcv.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name(+) and
fdfcv.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code(+) and
fdfcuv.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,
fdfv.title,
fdfcv.descriptive_flex_context_name,
fdfcuv.column_seq_num
Parameter Name SQL text Validation
Application 
fav.application_name=:application_name
 LOV
Name 
fdfcv.descriptive_flexfield_name=:name
 LOV
Title 
fdfv.title=:title
 LOV
Table Name 
fdfv.application_table_name=:table_name
 LOV
Window Prompt 
fdfcuv.form_left_prompt=:window_prompt
 LOV
Validation Table Name 
lower(ffvt.application_table_name) like lower(:validation_table_name)
 LOV
Download
 
Related Blitz Reports
FND Flex Value Sets, Usages and Values FND Concurrent Programs and Executables FND Concurrent Programs and Executables 11i PER Organizations FND Key Flexfields BEN Life Events Summary FND Flex Value Security Rules FND Flex Value Hierarchy XXT OF: PO Headers and Lines
Blitz Report™

Blitz Report™ provides multiple benefits: