Search Results wsh_itm_parties




Overview
Explore in AI Chat

Overview

The WSH_ITM_PARTIES table is a core data object within the Oracle E-Business Suite Shipping Execution (WSH) module. It functions as a supporting table for the In-Transit Manager (ITM) Adapter, a component designed to facilitate the scanning and tracking of shipments. Specifically, this table stores the list of all parties—such as carriers, suppliers, or customers—that are designated for scanning as part of a single ITM Adapter request. Its primary role is to maintain the association between a high-level scanning request, managed in WSH_ITM_REQUEST_CONTROL, and the individual entities involved in that transaction, enabling granular tracking and status updates throughout the shipping lifecycle.

Key Information Stored

The table's structure is centered on identifying the request and the associated party. While the full column list is not detailed in the provided metadata, the documented primary and foreign key relationships reveal its critical elements. The PARTY_ID column serves as the table's primary key, uniquely identifying each party record intended for scanning. It is logical to infer the existence of a REQUEST_ID or similar foreign key column linking back to the WSH_ITM_REQUEST_CONTROL table, which would group all parties under a single adapter submission. Additional columns likely store party type, name, address references, and the specific scanning context or milestone applicable to that party within the shipment process.

Common Use Cases and Queries

The primary use case is the generation and processing of ITM Adapter requests for shipment visibility. A typical operational flow involves inserting a control record and then populating WSH_ITM_PARTIES with the relevant parties. Common queries involve auditing and troubleshooting. For instance, to list all parties pending scan for a specific request, one might use: SELECT * FROM WSH_ITM_PARTIES WHERE REQUEST_ID = :req_id;. Reporting on scan completion status often requires joining this table to the response lines: SELECT wip.PARTY_ID, wirl.STATUS FROM WSH_ITM_PARTIES wip, WSH_ITM_RESPONSE_LINES wirl WHERE wip.PARTY_ID = wirl.PARTY_ID;. This table is integral for confirming that all required entities in a complex multi-party shipment have been properly registered for tracking.

Related Objects

WSH_ITM_PARTIES is a central node in the ITM data model with defined relationships to other key tables.

  • WSH_ITM_REQUEST_CONTROL: This is the parent table. Although not explicitly listed in the provided foreign key section, the description confirms that parties are populated "as part of this request," implying a foreign key relationship from WSH_ITM_PARTIES to WSH_ITM_REQUEST_CONTROL.
  • WSH_ITM_RESPONSE_LINES: This table holds a documented foreign key relationship to WSH_ITM_PARTIES. The column WSH_ITM_RESPONSE_LINES.PARTY_ID references WSH_ITM_PARTIES.PARTY_ID. This link allows the system to update the scanning status and results received from the ITM Adapter against the original party record.