WSH — Shipping Execution
107 documented tables · 212 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
WSH_DELIVERY_DETAILS |
Delivery Details | hub-leaning |
WSH_REGIONS |
Stores non-translated geographic region information including region codes and region hierarchy | hub-leaning |
WSH_ITM_VENDORS |
This table stores the list of all the partner ITM Applications. | hub-leaning |
WSH_TRIPS |
Trips | hub |
WSH_NEW_DELIVERIES |
Deliveries | hub |
WSH_ITM_VENDOR_SERVICES |
Stores all the services provided by a Vendor(Partner ITM Applications) | hub-leaning |
WSH_ITM_REQUEST_CONTROL |
This table acts as the Request Interface table for ITM requests | hub-leaning |
WSH_TRIP_STOPS |
Trip Stops | hub-leaning |
WSH_REPORT_SETS |
Shipping Report Sets | hub-leaning |
WSH_TRIPS_INTERFACE |
Trips Interface Table | satellite-leaning |
WSH_EXCEPTION_DEFINITIONS_B |
Base Exception Definitions | hub-leaning |
WSH_ITM_PARAMETER_SETUPS_B |
WSH_ITM_PARAMETER_SETUPS_B stores the basic Non-translatable information for the Parameter Setup. These param | hub-leaning |
WSH_SAVED_QUERIES_B |
Base table for Saved Queries | hub-leaning |
WSH_ITM_RESPONSE_LINES |
The response header stores general information about the response. For every request a response Header is crea | satellite-leaning |
WSH_PICK_SEQUENCE_RULES |
Pick Sequence Rules | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
WSH_GLBL_VAR_STRCT_GRP |
GRP | 0 | 67 packages |
WSH_INTERFACE_GRP |
GRP | 10 | 37 packages |
WSH_WMS_LPN_GRP |
GRP | 4 | 33 packages |
WSH_DELIVERIES_GRP |
GRP | 5 | 23 packages |
WSH_TRIPS_GRP |
GRP | 7 | 21 packages |
WSH_TRIP_STOPS_GRP |
GRP | 7 | 21 packages |
WSH_INTERFACE_EXT_GRP |
GRP | 16 | 16 packages |
WSH_BULK_TYPES_GRP |
GRP | 0 | 16 packages |
WSH_CUSTOM_PUB |
PUB | 19 | 15 packages |
WSH_DELIVERY_DETAILS_GRP |
GRP | 11 | 14 packages |