EBS:FND-弹性域-说明性-段摘要

FND-弹性域-说明性-段摘要

-- FND-弹性域-说明性-段摘要.sql  
SELECT FA.APPLICATION_NAME AS "应用产品",
       FDF.APPLICATION_ID,
       FDF.DESCRIPTIVE_FLEXFIELD_NAME,
       FDF.TITLE AS "标题",
       FDF.FORM_CONTEXT_PROMPT AS "提示",
       --DFC.APPLICATION_ID,
       --DFC.DESCRIPTIVE_FLEXFIELD_NAME,
       DFC.DESCRIPTIVE_FLEX_CONTEXT_CODE AS "上下文-代码", 
       DFC.DESCRIPTIVE_FLEX_CONTEXT_NAME AS "上下文-名称",
       DFC.DESCRIPTION AS "上下文-说明",
       DFCU.COLUMN_SEQ_NUM AS "序号",
       DFCU.DESCRIPTIVE_FLEXFIELD_NAME "名称",
       DFCU.APPLICATION_COLUMN_NAME AS "列",
       DFCU.FORM_LEFT_PROMPT AS "窗口提示", 
       --DFCU.FLEX_VALUE_SET_ID,
       ( SELECT FVS.FLEX_VALUE_SET_NAME -- ,FVS.DESCRIPTION
          FROM  FND_FLEX_VALUE_SETS  FVS 
         WHERE FVS.FLEX_VALUE_SET_ID = DFCU.FLEX_VALUE_SET_ID
          AND ROWNUM = 1 
         ) AS "值集" 
  FROM APPS.FND_DESCRIPTIVE_FLEXS_VL FDF, -- 
       APPS.FND_DESCR_FLEX_CONTEXTS_VL DFC,  -- 上下文字段值 
       APPS.FND_DESCR_FLEX_COL_USAGE_VL DFCU,
       APPS.FND_APPLICATION_VL FA  
 where 1=1 
   AND FDF.APPLICATION_ID = FA.APPLICATION_ID 
   AND DFCU.APPLICATION_ID = 660  -- 订单管理ID 
   AND FDF.APPLICATION_ID = DFC.APPLICATION_ID 
   AND FDF.DESCRIPTIVE_FLEXFIELD_NAME =DFC.DESCRIPTIVE_FLEXFIELD_NAME
   AND DFCU.APPLICATION_ID = DFC.APPLICATION_ID 
   AND DFCU.DESCRIPTIVE_FLEXFIELD_NAME = DFC.DESCRIPTIVE_FLEXFIELD_NAME 
   AND DFCU.DESCRIPTIVE_FLEX_CONTEXT_CODE = DFC.DESCRIPTIVE_FLEX_CONTEXT_CODE 
   AND DFCU.DESCRIPTIVE_FLEXFIELD_NAME LIKE 'OE_HEADER_ATTRIBUTES'
   --and DFCU.END_USER_COLUMN_NAME LIKE '%VALUE_SET'  -- 字段名称 
 ORDER BY DFCU.COLUMN_SEQ_NUM