EBS:FND-弹性域-说明性-段摘要
FND-弹性域-说明性-段摘要
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 | -- FND-弹性域-说明性-段摘要.sql SELECT FA.APPLICATION_NAME AS "应用产品" , FDF.APPLICATION_ID, FDF.DESCRIPTIVE_FLEXFIELD_NAME, FDF.TITLE AS "标题" , FDF.FORM_CONTEXT_PROMPT AS "提示" , --DFC.APPLICATION_ID, --DFC.DESCRIPTIVE_FLEXFIELD_NAME, DFC.DESCRIPTIVE_FLEX_CONTEXT_CODE AS "上下文-代码" , DFC.DESCRIPTIVE_FLEX_CONTEXT_NAME AS "上下文-名称" , DFC.DESCRIPTION AS "上下文-说明" , DFCU.COLUMN_SEQ_NUM AS "序号" , DFCU.DESCRIPTIVE_FLEXFIELD_NAME "名称" , DFCU.APPLICATION_COLUMN_NAME AS "列" , DFCU.FORM_LEFT_PROMPT AS "窗口提示" , --DFCU.FLEX_VALUE_SET_ID, ( SELECT FVS.FLEX_VALUE_SET_NAME -- ,FVS.DESCRIPTION FROM FND_FLEX_VALUE_SETS FVS WHERE FVS.FLEX_VALUE_SET_ID = DFCU.FLEX_VALUE_SET_ID AND ROWNUM = 1 ) AS "值集" FROM APPS.FND_DESCRIPTIVE_FLEXS_VL FDF, -- APPS.FND_DESCR_FLEX_CONTEXTS_VL DFC, -- 上下文字段值 APPS.FND_DESCR_FLEX_COL_USAGE_VL DFCU, APPS.FND_APPLICATION_VL FA where 1=1 AND FDF.APPLICATION_ID = FA.APPLICATION_ID AND DFCU.APPLICATION_ID = 660 -- 订单管理ID AND FDF.APPLICATION_ID = DFC.APPLICATION_ID AND FDF.DESCRIPTIVE_FLEXFIELD_NAME =DFC.DESCRIPTIVE_FLEXFIELD_NAME AND DFCU.APPLICATION_ID = DFC.APPLICATION_ID AND DFCU.DESCRIPTIVE_FLEXFIELD_NAME = DFC.DESCRIPTIVE_FLEXFIELD_NAME <br> AND DFCU.DESCRIPTIVE_FLEX_CONTEXT_CODE = DFC.DESCRIPTIVE_FLEX_CONTEXT_CODE AND DFCU.DESCRIPTIVE_FLEXFIELD_NAME LIKE 'OE_HEADER_ATTRIBUTES' --and DFCU.END_USER_COLUMN_NAME LIKE '%VALUE_SET' -- 字段名称 ORDER BY DFCU.COLUMN_SEQ_NUM |
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了