EBS: 发运(WSH)表清单

EBS 发运WSH模块表清单 

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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
SELECT * FROM WSH.WSH_ACTIVITY_GROUPS
 
SELECT * FROM WSH.WSH_CALENDAR_ASSIGNMENTS
 
--
-- N:OM>>设置>>发运>>承运人,成本类型>>承运人
SELECT * FROM  APPS.WSH_CARRIERS_V WC
 WHERE CARRIER_ID = 800774
 
-- N:OM>>设置>>发运>>承运人,成本类型>>承运人
SELECT * FROM WSH.WSH_CARRIERS WC
 WHERE CARRIER_ID = 800774
 
-- N:OM>>设置>>发运>>承运人,成本类型>>承运人 之 服务。
SELECT * FROM WSH.WSH_CARRIER_SERVICES
 WHERE CARRIER_ID = 800774
  
-- N:OM>>设置>>发运>>承运人,成本类型>>承运人 之 发运方法
SELECT * FROM WSH.WSH_CARRIER_SHIP_METHODS
 WHERE  CARRIER_ID = 800774
 
-- N:OM>>设置>>发运>>承运人,成本类型>>承运人 之 地点
SELECT * FROM WSH.WSH_CARRIER_SITES
 
-- N:OM>>设置>>发运>>承运人,成本类型>>承运人 之 运输工具类型
SELECT * FROM WSH.WSH_CARRIER_VEHICLE_TYPES
 
SELECT * FROM WSH.WSH_CC_ADAPTER_STATUS
 
SELECT * FROM WSH.WSH_CC_DENIED_PARTIES
 
SELECT * FROM WSH.WSH_CC_PARAMETER_SETUPS_B
 
SELECT * FROM WSH.WSH_CC_PARAMETER_SETUPS_TL
 
SELECT * FROM WSH.WSH_CC_REQUEST_SETUPS
 
SELECT * FROM WSH.WSH_CC_RESPONSE_HEADERS
 
SELECT * FROM WSH.WSH_CC_RESPONSE_LINES
 
SELECT * FROM WSH.WSH_CC_SERVICE_SETUPS
 
SELECT * FROM WSH.WSH_CC_TRANS_CONTROL
 
SELECT * FROM WSH.WSH_CC_TRANS_HEADERS
 
SELECT * FROM WSH.WSH_CC_TRANS_LINES
 
SELECT * FROM WSH.WSH_CC_USER_SETUPS
 
SELECT * FROM WSH.WSH_CONSOL_BATCHES
 
SELECT * FROM WSH.WSH_CONSOL_GROUPING_RULES
 
SELECT * FROM WSH.WSH_CONSTRAINT_DLEG_TMP
 
SELECT * FROM WSH.WSH_CONTAINER_ITEMS
 
SELECT * FROM WSH.WSH_CUSTOMIZED_ACTIVITY_MSGS
 
SELECT * FROM WSH.WSH_DD_TXNS
 
-- N:OM>>发运>>事务处理
SELECT * FROM WSH.WSH_DELIVERY_ASSIGNMENTS
 
-- N:OM>>发运>>事务处理
SELECT * FROM WSH.WSH_DELIVERY_DETAILS
 
SELECT * FROM WSH.WSH_DELIVERY_LEGS
 
SELECT * FROM WSH.WSH_DELIVERY_LEG_ACTIVITIES
 
SELECT * FROM WSH.WSH_DELIVERY_LEG_DETAILS
 
SELECT * FROM WSH.WSH_DEL_ASSGN_INTERFACE
 
SELECT * FROM WSH.WSH_DEL_DETAILS_INTERFACE
 
SELECT * FROM WSH.WSH_DEL_LEGS_INTERFACE
 
SELECT * FROM WSH.WSH_DEL_WV_UPGRADE_TMP
 
SELECT * FROM WSH.WSH_DETAIL_SSHIPUNITS
 
SELECT * FROM WSH.WSH_DOCUMENT_INSTANCES
 
--N:OM>>设置>>发运>>文档>>单据类别。
SELECT * FROM WSH.WSH_DOC_SEQUENCE_CATEGORIES
 
--N:OM>>设置>>发运>>文档>>单据类别。
SELECT * FROM  apps.wsh_doc_sequence_categories_v
 
-- 发运例外
SELECT * FROM WSH.WSH_EXCEPTIONS
 
SELECT * FROM WSH.WSH_EXCEPTION_DEFINITIONS_B
 
SELECT * FROM WSH.WSH_EXCEPTION_DEFINITIONS_TL
 
SELECT * FROM WSH.WSH_FOLDER_CUSTOM_ACTIONS
 
SELECT * FROM WSH.WSH_FOLDER_EXTENSIONS
 
--N: OM>>设置>>发运>>承运人>>承运人,成本类型>>运费成本类型。
SELECT * FROM WSH.WSH_FREIGHT_COSTS
 
SELECT * FROM WSH.WSH_FREIGHT_COSTS_EFC
 
SELECT * FROM WSH.WSH_FREIGHT_COSTS_INTERFACE
 
--N: OM>>设置>>发运>>承运人>>承运人,成本类型>>运费成本类型。
SELECT * FROM WSH.WSH_FREIGHT_COST_TYPES WFCT
 WHERE WFCT.NAME LIKE 'OTM Freight Cost'
 
SELECT * FROM  APPS.wsh_freight_cost_types_v
 
SELECT * FROM WSH.WSH_FTE_COMP_CLASSES
 
SELECT * FROM WSH.WSH_FTE_COMP_CONSTRAINTS
 
-- N:OM>>设置>>发运>>全局参数
SELECT * FROM WSH.WSH_GLOBAL_PARAMETERS
 
-- N:OM>>设置>>发运>>权限和职责定义>>权限
SELECT * FROM WSH.WSH_GRANTS WG
 
SELECT * FROM  APPS.wsh_grants_v WG
 
SELECT * FROM WSH.WSH_GTC_RESPONSE_RULES
 
SELECT * FROM WSH.WSH_INBOUND_DEL_LINES_TEMP
 
SELECT * FROM WSH.WSH_INBOUND_TXN_HISTORY
 
-- 发运接口错误信息表
SELECT * FROM WSH.WSH_INTERFACE_ERRORS
 
SELECT * FROM WSH.WSH_ITM_ADAPTER_STATUS
 
SELECT * FROM WSH.WSH_ITM_DENIED_PARTIES
 
SELECT * FROM WSH.WSH_ITM_ITEMS
 
SELECT * FROM WSH.WSH_ITM_PARAMETER_SETUPS_B
 
SELECT * FROM WSH.WSH_ITM_PARAMETER_SETUPS_TL
 
SELECT * FROM WSH.WSH_ITM_PARTIES
 
SELECT * FROM WSH.WSH_ITM_PARTY_CONTACTS
 
SELECT * FROM WSH.WSH_ITM_REQUEST_CONTROL
 
SELECT * FROM WSH.WSH_ITM_RESPONSE_HEADERS
 
SELECT * FROM WSH.WSH_ITM_RESPONSE_LINES
 
SELECT * FROM WSH.WSH_ITM_RESPONSE_RULES
 
SELECT * FROM WSH.WSH_ITM_SERIAL_NUMBERS
 
SELECT * FROM WSH.WSH_ITM_SERVICE_PARAMETERS
 
SELECT * FROM WSH.WSH_ITM_SERVICE_PREFERENCES
 
SELECT * FROM WSH.WSH_ITM_USER_SETUPS
 
SELECT * FROM WSH.WSH_ITM_VENDORS
 
SELECT * FROM WSH.WSH_ITM_VENDOR_PARAMETERS
 
SELECT * FROM WSH.WSH_ITM_VENDOR_SERVICES
 
SELECT * FROM WSH.WSH_ITM_VENDOR_STYLESHEETS
 
SELECT * FROM WSH.WSH_LOCATIONS
 
SELECT * FROM WSH.WSH_LOCATION_DATA_EXT
 
SELECT * FROM WSH.WSH_LOCATION_OWNERS
 
SELECT * FROM WSH.WSH_LPN_PURGE_TMP
 
SELECT * FROM WSH.WSH_MESSAGE_ATTACHMENT
 
-- N:OM>>发运>>事务处理
-- 挑库发运交货表
SELECT * FROM WSH.WSH_NEW_DELIVERIES WND
 
-- 挑库发运交货接口表
SELECT * FROM WSH.WSH_NEW_DEL_INTERFACE
 
SELECT * FROM WSH.WSH_ORG_CARRIER_SERVICES
 
SELECT * FROM WSH.WSH_ORG_CARRIER_SITES
 
SELECT * FROM WSH.WSH_OTM_LOCATIONS_GTMP
 
SELECT * FROM WSH.WSH_OTM_LOC_CONTACTS_GTMP
 
SELECT * FROM WSH.WSH_OTM_SYNC_REF_DATA
 
SELECT * FROM WSH.WSH_OTM_SYNC_REF_DATA_LOG
 
--
-- N:OM>>发运>>事务处理
SELECT * FROM WSH.WSH_PICKING_BATCHES
 
-- N:OM>>设置>>发运>>挑库>>定义发放规则表单
-- 挑库规则
SELECT * FROM WSH.WSH_PICKING_RULES
 
-- N:OM>>设置>>发运>>挑库>>定义挑库单分组规则
-- 挑库组规则
SELECT * FROM WSH.WSH_PICK_GROUPING_RULES
 
-- N:OM>>设置>>发运>>挑库>>定义发放序列规则
-- 挑库序号规则
SELECT * FROM WSH.WSH_PICK_SEQUENCE_RULES
 
SELECT * FROM WSH.WSH_PR_HEADER_HOLDS
 
SELECT * FROM WSH.WSH_PR_WORKERS WPW
 WHERE WPW.ORGANIZATION_ID = 101
 
SELECT * FROM WSH.WSH_QUERY_ASSIGNMENTS
 
-- N:OM>>设置>>发运>>区域和地区>>区域和地区
SELECT * FROM WSH.WSH_REGIONS
 
SELECT * FROM WSH.WSH_REGIONS_GLOBAL
 
SELECT * FROM WSH.WSH_REGIONS_GLOBAL_DATA
 
-- N:OM>>设置>>发运>>区域和地区>>区域接口
SELECT * FROM WSH.WSH_REGIONS_INTERFACE
 
SELECT * FROM WSH.WSH_REGIONS_TL
 
SELECT * FROM WSH.WSH_REGIONS_TL_INTERFACE
 
SELECT * FROM WSH.WSH_REGION_LOCATIONS
 
SELECT * FROM WSH.WSH_REPORT_PRINTERS
 
--
-- N:OM>>设置>>发运>>区域和地区>>中转时间 之 发运方法
SELECT * FROM  APPS.MTL_INTERORG_SHIP_METHODS
 
--N: OM>>设置>>发运>>文档>>单据集
-- 单据集
SELECT * FROM WSH.WSH_REPORT_SETS
 
--N: OM>>设置>>发运>>文档>>单据集
-- 单据集 之单据行
SELECT * FROM WSH.WSH_REPORT_SET_LINES
 
-- 发运规则
-- N:OM>>设置>>发运>>权限和职责定义>>定义职责
SELECT * FROM WSH.WSH_ROLES WR
 where WR.NAME LIKE '一键式发运权限'
 
SELECT * FROM WSH.WSH_ROLE_PRIVILEGES WRP
 WHERE WRP.ROLE_ID = 24
 
SELECT * FROM WSH.WSH_SAVED_QUERIES_B
 
SELECT * FROM APPS.wsh_lookups
 WHERE MEANING LIKE '延交' -- '自动创建交货'
 
SELECT * FROM WSH.WSH_SAVED_QUERIES_TL
 
SELECT * FROM WSH.WSH_SERIAL_NUMBERS
 
SELECT * FROM WSH.WSH_SHIPMENT_BATCHES
 
-- N:OM>>设置>>发运>>发运参数
SELECT * FROM WSH.WSH_SHIPPING_PARAMETERS
 
SELECT * FROM WSH.WSH_SHIPPING_PARAMETER_VALUES
 
--
-- N:OM>>设置>>发运>>全局参数
SELECT * FROM  WSH.WSH_GLOBAL_PARAMETERS
 
-- N:OM>>设置>>发运>>发运确认规则
-- 发运确认规则
SELECT * FROM WSH.WSH_SHIP_CONFIRM_RULES
 
SELECT * FROM WSH.WSH_TMP
 
SELECT * FROM WSH.WSH_TMS_BATCHES
 
SELECT * FROM WSH.WSH_TMS_SUB_BATCHES
 
SELECT * FROM WSH.WSH_TRANSACTIONS_HISTORY
 
SELECT * FROM WSH.WSH_TRIPS
 
SELECT * FROM WSH.WSH_TRIPS_INTERFACE
 
SELECT * FROM WSH.WSH_TRIP_STOPS
 
SELECT * FROM WSH.WSH_TRIP_STOPS_INTERFACE
 
SELECT * FROM WSH.WSH_UPGRADE_LOG
 
SELECT * FROM WSH.WSH_UPGRADE_PLD_TMP
 
SELECT * FROM WSH.WSH_UPGRADE_SITE_TMP
 
SELECT * FROM WSH.WSH_UPGRADE_TMP
 
SELECT * FROM WSH.WSH_WMS_SYNC_TMP
 
SELECT * FROM WSH.WSH_ZONE_REGIONS

  

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