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