EBS:值集获取段限定词SQL

EBS R12 值集获取段限定词SQL

SELECT ROWNUM AS "序号"
       ,FFVS.FLEX_VALUE_SET_NAME AS "值集名称"
      , FFV.FLEX_VALUE AS "值"
      -- ,FFV.FLEX_VALUE_MEANING 
       ,FFV.DESCRIPTION AS "说明"
       ,FFV.SUMMARY_FLAG AS "父"
       --,FFV.STRUCTURED_HIERARCHY_LEVEL AS "组"
      , (SELECT HIERARCHY_CODE FROM FND_FLEX_HIERARCHIES_VL FFH
          WHERE FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID 
        AND FFH.HIERARCHY_ID = FFV.STRUCTURED_HIERARCHY_LEVEL) AS "组"
       --,FFVNH.RANGE_ATTRIBUTE
       ,FFVNH.CHILD_FLEX_VALUE_LOW
       ,FFVNH.CHILD_FLEX_VALUE_HIGH 
       ,FFV.COMPILED_VALUE_ATTRIBUTES
       ,SUBSTR( FFV.COMPILED_VALUE_ATTRIBUTES, 1, INSTR(FFV.COMPILED_VALUE_ATTRIBUTES, CHR(10),1)) AS "允许预算"
       ,SUBSTR( FFV.COMPILED_VALUE_ATTRIBUTES, INSTR(FFV.COMPILED_VALUE_ATTRIBUTES, CHR(10),1)+1,1) AS "允许过帐"
FROM  FND_FLEX_VALUE_SETS ffvs,
      FND_FLEX_VALUES_VL FFV, 
      FND_FLEX_VALUE_NORM_HIERARCHY   FFVNH 
WHERE 1=1 
 AND FFVS.FLEX_VALUE_SET_NAME LIKE 'CUX_DEPARTMENT'
 AND FFVS.FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID 
 AND FFV.ENABLED_FLAG = 'Y'
-- AND FFVNH.FLEX_VALUE_SET_ID>0 
-- AND FFVNH.PARENT_FLEX_VALUE = '102'
-- AND FFV.FLEX_VALUE LIKE '500%'
 AND FFV.FLEX_VALUE_SET_ID = FFVNH.FLEX_VALUE_SET_ID(+) 
 AND FFV.FLEX_VALUE = FFVNH.PARENT_FLEX_VALUE(+)
ORDER BY  FFVS.FLEX_VALUE_SET_NAME, FFV.FLEX_VALUE