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' |
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了