WSH Tables (107)

WSH - Shipping Execution — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
WSH_ACTIVITY_GROUPS 27 Activity Groups
WSH_CALENDAR_ASSIGNMENTS 42 Calendar Assignments
WSH_CARRIERS 70 Shipping Carrier Information
WSH_CARRIER_SERVICES 72 Carrier Services Information
WSH_CARRIER_SHIP_METHODS 35 Carrier Ship Methods
WSH_CARRIER_SITES 18 Carrier Sites
WSH_CARRIER_VEHICLE_TYPES 24 Stores Vehicles associated to Carriers
WSH_CC_ADAPTER_STATUS 10 Internal Use
WSH_CC_DENIED_PARTIES 5 Clear Cross Denied Parties
WSH_CC_PARAMETER_SETUPS_B 10 Parameter Setup Base table
WSH_CC_PARAMETER_SETUPS_TL 10 Parameter Setups Translated Information
WSH_CC_REQUEST_SETUPS 22 Request Setup Information
WSH_CC_RESPONSE_HEADERS 30 Response Header Information
WSH_CC_RESPONSE_LINES 28 Response Lines Information
WSH_CC_SERVICE_SETUPS 25 Service Setup Information
WSH_CC_TRANS_CONTROL 32 Transaction Control Table
WSH_CC_TRANS_HEADERS 81 Transaction Headers Interface Table
WSH_CC_TRANS_LINES 96 Transaction Lines Interface Table
WSH_CC_USER_SETUPS 12 User Setup Information
WSH_CONTAINER_ITEMS 31 Container and Item Load Relationships
WSH_DELIVERY_ASSIGNMENTS 16 Delivery Assignments
WSH_DELIVERY_DETAILS 210 Delivery Details
WSH_DELIVERY_LEGS 68 Delivery Legs
WSH_DELIVERY_LEG_ACTIVITIES 41 Delivery Leg Activities
WSH_DELIVERY_LEG_DETAILS 25 Delivery Leg Delivery Line information
WSH_DEL_ASSGN_INTERFACE 26 Delivery Assignment Interface Table
WSH_DEL_DETAILS_INTERFACE 214 Delivery Detail interface Table
WSH_DEL_LEGS_INTERFACE 57 Delivery Legs Interface Table
WSH_DOCUMENT_INSTANCES 67 Document Instances
WSH_DOC_SEQUENCE_CATEGORIES 35 Shipping Document Categories
WSH_EXCEPTIONS 58 Shipping Exceptions
WSH_EXCEPTION_DEFINITIONS_B 31 Base Exception Definitions
WSH_EXCEPTION_DEFINITIONS_TL 11 Translated Exception Definitions
WSH_FOLDER_CUSTOM_ACTIONS 15
WSH_FOLDER_EXTENSIONS 23
WSH_FREIGHT_COSTS 54 Freight Costs
WSH_FREIGHT_COSTS_EFC 6 Euro Project Archive
WSH_FREIGHT_COSTS_INTERFACE 60 Freight Costs Interface
WSH_FREIGHT_COST_TYPES 35 Freight Cost Types
WSH_FTE_COMP_CLASSES 29 Stores the different types of classifications of compatibility constraints with the types of "Error" or "Warning" that allow the system ide
WSH_FTE_COMP_CONSTRAINTS 41 Stores the definitions of compatibility constraints such as item and Facility, Facility and Mode, Facility and Carrier, etc..
WSH_GLOBAL_PARAMETERS 61 Global Parameters
WSH_GRANTS 11 Grants in Roles and Users
WSH_GTC_RESPONSE_RULES 14 This table stores the combinations of error code and error types and their interpreted meanings.
WSH_INBOUND_TXN_HISTORY 24 Inbound Transaction History
WSH_INTERFACE_ERRORS 18 Interface Errors
WSH_ITM_ADAPTER_STATUS 12 Status of the ITM Adapter
WSH_ITM_DENIED_PARTIES 63 In WSH_ITM_RESPONSE_LINES we store the scanning results of all the parties in a request. If a Denied Party match is found for any of the par
WSH_ITM_ITEMS 65 Stores item information required for license determination. Submitting a request to ITM Adapter for license determination involves creating
WSH_ITM_PARAMETER_SETUPS_B 11 WSH_ITM_PARAMETER_SETUPS_B stores the basic Non-translatable information for the Parameter Setup. These parameters are used to configure th
WSH_ITM_PARAMETER_SETUPS_TL 11 WSH_ITM_PARAMETER_SETUPS_TL stores the translatebale information for the Parameters.
WSH_ITM_PARTIES 89 Stores information of the parties, which have to be scanned. Submitting a request to ITM Adapter involves creating a row in WSH_ITM_REQUEST_
WSH_ITM_PARTY_CONTACTS 59 Contacts of the various Parties are stored in this Table.
WSH_ITM_REQUEST_CONTROL 93 This table acts as the Request Interface table for ITM requests
WSH_ITM_RESPONSE_HEADERS 15 The response header stores general information about the response. For every request a response Header is created.
WSH_ITM_RESPONSE_LINES 55 The response header stores general information about the response. For every request a response Header is created.
WSH_ITM_RESPONSE_RULES 9 This table stores the combinations of error code, error types for a vendor and their interpreted meanings.
WSH_ITM_SERVICE_PARAMETERS 9 Stores additional parameters of a service (for every vendor) as name value pairs.
WSH_ITM_SERVICE_PREFERENCES 11 Stores the service preferences of a Master Organization, Application. Service Preferemnces include specifying which Vendor to post for a par
WSH_ITM_USER_SETUPS 13 Stores the login information of different partner ITM Applications. We allow registration at mutiple levels. A company may choose to have si
WSH_ITM_VENDORS 11 This table stores the list of all the partner ITM Applications.
WSH_ITM_VENDOR_PARAMETERS 9 Stores additional parameters (like Request Version, Request Handler) of a vendor as name value pairs.
WSH_ITM_VENDOR_SERVICES 23 Stores all the services provided by a Vendor(Partner ITM Applications)
WSH_ITM_VENDOR_STYLESHEETS 11 The Request and Response Stylesheet names for a Vendor are stored in this table. If the vendor does not support Oracle ITM XML API and if Or
WSH_LOCATIONS 49 Shipping Locations
WSH_LOCATION_DATA_EXT 12 Stores externally imported location information
WSH_LOCATION_OWNERS 9 Stores information about location owners
WSH_MESSAGE_ATTACHMENT 28 Message Attachments for XML
WSH_NEW_DELIVERIES 157 Deliveries
WSH_NEW_DEL_INTERFACE 205 Deliveries Interface Table
WSH_ORG_CARRIER_SERVICES 29 Carrier Services enabled in Organizations
WSH_ORG_CARRIER_SITES 29 Carrier Sites enabled in Organizations
WSH_OTM_LOCATIONS_GTMP 3
WSH_OTM_LOC_CONTACTS_GTMP 4
WSH_PICKING_BATCHES 98 Picking Batches
WSH_PICKING_RULES 85 Picking Rules
WSH_PICK_GROUPING_RULES 54 Pick Release Grouping Rules
WSH_PICK_SEQUENCE_RULES 40 Pick Sequence Rules
WSH_QUERY_ASSIGNMENTS 15 obsolete
WSH_REGIONS 37 Stores non-translated geographic region information including region codes and region hierarchy
WSH_REGIONS_GLOBAL_DATA 12
WSH_REGIONS_INTERFACE 21 Regions interface table - used to store region data before upload into regular region tables
WSH_REGIONS_TL 18 Stores translated geographic region information including region and zone names
WSH_REGIONS_TL_INTERFACE 18 Regions interface table (translated) - used to store region data before upload into regular region tables
WSH_REGION_LOCATIONS 11 Stores mapping of locations to regions. This includes separate records for the most specific region mapped as well as records for its parent
WSH_REPORT_PRINTERS 39 Report Printers
WSH_REPORT_SETS 32 Shipping Report Sets
WSH_REPORT_SET_LINES 32 Report Set Lines
WSH_ROLES 8 Roles for Roles and Users
WSH_ROLE_PRIVILEGES 8 Role Privileges in Roles and Users
WSH_SAVED_QUERIES_B 29 Base table for Saved Queries
WSH_SAVED_QUERIES_TL 10 Translated Saved Queries
WSH_SERIAL_NUMBERS 78 This table stores serial numbers after Ship Confirm is done.
WSH_SHIPPING_PARAMETERS 87 Shipping Parameters
WSH_SHIP_CONFIRM_RULES 23 Automated Ship Confirm Rules
WSH_TMP 7
WSH_TRANSACTIONS_HISTORY 44 Transaction History
WSH_TRIPS 72 Trips
WSH_TRIPS_INTERFACE 81 Trips Interface Table
WSH_TRIP_STOPS 84 Trip Stops
WSH_TRIP_STOPS_INTERFACE 87 Trip Stops Interface Table
WSH_UPGRADE_LOG 1 Upgrade Log
WSH_UPGRADE_PLD_TMP 74 Table to store picking line details information during upgrade from 11 to 11i
WSH_UPGRADE_SITE_TMP 2 Table to store site and location information during upgrade from 11 to 11i
WSH_UPGRADE_TMP 1 Table to store different phases during upgrade from 11 to 11i
WSH_WMS_SYNC_TMP 11
WSH_ZONE_REGIONS 12 Stores hierarchy for zones. Each region component of a zone has a record in this table.