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

  

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