Query to Get Value Sets Details

SELECT ffvs.flex_value_set_name "Value Set"

,      CASE

         WHEN validation_type = 'I' THEN 'Independent'

         WHEN validation_type = 'F' THEN 'Table'

         WHEN validation_type = 'D' THEN 'Dependent'

         WHEN validation_type = 'P' THEN 'Pair'

         WHEN validation_type = 'U' THEN 'Special'

         WHEN validation_type = 'N' THEN 'None'

         ELSE validation_type

       END                            "Validation Type"

,      ffvs.flex_value_set_id         xonly_flex_value_set_id

,      ffvs.creation_date             "Created"

,      ffvs.format_type               "Format Type"

,      ffvs.maximum_size              "Max Size"

,      ffvs.alphanumeric_allowed_flag "Alpha"

,      ffvs.uppercase_only_flag       "Uppercase"

,      ffvs.numeric_mode_enabled_flag "Left Pad"

,      ffvs.minimum_value             "Min Value"

,      ffvs.maximum_value             "Max Value"

,      usr.user_name                  "Created By"

,      ffvs.creation_date             "Creation Date"

,      usr2.user_name                 "Last Updated By"

,      ffvs.last_update_date          "Last Update Date"

FROM   fnd_flex_value_sets ffvs

,      fnd_user            usr

,      fnd_user            usr2

WHERE  ffvs.flex_value_set_id = :1

AND    usr.user_id (+)        = ffvs.created_by

AND    usr2.user_id (+)       = ffvs.last_updated_by