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
标签：值集,SET,FLEX,FFV,VALUE,ID,限定词,SQL,FFVNH From： https://www.cnblogs.com/samrv/p/16750103.html