In this article I’ll show you the tables and sql query for the Main Flex Fields Segments value sets. When compared to Oracle r12, these value set tables have been fully rewritten in Fusion. Fetch Key Flex Fields Segment Values and Description using the SQL query below.
Advanced Features of Key Flexfields in Oracle Fusion
Advanced features such as code combination filters and comparison mode are available in key Flexfields. Code combination constraints are the parameters for filtering the list of code combinations that can be referenced in a specified combinations table. Combination constraints are view object properties, not entity object properties. Secondary storage is used when there is no clear connection between the commodity table and the main flexfields combinations table.
KFF Value Set Tables in Oracle Fusion
SQL Query to get KFF values in Oracle Fusion
SELECT * FROM FND_VS_VALUE_SETS a1, FND_VS_VALUES_B a2 WHERE a1.VALUE_SET_CODE=:KFF_SEGMENT_NAME AND a1.VALUE_SET_ID =a2.VALUE_SET_ID;