Sunday 29 December 2013

Value Set Definition

-- Setup > Financials > Flexfields > Validation > Sets

/* Formatted on 12/29/2013 1:02:28 PM (QP5 v5.114.809.3010) */
SELECT   ffvs.flex_value_set_name name,
         DECODE (ffvs.longlist_flag,
                 'N', 'List of Values',
                 'X', 'Poplist',
                 'Y', 'Long List of Values',
                 'Other')
            list_type,
         DECODE (ffvs.security_enabled_flag,
                 'N', 'No Security',
                 'Y', 'Non-Hierarchical Security',
                 'H', 'Hierarchical Security',
                 'Other')
            security_type,
         DECODE (ffvs.format_type,
                 'C', 'Char',
                 'D', 'Date',
                 'T', 'DateTime',
                 'N', 'Number',
                 'X', 'Standard Date',
                 'Y', 'Standard DateTime',
                 'I', 'Time',
                 'NULL')
            format_type,
         DECODE (ffvs.validation_type,
                 'Y',
                 'Translatable Dependent',
                 'X',
                 'Translatable Independent',
                 'F',
                 'Table',
                 'U',
                 'Special',
                 'D',
                 'Dependent',
                 'I',
                 'Independent',
                 'N',
                 'None',
                 'P',
                 'Pair')
            validation_type,
         ffvs.maximum_size max_size,
         ffvs.number_precision precision,
         CASE WHEN ffvs.format_type = 'N' THEN 'Y' ELSE 'N' END numbers_only,
         ffvs.numeric_mode_enabled_flag right_justify,
         ffvs.uppercase_only_flag uppercase,
         ffvs.protected_flag,
         ffvs.security_enabled_flag,
         ffvs.uppercase_only_flag,
         ffvs.dependant_default_value,
         ffvs.dependant_default_meaning,
         ffvs2.flex_value_set_name independent_value_set,
         ffvs.description
  FROM   applsys.fnd_flex_value_sets ffvs, applsys.fnd_flex_value_sets ffvs2
 WHERE       ffvs.parent_flex_value_set_id = ffvs2.flex_value_set_id(+)
         AND ffvs.flex_value_set_name IN ('POA_EUL_LIST')
         AND 1 = 1

No comments:

Post a Comment