EBS Table Validated Value Sets
SELECT ffvs.flex_value_set_name,
ffvs.VALIDATION_TYPE,
ffvs.PROTECTED_FLAG,
ffvs.SECURITY_ENABLED_FLAG,
ffvs.LONGLIST_FLAG,
ffvs.FORMAT_TYPE,
ffvs.MAXIMUM_SIZE,
ffvs.ALPHANUMERIC_ALLOWED_FLAG,
ffvs.UPPERCASE_ONLY_FLAG,
ffvs.NUMERIC_MODE_ENABLED_FLAG,
ffvs.DEPENDANT_DEFAULT_VALUE,
ffvs.DEPENDANT_DEFAULT_MEANING,
ffvs.MINIMUM_VALUE,
ffvs.MAXIMUM_VALUE,
ffvs.NUMBER_PRECISION,
ffv.APPLICATION_TABLE_NAME,
ffv.VALUE_COLUMN_NAME,
ffv.VALUE_COLUMN_TYPE,
ffv.VALUE_COLUMN_SIZE,
ffv.COMPILED_ATTRIBUTE_COLUMN_NAME,
ffv.ENABLED_COLUMN_NAME,
ffv.HIERARCHY_LEVEL_COLUMN_NAME,
ffv.START_DATE_COLUMN_NAME,
ffv.END_DATE_COLUMN_NAME,
ffv.SUMMARY_ALLOWED_FLAG,
ffv.SUMMARY_COLUMN_NAME,
ffv.ID_COLUMN_NAME,
ffv.ID_COLUMN_SIZE,
ffv.ID_COLUMN_TYPE,
ffv.MEANING_COLUMN_NAME,
ffv.MEANING_COLUMN_SIZE,
ffv.MEANING_COLUMN_TYPE,
ffv.ADDITIONAL_QUICKPICK_COLUMNS,
ffv.ADDITIONAL_WHERE_CLAUSE,
fa.application_short_name table_application
FROM apps.FND_FLEX_VALIDATION_TABLES ffv,
apps.fnd_flex_value_sets ffvs,
apps.fnd_application fa
WHERE ffv.flex_value_set_id = ffvs.flex_value_set_id
AND ffv.table_application_id = fa.application_id(+)
ORDER BY ffvs.flex_value_set_name;