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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
-- N: 税务管理员>>默认值和控制>>应用产品税选项
-- 应用产品税选项
SELECT HOU.SHORT_CODE ||'-'|| HOU.NAME AS ORG_NAME ,
       FA.APPLICATION_SHORT_NAME||'-'||FA.APPLICATION_NAME AS "应用程序名称",
       DEF_OPTION_HIER_1_CODE AS "默认顺序1",
       CASE ZPO.APPLICATION_ID WHEN 201 THEN
         (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE = 'ZX_PO_DEFAULT_HIERARCHY' --'ZX_TAX_METHOD_OPTIONS'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_1_CODE)
          WHEN 200 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE = 'ZX_AP_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_1_CODE)
          WHEN 8407 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE = 'ZX_IGC_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_1_CODE)
          WHEN 222 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE ='ZX_AR_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_1_CODE)
          WHEN 275 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE ='ZX_PA_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_1_CODE
          ) ELSE  ZPO.DEF_OPTION_HIER_1_CODE
          END AS DEF_OPTION_HIER_1_NAME,
         DEF_OPTION_HIER_2_CODE AS "默认顺序2",
         CASE ZPO.APPLICATION_ID WHEN 201 THEN
         (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE = 'ZX_PO_DEFAULT_HIERARCHY' --'ZX_TAX_METHOD_OPTIONS'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_2_CODE)
          WHEN 200 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE = 'ZX_AP_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_2_CODE)
          WHEN 8407 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE = 'ZX_IGC_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_2_CODE)
          WHEN 222 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE ='ZX_AR_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_2_CODE)
          WHEN 275 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE ='ZX_PA_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_2_CODE
          ) ELSE  ZPO.DEF_OPTION_HIER_2_CODE
          END AS DEF_OPTION_HIER_2_NAME, 
         DEF_OPTION_HIER_3_CODE AS "默认顺序3",
         CASE ZPO.APPLICATION_ID WHEN 201 THEN
         (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE = 'ZX_PO_DEFAULT_HIERARCHY' --'ZX_TAX_METHOD_OPTIONS'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_3_CODE)
          WHEN 200 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE = 'ZX_AP_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_3_CODE)
          WHEN 8407 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE = 'ZX_IGC_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_3_CODE)
          WHEN 222 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE ='ZX_AR_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_3_CODE)
          WHEN 275 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE ='ZX_PA_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_3_CODE
          ) ELSE  ZPO.DEF_OPTION_HIER_3_CODE
          END AS DEF_OPTION_HIER_3_NAME,
         DEF_OPTION_HIER_4_CODE AS "默认顺序4",
         CASE ZPO.APPLICATION_ID WHEN 201 THEN
         (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE = 'ZX_PO_DEFAULT_HIERARCHY' --'ZX_TAX_METHOD_OPTIONS'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_4_CODE)
          WHEN 200 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE = 'ZX_AP_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_4_CODE)
          WHEN 8407 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE = 'ZX_IGC_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_4_CODE)
          WHEN 222 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE ='ZX_AR_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_4_CODE)
          WHEN 275 THEN
          (SELECT MEANING FROM APPS.FND_LOOKUP_VALUES_VL  FLV 
          WHERE  FLV.LOOKUP_TYPE ='ZX_PA_DEFAULT_HIERARCHY'
          AND FLV.LOOKUP_CODE = ZPO.DEF_OPTION_HIER_4_CODE
          ) ELSE  ZPO.DEF_OPTION_HIER_4_CODE
          END AS DEF_OPTION_HIER_4_NAME,
         TAX_CLASSIFICATION_CODE AS "财务选项税分类"
        ,ZPO.*
  FROM ZX.ZX_PRODUCT_OPTIONS_ALL ZPO,
       APPS.HR_OPERATING_UNITS HOU,
       APPS.FND_APPLICATION_VL FA
 where 1=1 -- AND ZPO.LAST_UPDATE_DATE > SYSDATE - 1
  AND ZPO.ORG_ID = HOU.organization_id
  AND ZPO.APPLICATION_ID = FA.APPLICATION_ID
ORDER BY ZPO.ORG_ID , ZPO.APPLICATION_ID ;

  

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