Oracle Ebs 值集信息查询

SELECT FFS.FLEX_VALUE_SET_ID,
       FFS.FLEX_VALUE_SET_NAME,
       FFV.FLEX_VALUE,
       FLV.FLEX_VALUE_MEANING,
       FLV.DESCRIPTION
  FROM APPLSYS.FND_FLEX_VALUE_SETS FFS,
       FND_FLEX_VALUES             FFV,
       FND_FLEX_VALUES_TL          FLV
 WHERE FFS.FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID
   AND FFS.FLEX_VALUE_SET_NAME = 'KH_GL_PROJECT'
   AND FFV.FLEX_VALUE_ID = FLV.FLEX_VALUE_ID
   AND FLV.LANGUAGE = USERENV('LANG');