EBS:值集获取段限定词SQL

EBS R12 值集获取段限定词SQL

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
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

  

 

 

posted @   samrv  阅读(260)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
点击右上角即可分享
微信分享提示