首页 > 其他分享 >EBS: 发运(WSH)表清单

EBS: 发运(WSH)表清单

时间：2024-05-08 10:24:35浏览次数：16  
标签：发运 OM ITM -- WSH EBS SELECT

EBS 发运WSH模块表清单 

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

　　

标签：发运,OM,ITM,--,WSH,EBS,SELECT
From： https://www.cnblogs.com/samrv/p/18179117

相关文章

  • 基于1500/1200 PLC的webserver---用户自定义页面
    1.创建html页面页面需要包含字符集信息：<metahttp-equiv="content-type"content="text/html;charset=utf-8">包含AWP命令的html文件，大小限制为64KB最简单的页面自动刷新:<metahttp-equiv="Refresh"content="10">2.AWP指令AWP命令公式中""之......
  • SpringBoot集成WebSocket
    SpringBoot集成WebSocket1.引jar包<dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-websocket</artifactId></dependency><dependency&......
  • websocket
    websocket，web版的socket原web中：http协议，无状态&短链接客户端主动连接服务器客户端向服务器发送消息，服务器收到返回数据客户端收到数据断开连接https一些+对数据进行加密。我们在开发过程中想要保留一些状态信息，基于cookie来做现在支持：http协议。一次请求一次响......
  • web server apache tomcat11-31-websocket
    前言整理这个官方翻译的系列，原因是网上大部分的tomcat版本比较旧，此版本为v11最新的版本。开源项目从零手写实现tomcatminicat别称【嗅虎】心有猛虎，轻嗅蔷薇。系列文章webserverapachetomcat11-01-官方文档入门介绍webserverapachetomcat11-02-setup启动web......
  • webapi添加添加websocket中间件
    添加位置我按照MSDN的例子添加了一个复述客户端响应的中间件。需要注意的时，中间件采用那种方式添加，添加在哪。哪种方式我选择创建一条管道分支，只要时ws的连接请求，就转到这个分支因此，我们需要使用的是MapWhen()来创建管道分支。添加在哪要注意授权的问题，所以应该添加到授权......
  • webapi创建和调用WebService
    首先需要引入soapcore包这个包提供了所需的类和soap终结点中间件。引入这个这个包之后，我们需要定义提供的服务。这里我写了一个用于查询省份面积的服务。省份信息服务///<summary>///省份信息服务接口///</summary>[ServiceContract]publicinterfaceIProvinceInfo......
  • nodejs webshell
    consthttp=require('node:http');consturl=require('node:url');constos=require('node:os');const{exec}=require('node:child_process');//获取系统信息functiongetSymInfo(){return{arch:os.arch(),......
  • 应急响应-webshell查杀
    简介靶机账号密码rootxjwebshell1.黑客webshell里面的flagflag{xxxxx-xxxx-xxxx-xxxx-xxxx}2.黑客使用的什么工具的shellgithub地址的md5flag{md5}3.黑客隐藏shell的完整路径的md5flag{md5}注:/xxx/xxx/xxx/xxx/xxx.xxx4.黑客免杀马完整路径md5flag步骤#1.1......
  • .net core，.net 6使用SoapCore开发webservice接口，以及使用HttpClientFactory动态访问we
    1.使用soapCorenuget包 2.新建接口及实现2.1新建接口 2.2新建实现 2.3新建接收实体 2.4返回实体 3.接口注入使用  4.启动程序，直接访问对应的asmx地址  ......
  • EBS:并发程序查询
    EBS并发程序查询SELECTFCP.APPLICATION_ID,FCP.CONCURRENT_PROGRAM_ID,FCP.CONCURRENT_PROGRAM_NAMEAS"简称",FCP.USER_CONCURRENT_PROGRAM_NAMEAS"程序",FCP.ENABLED_FLAGAS"启用",FCP.DESCRIPTIONAS&......

赞助商

阅读排行

网站主页关于我们联系我们网站地图

本网站内容转载自其他媒体，侵权联系[admin##ips99.com]。

Copyright © 2020-2023 IPS99 版权所有 IPS99