FND Descriptive Flexfields

➜ Back to Library
Description
Categories: Enginatics
Repository: Github Columns: Application, Title, Table Name, Context Code, Context Name, Context Description, Seq Num, Window Prompt, Table Column, Value Set Name ...
Descriptive flexfields table, context, column and validation information 
select
fav.application_name application,
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
Validation Table Name 
lower(ffvt.application_table_name) like lower(:validation_table_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
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 Security Rules JE Israeli Withholding Annual Certificate To Vendors PO Approval Groups
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: