Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Monday, 30 May 2016

Query to Get Value Sets


SELECT ffvs.creation_date "Created"

,      'vst/' || ffvs.flex_value_set_id || '.htm' href

,      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.format_type "Format Type"

,      ffvs.maximum_size "Size"

,      ffvs.alphanumeric_allowed_flag "Alpha"

,      ffvs.uppercase_only_flag "Uppercase"

,      ffvs.numeric_mode_enabled_flag "Left Pad"

,      ffvs.minimum_value "Min"

,      ffvs.maximum_value "Max"

,      usr.user_name "Created By"

FROM   fnd_flex_value_sets ffvs

,      fnd_user            usr

WHERE usr.user_id = ffvs.created_by

-- and ffvs.flex_value_set_name LIKE 'XX%'

    ORDER BY ffvs.creation_date ASC
Share this article :

0 comments:

Post a Comment