Reports2017-11-18T12:27:27+00:00

FND Key Flexfields

Description
Categories: Application, Enginatics, Setup
Key flexfields table, structure, column and validation information

select
fav.application_name,
fif.id_flex_name title,
fif.description,
fif.id_flex_code,
fif.application_table_name,
fif.unique_id_column_name,
fif.set_defining_column_name,
decode(fifsv.enabled_flag,'Y','Y') enabled_flag,
fifsv.id_flex_structure_code structure_code,
fifsv.id_flex_structure_name structure_name,
fifsv.id_flex_num,
fifsv.concatenated_segment_delimiter delimiter,
fifsv.shorthand_prompt,
fifsgv.segment_num segment_number,
fifsgv.segment_name,
fifsgv.form_left_prompt window_prompt,
fifsgv.application_column_name column_name,
ffvs.flex_value_set_name value_set_name,
fifsgv.display_flag,
fifsgv.enabled_flag,
xxen_util.meaning(ffvs.validation_type,'SEG_VAL_TYPES',0) validation_type,
ffvt.application_table_name validation_table,
ffvt.additional_where_clause where_clause
from
fnd_application_vl fav,
fnd_id_flexs fif,
fnd_id_flex_structures_vl fifsv,
fnd_id_flex_segments_vl fifsgv,
fnd_flex_value_sets ffvs,
fnd_flex_validation_tables ffvt
where
1=1 and
fav.application_id=fif.application_id and
fif.application_id=fifsv.application_id(+) and
fif.id_flex_code=fifsv.id_flex_code(+) and
fifsv.application_id=fifsgv.application_id(+) and
fifsv.id_flex_code=fifsgv.id_flex_code(+) and
fifsv.id_flex_num=fifsgv.id_flex_num(+) and
fifsgv.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,
fif.id_flex_name,
fifsv.id_flex_structure_name,
fifsgv.segment_num

Parameter Name SQL text Validation
Validation Table Name
lower(ffvt.application_table_name) like lower(:validation_table_name)
LOV
Window Prompt
fifsgv.form_left_prompt=:window_prompt
LOV
Table Name
fif.application_table_name=:table_name
LOV
Flexfield Code
fif.id_flex_code=:id_flex_code
LOV
Title
fif.id_flex_name=:title
LOV

By continuing to use the site, you agree to the use of cookies. Accept