Oracle EBS 值层次结构查询SQL

Oracle EBS 值层次结构查询SQL 

-- 查看层次结构

-- 值层次结构

SELECT ffvcv.flex_value -- 子值

,ffvcv.description -- 说明

,ffvcv.summary_flag --是否为父级

,ffvcv.parent_flex_value --父值

FROM fnd_flex_value_children_v ffvcv

,fnd_flex_value_sets ffvs

WHERE ffvcv.flex_value_set_id = ffvs.FLEX_VALUE_SET_ID

AND ffvs.flex_value_set_name = &flex_value_set_name

AND ffvcv.flex_value = &flex_value

ORDER BY flex_value

;

--刘轶鹤