Query For Value Sets In Oracle Apps R12

Query For Value Sets In Oracle Apps R12

 This sql query will assist in obtaining the entire list of value set values.

Value Set Tables in Oracle Apps R12

• FND_FLEX_VALUE_SETS
• FND_FLEX_VALUES
• FND_FLEX_VALUES_TL

Query to get Table Based Value Sets in Oracle Apps R12

1 2 3 4 5 6 7 8 9 10 11 12

select ffvs.flex_value_set_id ,     ffvs.flex_value_set_name ,     ffvs.description set_description ,     ffvs.validation_type,     ffvt.value_column_name ,     ffvt.meaning_column_name ,     ffvt.id_column_name ,     ffvt.application_table_name ,     ffvt.additional_where_clause FROM fnd_flex_value_sets ffvs ,     fnd_flex_validation_tables ffvt WHERE ffvs.flex_value_set_id = ffvt.flex_value_set_id;

Query to get Independent Value Set Details in Oracle Apps R12

Query to get Independent Value Set Details in Oracle Apps R12

Oracle PL/SQL

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

SELECT ffvs.flex_value_set_id ,     ffvs.flex_value_set_name ,     ffvs.description set_description ,     ffvs.validation_type,     ffv.flex_value_id ,     ffv.flex_value ,     ffvt.flex_value_meaning ,     ffvt.description value_description FROM fnd_flex_value_sets ffvs ,     fnd_flex_values ffv ,     fnd_flex_values_tl ffvt WHERE     ffvs.flex_value_set_id     = ffv.flex_value_set_id     and ffv.flex_value_id      = ffvt.flex_value_id     AND ffvt.language          = USERENV('LANG');