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

Pages

Monday, 30 May 2016

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
Share this article :

0 comments:

Post a Comment