EBS:科目--子范围

EBS科目--子范围

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

-- 子范围 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