说明性弹性域、键弹性域

来源：互联网发布：在线网络视频下载工具编辑：程序博客网时间：2024/05/16 07:56

      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#'

0 0