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
标签:NAME,FDF,查询,APPLICATION,FC,注册,EBS,TABLE,ID From: https://www.cnblogs.com/samrv/p/17217176.html