说明性弹性域、键弹性域-CSDN博客

本文链接：https://blog.csdn.net/u012985973/article/details/38533083

      fnd_descr_flex.define( BLOCK=>'ASSET',                 --数据块
                             FIELD=>'DF',                    --项
                             APPL_SHORT_NAME=>'OFA',         --应用
                             DESC_FLEX_NAME=>'FA_ADDITIONS');--说明性弹性域代码

select dfv.TITLE,dfv.DESCRIPTIVE_FLEXFIELD_NAME,dfv.DEFAULT_CONTEXT_FIELD_NAME,
       dfcv.DESCRIPTIVE_FLEX_CONTEXT_CODE,dfcv.DESCRIPTIVE_FLEX_CONTEXT_NAME,
       dfcu.END_USER_COLUMN_NAME,dfcu.FORM_LEFT_PROMPT,dfcu.APPLICATION_COLUMN_NAME,dfcu.DESCRIPTIVE_FLEX_CONTEXT_CODE,
       dfcu.FLEX_VALUE_SET_ID
  from apps.FND_DESCRIPTIVE_FLEXS_VL dfv,apps.FND_DESCR_FLEX_CONTEXTS_VL dfcv,apps.FND_DESCR_FLEX_COL_USAGE_VL dfcu
 where -1 = -1
   and dfv.DESCRIPTIVE_FLEXFIELD_NAME = dfcv.DESCRIPTIVE_FLEXFIELD_NAME
   and dfcv.DESCRIPTIVE_FLEXFIELD_NAME = dfcu.DESCRIPTIVE_FLEXFIELD_NAME
   and dfcv.DESCRIPTIVE_FLEX_CONTEXT_CODE = dfcu.DESCRIPTIVE_FLEX_CONTEXT_CODE
   --and dfv.TITLE like '资产类别' --说明性弹性域标题
   and dfcv.DESCRIPTIVE_FLEXFIELD_NAME = 'GL_IEA_TRANSACTION_LINES' --说明性弹性域代码
   --and dfcu.END_USER_COLUMN_NAME = '退回类型'
   --and dfcv.DESCRIPTIVE_FLEX_CONTEXT_NAME like '%退回类型%'/*'%寿险%业务%'*/
   --and dfcv.DESCRIPTIVE_FLEX_CONTEXT_CODE like '长期待摊费用.车辆租赁%'

      fnd_key_flex.define( BLOCK=>'ASSET',                   --数据块
                           FIELD=>'ATTRIBUTE_CATEGORY_CODE', --项
                           ID=>'ASSET_CATEGORY_ID',          --
                           APPL_SHORT_NAME=>'OFA',           --
                           CODE=>'CAT#',                     --
                           NUM=>':GLOBAL.CAT_FLEX_NUM',      --
                           VALIDATE=>'FULL',                 --
                           LONGLIST=>'N',                    --
                           QBE_IN=>'Y',                      --
                           usedbflds=>'N');                  --

select if.application_id,if.id_flex_code,if.id_flex_name,if.application_table_name,
       ifsv.ID_FLEX_STRUCTURE_CODE,ifsv.ID_FLEX_STRUCTURE_NAME,
       ifs.id_flex_num,ifs.segment_name,ifs.flex_value_set_id
  from fnd_id_flexs if,fnd_id_flex_structures_vl ifsv,fnd_id_flex_segments ifs
 where -1 = -1 
   and if.id_flex_code = ifsv.ID_FLEX_CODE
   and ifsv.id_flex_code = ifs.id_flex_code
   and ifsv.id_flex_num = ifs.id_flex_num
   --and if.id_flex_code = 'KEY#'--'BUSS'
   --and if.id_flex_name = 'CUX_BUSINESS_TYPE'
   and ifsv.id_flex_structure_name like '%资产类别%'/*'寿险业务类型弹性域'*/
   --and if.id_flex_code = 'GL#'