Follow us: Connect on YouTube 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 :

2 comments:

  1. Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com

    ReplyDelete
  2. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete