Scripts - Flexfield Values

Key Flexfields are stored in the following tables:

1. FND_FLEX_VALUE_SETS


2. FND_FLEX_VALUES

SELECT *
FROM FND_FLEX_VALUES
WHERE FLEX_VALUE_SET_ID =
(
SELECT FLEX_VALUE_SET_ID
FROM FND_FLEX_VALUE_SETS
WHERE FLEX_VALUE_SET_NAME = :VALUE_SET_NAME
)
AND ENABLED_FLAG = 'Y' -- For Active Values
AND SUMMARY_FLAG = 'N' -- For Child Values

Pass the Value Set Name as Parameter