EBS:查询已经注册的弹性域
EBS R12查询已经注册的弹性域
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 | -- 弹性域字段 SELECT FDF.APPLICATION_ID, ( SELECT FA.APPLICATION_NAME FROM APPS.FND_APPLICATION_VL FA WHERE APPLICATION_ID = FDF.APPLICATION_ID AND ROWNUM = 1 ) AS "应用产品" , FDF.APPLICATION_TABLE_NAME AS "表名" , FDF.TABLE_APPLICATION_ID AS "表应用ID" , ( SELECT FA.APPLICATION_NAME FROM APPS.FND_APPLICATION_VL FA WHERE APPLICATION_ID = FDF.TABLE_APPLICATION_ID AND ROWNUM = 1 ) AS "表应用" , FDF.TITLE AS "标题" , FDF.FORM_CONTEXT_PROMPT AS "上下文提示" , FDF.DESCRIPTION AS "说明" , FDF.CONCATENATED_SEGS_VIEW_NAME AS "DFV视图名称" , FC.COLUMN_NAME AS "列" , DECODE(FC.FLEXFIELD_USAGE_CODE, 'D' , '启用' , 'N' , '未启用' ,FC.FLEXFIELD_USAGE_CODE) AS "列-启用" --,FC.* FROM APPS.FND_DESCRIPTIVE_FLEXS_VL FDF, APPS.FND_TABLES FT , -- 表 APPS.FND_COLUMNS FC -- 字段 WHERE FDF.DESCRIPTIVE_FLEXFIELD_NAME = FC.FLEXFIELD_NAME AND FDF.APPLICATION_ID = FC.FLEXFIELD_APPLICATION_ID AND FDF.TABLE_APPLICATION_ID = FT.APPLICATION_ID AND FDF.APPLICATION_TABLE_NAME = FT.TABLE_NAME AND FT.APPLICATION_ID = FC.APPLICATION_ID AND FT.TABLE_ID = FC.TABLE_ID -- AND FC.COLUMN_NAME LIKE 'GLOBAL_ATTRIBUTE%' --AND FDF.TABLE_APPLICATION_ID = FC.TABLE_ID AND FDF.APPLICATION_TABLE_NAME LIKE 'OE_ORDER_HEADERS_ALL' -- 表应用 ORDER BY FC.APPLICATION_ID,FT.TABLE_NAME,FDF.CONCATENATED_SEGS_VIEW_NAME, FC.COLUMN_ID |
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了