EBS: Oracle XML Publisher 表清单

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72

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