EBS:查询已经注册的弹性域

EBS R12查询已经注册的弹性域 

-- 弹性域字段
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