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 ; |
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
2023-11-25 ORACLE: BULK COLLECT批量处理
2020-11-25 Oracle- 优化SQL(二)