EBS:会计科目-值集

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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
-- FND_科目.sql
SELECT ffvs.flex_value_set_name as "值集-名称",
       ffvs.description as "值集-说明",
       DECODE(FFVS.VALIDATION_TYPE,'F','表','I','独立',FFVS.VALIDATION_TYPE) AS "验证类型",
       FFV.FLEX_VALUE AS "值",
       FFV.FLEX_VALUE_MEANING AS"转换的值",
       FFV.DESCRIPTION AS "说明",
       (SELECT FFH.HIERARCHY_CODE FROM  APPS.FND_FLEX_HIERARCHIES_VL FFH
        WHERE  FFH.HIERARCHY_ID = FFV.STRUCTURED_HIERARCHY_LEVEL
         AND ROWNUM=1) AS "组",
       FFV.COMPILED_VALUE_ATTRIBUTES AS "限定词",
       SUBSTR( FFV.COMPILED_VALUE_ATTRIBUTES, 1, INSTR(FFV.COMPILED_VALUE_ATTRIBUTES, CHR(10),1)-1) AS "允许预算ID",
       SUBSTR( FFV.COMPILED_VALUE_ATTRIBUTES, INSTR(FFV.COMPILED_VALUE_ATTRIBUTES, CHR(10),1)+1,1) AS "允许过帐ID",
     --  SUBSTR( FFV.COMPILED_VALUE_ATTRIBUTES, INSTR(FFV.COMPILED_VALUE_ATTRIBUTES, CHR(10),3)+1,1) AS "帐户类型ID",
     --  SUBSTR( FFV.COMPILED_VALUE_ATTRIBUTES, INSTR(FFV.COMPILED_VALUE_ATTRIBUTES, CHR(10),5)+1,1) AS "第三方控制帐户ID",
     --  SUBSTR( FFV.COMPILED_VALUE_ATTRIBUTES, INSTR(FFV.COMPILED_VALUE_ATTRIBUTES, CHR(10),7)+1,1) AS "调节ID",
       DECODE(SUBSTR( FFV.COMPILED_VALUE_ATTRIBUTES, 1, INSTR(FFV.COMPILED_VALUE_ATTRIBUTES, CHR(10),1)-1),'Y','是','N','否'AS "允许预算",
       DECODE(SUBSTR( FFV.COMPILED_VALUE_ATTRIBUTES, INSTR(FFV.COMPILED_VALUE_ATTRIBUTES, CHR(10),1)+1,1),'Y','是','N','否'AS "允许过帐",
     --  DECODE(SUBSTR( FFV.COMPILED_VALUE_ATTRIBUTES, INSTR(FFV.COMPILED_VALUE_ATTRIBUTES, CHR(10),3)+1,1),'A','资产','L','负债',
    --      'O','所有权/股东的权益','E','费用','R','收入')  AS "帐户类型",
    --   DECODE(SUBSTR( FFV.COMPILED_VALUE_ATTRIBUTES, INSTR(FFV.COMPILED_VALUE_ATTRIBUTES, CHR(10),5)+1,1),'Y','是','N','否')  AS "第三方控制帐户",
    --   DECODE(SUBSTR( FFV.COMPILED_VALUE_ATTRIBUTES, INSTR(FFV.COMPILED_VALUE_ATTRIBUTES, CHR(10),7)+1,1),'Y','是','N','否')  AS "调节",
       ffv.ENABLED_FLAG AS "启用",
       FFV.SUMMARY_FLAG AS "父" ,
       FFV.VALUE_CATEGORY AS "上下文"-- 弹性域段值(CUX_COA_ACC)
       FFV.ATTRIBUTE1 AS "余额方向",
       FFV.ATTRIBUTE2 AS "费用类别",
       FFV.ATTRIBUTE3 AS "帐户类别"
      -- ,FFV.*
 FROM APPS.FND_FLEX_VALUE_SETS  FFVS, --值集
      APPS.FND_FLEX_VALUES_VL FFV   --科目明细
WHERE ffvs.FLEX_VALUE_SET_ID = ffv.FLEX_VALUE_SET_ID
 -- and FFV.FLEX_VALUE  LIKE '611103%'
  AND FFVS.FLEX_VALUE_SET_NAME LIKE 'CUX_COA%'
  AND FFVS.FLEX_VALUE_SET_NAME NOT IN ( 'CUX_COA_ACC'
ORDER BY   ffvs.flex_value_set_name, FFV.FLEX_VALUE  
 -- 1:A:资产
 --2: L:负债
--4:O: 所有权/股东的权益
-- 51: E: 费用 
--6: R:收入
 
 
 
/*
SELECT * FROM APPS.FND_FLEX_VALUE_SETS  FFVS
 WHERE FFVS.FLEX_VALUE_SET_ID = 1014967
 */

  

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