EBS科目--子范围
-- 子范围
SELECT ffvs.flex_value_set_name as "值集-名称",
ffvs.description as "值集-说明",
FVNH.FLEX_VALUE_SET_ID,
FVNH.PARENT_FLEX_VALUE ,
FVNH.CHILD_FLEX_VALUE_LOW AS "自",
FVNH.CHILD_FLEX_VALUE_HIGH AS "至",
FVNH.RANGE_ATTRIBUTE AS "包括ID",
DECODE(FVNH.RANGE_ATTRIBUTE,'C','仅限于子值' ,'仅限于父值') AS "包括"
FROM APPS.FND_FLEX_VALUE_SETS FFVS,
APPS.FND_FLEX_VALUE_NORM_HIERARCHY FVNH
WHERE ffvs.FLEX_VALUE_SET_ID = fvNH.FLEX_VALUE_SET_ID
AND FFVS.FLEX_VALUE_SET_NAME LIKE 'CUX_COA_ACC'
ORDER BY FVNH.PARENT_FLEX_VALUE
标签：FLEX,SET,--,FVNH,VALUE,EBS,ID,科目 From： https://www.cnblogs.com/samrv/p/17402147.html