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'