Configuration – Extract Table based value set information
Use below query to extract table based value set information from backend tables:
SELECT ffvs.flex_value_set_name
,ffvs.description vale_set_desc
,ffvs.validation_type
,ffvs.format_type
,ffvs.maximum_size
,ffvs.number_precision
,ffvs.alphanumeric_allowed_flag
,ffvs.uppercase_only_flag
,ffvt.value_column_name
,ffvt.value_column_type
,ffvt.value_column_size
,ffvt.meaning_column_name
,ffvt.meaning_column_type
,ffvt.meaning_column_size
,ffvt.id_column_name
,ffvt.id_column_type
,ffvt.id_column_size
,ffvt.enabled_column_name
,ffvt.start_date_column_name
,ffvt.end_date_column_name
,ffvt.summary_column_name
,ffvt.application_table_name
,ffvt.additional_where_clause
,ffvt.additional_quickpick_columns
FROM fnd_flex_value_sets ffvs
,fnd_flex_validation_tables ffvt
WHERE ffvs.flex_value_set_id = ffvt.flex_value_set_id
AND ffvs.flex_value_set_name LIKE 'XX%'
Hi,
Are you still in business?
I found a few errors on your site.
Would you like me to send over a screenshot of those errors?
Regards
Jacob
(714) 500-7363