Oracle Applications

Oracle for Beginners

Scripts – Flexfield Values

Posted by shameemakhtar on June 19, 2009

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s