EBS:科目--子范围

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