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'

  

posted @   samrv  阅读(120)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
点击右上角即可分享
微信分享提示