EBS: Oracle XML Publisher 表清单
-- Oracle XML Publisher 表清单 SELECT * FROM XDO.XDO_CONCURRENT_REQUESTS_GT SELECT * FROM XDO.XDO_CONFIG_KEYS -- KEY: PROPERTY_CODE -- 配置属性 SELECT * FROM XDO_CONFIG_PROPERTIES_VL XCP SELECT * FROM XDO.XDO_CONFIG_PROPERTIES_B SELECT * FROM XDO.XDO_CONFIG_PROPERTIES_TL -- KEY: PROPERTY_CODE ,VALUE_ID -- 配置属性 SELECT * FROM XDO.XDO_CONFIG_VALUES SELECT * FROM XDO.XDO_CURRENCY_FORMATS SELECT * FROM XDO_CURRENCY_FORMAT_SETS_VL SELECT * FROM XDO.XDO_CURRENCY_FORMAT_SETS_B SELECT * FROM XDO.XDO_CURRENCY_FORMAT_SETS_TL SELECT * FROM XDO.XDO_DGF_BLOCK_CONTEXTS SELECT * FROM XDO.XDO_DGF_RPT_CONTEXTS SELECT * FROM XDO.XDO_DGF_RPT_CONTEXT_PARAMETERS SELECT * FROM XDO.XDO_DGF_RULE_CATALOG_B SELECT * FROM XDO.XDO_DGF_RULE_CATALOG_TL SELECT * FROM XDO.XDO_DGF_TPL_CONTEXTS SELECT * FROM XDO.XDO_DGF_TPL_RULES -- KEY: APPLICATION_SHORT_NAME,DATA_SOURCE_CODE --N: Oracle XML Publisher>>主页>>数据定义 SELECT * FROM XDO_DS_DEFINITIONS_VL XDD WHERE APPLICATION_SHORT_NAME = 'CUX' SELECT * FROM XDO.XDO_DS_DEFINITIONS_B XDDB SELECT * FROM XDO.XDO_DS_DEFINITIONS_TL XDDT SELECT * FROM XDO.XDO_EFT_SEQUENCE_NAMES -- KEY: MAPPING_CODE -- 字体对照表 SELECT * FROM XDO.XDO_FONT_MAPPINGS XFM WHERE MAPPING_CODE = 'Code 128' -- KEY: MAPPING_CODE -- 字体对照集 SELECT * FROM XDO_FONT_MAPPING_SETS_VL XFMS WHERE MAPPING_CODE = 'Code 128' SELECT * FROM XDO.XDO_FONT_MAPPING_SETS_B SELECT * FROM XDO.XDO_FONT_MAPPING_SETS_TL -- LOB_CODE : 一般为 XDO_DS_DEFINITIONS_VL.DATA_SOURCE_CODE 数据定义代码 -- KEY: APPLICATION_SHORT_NAME,LOB_CODE -- 存储着模板文件、数据文件源文件 SELECT * FROM XDO.XDO_LOBS XL WHERE APPLICATION_SHORT_NAME ='CUX' AND LOB_CODE LIKE 'CUXWIPBACKUP%' -- AND FILE_NAME LIKE 'HSSARXCT_TMP%' -- KEY: APPLICATION_SHORT_NAME, TEMPLATE_CODE --N: Oracle XML Publisher>>主页>>模板 SELECT * FROM APPS.XDO_TEMPLATES_VL XT WHERE XT.APPLICATION_SHORT_NAME = 'CUX' AND XT.TEMPLATE_CODE LIKE 'CUX%' -- 代码 SELECT * FROM XDO.XDO_TEMPLATES_B XTB SELECT * FROM XDO.XDO_TEMPLATES_TL XTT SELECT * FROM XDO.XDO_TEMPLATE_FIELDS XTF WHERE APPLICATION_SHORT_NAME = 'CUX' AND TEMPLATE_CODE = 'CUXCGMTLISTCK' -- -- KEY: APPLICATION_SHORT_NAME, TEMPLATE_CODE,UNIT_ID SELECT * FROM XDO.XDO_TRANS_UNITS WHERE APPLICATION_SHORT_NAME = 'CUX' AND TEMPLATE_CODE = 'CUXWIPDNOTE' SELECT * FROM XDO.XDO_TRANS_UNIT_PROPS WHERE APPLICATION_SHORT_NAME = 'CUX' SELECT * FROM XDO.XDO_TRANS_UNIT_VALUES WHERE APPLICATION_SHORT_NAME = 'CUX'
优质生活从拆开始