Search Results wsh_itm_items




Overview
Explore in AI Chat

Overview

The WSH_ITM_ITEMS table is a core data object within the Oracle E-Business Suite Shipping Execution (WSH) module, specifically designed to support the International Trade Management (ITM) functionality. Its primary role is to store detailed item-level information required for determining export licenses and managing trade compliance during the shipping process. When a request is submitted to the ITM Adapter for a license determination, a control record is first created in the WSH_ITM_REQUEST_CONTROL table. Subsequently, all items pertinent to that shipping transaction are inserted into the WSH_ITM_ITEMS table, forming the detailed payload for the compliance check. This table acts as a critical junction between shipping logistics and regulatory adherence.

Key Information Stored

The table's structure is centered around linking items to a license determination request and capturing their compliance-relevant attributes. While the full column list is not detailed in the provided metadata, the defined relationships indicate its core data elements. The primary key, ITEM_ID, uniquely identifies each item record within the table. The foreign key column, REQUEST_CONTROL_ID, is essential as it ties each item row back to its parent control record in WSH_ITM_REQUEST_CONTROL, defining the specific transaction context. Other columns typically store data such as the inventory item identifier, quantity, unit of measure, value, country of origin, and Harmonized System (HS) code, which are all critical inputs for automated license determination.

Common Use Cases and Queries

The primary use case is the batch processing of items for export license screening. A common operational query involves retrieving all items for a specific license request to review the data before submission or to troubleshoot a failed determination. For reporting and audit purposes, analysts may join this table to related objects to trace the compliance history of shipped items.

  • Find Items for a Specific Request: SELECT * FROM WSH.WSH_ITM_ITEMS WHERE REQUEST_CONTROL_ID = <control_id>;
  • Audit Trail Join: Queries often join WSH_ITM_ITEMS to WSH_ITM_REQUEST_CONTROL (on REQUEST_CONTROL_ID) to get request metadata and to WSH_ITM_RESPONSE_LINES (on ITEM_ID) to retrieve the resulting license determination or denial reason.

Related Objects

The WSH_ITM_ITEMS table exists within a tightly integrated schema for ITM processing, with documented foreign key relationships as follows:

  • References (Parent Table): WSH_ITM_REQUEST_CONTROL. The column WSH_ITM_ITEMS.REQUEST_CONTROL_ID is a foreign key to this table, establishing the master-detail relationship for each license determination transaction.
  • Referenced By (Child Table): WSH_ITM_RESPONSE_LINES. The column WSH_ITM_RESPONSE_LINES.ITEM_ID is a foreign key to WSH_ITM_ITEMS.ITEM_ID. This links each item submitted for screening to the corresponding response line (e.g., license number, exception code) returned by the ITM Adapter.

This structure creates a clear data flow: Request Control → Items for determination → Response lines for results.

  • Table: WSH_ITM_ITEMS 12.2.2

    owner:WSH,  object_type:TABLE,  fnd_design_data:WSH.WSH_ITM_ITEMS,  object_name:WSH_ITM_ITEMS,  status:VALID,  product: WSH - Shipping Execution ,  description: Stores item information required for license determination. Submitting a request to ITM Adapter for license determination involves creating a row in WSH_ITM_REQUEST_CONTROL and all the items involved in this transaction have to be populated ,  implementation_dba_data: WSH.WSH_ITM_ITEMS , 

  • Table: WSH_ITM_ITEMS 12.1.1

    owner:WSH,  object_type:TABLE,  fnd_design_data:WSH.WSH_ITM_ITEMS,  object_name:WSH_ITM_ITEMS,  status:VALID,  product: WSH - Shipping Execution ,  description: Stores item information required for license determination. Submitting a request to ITM Adapter for license determination involves creating a row in WSH_ITM_REQUEST_CONTROL and all the items involved in this transaction have to be populated ,  implementation_dba_data: WSH.WSH_ITM_ITEMS , 

  • Table: WSH_ITM_REQUEST_CONTROL 12.2.2

    owner:WSH,  object_type:TABLE,  fnd_design_data:WSH.WSH_ITM_REQUEST_CONTROL,  object_name:WSH_ITM_REQUEST_CONTROL,  status:VALID,  product: WSH - Shipping Execution ,  description: This table acts as the Request Interface table for ITM requests ,  implementation_dba_data: WSH.WSH_ITM_REQUEST_CONTROL , 

  • Table: WSH_ITM_RESPONSE_LINES 12.2.2

    owner:WSH,  object_type:TABLE,  fnd_design_data:WSH.WSH_ITM_RESPONSE_LINES,  object_name:WSH_ITM_RESPONSE_LINES,  status:VALID,  product: WSH - Shipping Execution ,  description: The response header stores general information about the response. For every request a response Header is created. ,  implementation_dba_data: WSH.WSH_ITM_RESPONSE_LINES , 

  • Table: WSH_ITM_REQUEST_CONTROL 12.1.1

    owner:WSH,  object_type:TABLE,  fnd_design_data:WSH.WSH_ITM_REQUEST_CONTROL,  object_name:WSH_ITM_REQUEST_CONTROL,  status:VALID,  product: WSH - Shipping Execution ,  description: This table acts as the Request Interface table for ITM requests ,  implementation_dba_data: WSH.WSH_ITM_REQUEST_CONTROL , 

  • Table: WSH_ITM_RESPONSE_LINES 12.1.1

    owner:WSH,  object_type:TABLE,  fnd_design_data:WSH.WSH_ITM_RESPONSE_LINES,  object_name:WSH_ITM_RESPONSE_LINES,  status:VALID,  product: WSH - Shipping Execution ,  description: The response header stores general information about the response. For every request a response Header is created. ,  implementation_dba_data: WSH.WSH_ITM_RESPONSE_LINES ,