Normally, you should use the values form Oracle Application Object Library provides, Define Segment Values, to contain parent values and rollup group information (together with child values contained in your validation table as described in the previous section).
If you have certain special columns, such as SUMMARY_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, STRUCTURED_HIERARCHY_LEVEL, COMPILED_VALUE_ATTRIBUTES or ENABLED_FLAG, in your registered table, your value set uses those columns automatically once you set up your table as a validation table.
If you do not want your value set to use those columns automatically, you should use an alias with your table name in the Table Name field.
Attention: If you need to use SQL functions or very complex WHERE clasuses with your table, you should instead first define a view over the table and then use the view.
Value Set Naming Conventions
Parent and Child Values and Rollup Groups
Example of $FLEX$ Syntax
Precedence of Default Values, Shorthand Entry Values, and COPY Values in Key Flexfields
Value Set Windows
Validation Table Information Window