Query to get Value set details in oracle apps

Hi Friends, we are going to discuss about Query to get Value set details in oracle apps. We will share the detail sql query which helps to extract the complete detail about value sets in oracle apps. Using this query , we will be able to fetch the complete detail about value set details in oracle apps. This is one of the useful query about value sets. Using this value set query , we can develop the custom reports related to value set details in oracle apps. We will also share the important table related to value set in oracle apps. We can refer this sql query to develop the custom Value set detail report in oracle apps. Please find below the complete detail about Query to get Value set details in oracle apps.

Query to get Value set details in oracle apps

1 Important Table in Query to get Value set details in oracle apps

1. fnd_flex_value_sets

Detail sql Query to get Value set details in oracle apps

Here below is the detail sql query to extract the value set details in oracle apps.

SELECT ffvs.flex_value_set_name "Value Set Name"

,      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                            "Value Set Validation Type"

,      ffvs.flex_value_set_id         flex_value_set_id

,      ffvs.uppercase_only_flag       "Uppercase"

,      ffvs.numeric_mode_enabled_flag "Left Pad"

,      ffvs.minimum_value             "Min Value"

,      ffvs.maximum_value             "Max Value"

,      ffvs.creation_date             "Creation Date"

,      ffvs.format_type               "Value Set Format Type"

,      ffvs.maximum_size              "Max Size"

,      ffvs.alphanumeric_allowed_flag "Alpha"

,      usr_1.user_name                  "Created By"

,      ffvs.creation_date             "Creation Date"

,      usr_2.user_name                 "Last Updated By"

,      ffvs.last_update_date          "Last Update Date"

FROM   fnd_flex_value_sets ffvs

,      fnd_user            usr_1

,      fnd_user            usr_2

WHERE  1=1--

AND    usr_1.user_id (+)        = ffvs.created_by

AND    usr_2.user_id (+)       = ffvs.last_updated_by

Query to get Value set details in oracle apps