Monday, March 31, 2014

Oracle EBS - How get values of Value Sets

SELECT L.FLEX_VALUE
   FROM FND_FLEX_VALUE_SETS H,
               FND_FLEX_VALUES_VL L
WHERE H.FLEX_VALUE_SET_NAME = 'XX_VALUE_SET_NAME'
     AND L.FLEX_VALUE_SET_ID   = H.FLEX_VALUE_SET_ID
     AND L.ENABLED_FLAG        = 'Y';

No comments:

Post a Comment