Search Results wms_packing_material_gtemp




Overview
Explore in AI Chat

Overview

WMS_PACKING_MATERIAL_GTEMP is a global temporary table (GTTEMP) owned by the WMS (Warehouse Management) schema in Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. It serves as a transient staging and processing structure used during packing and shipping operations when a session needs to assemble, evaluate, or sequence packing material and shipping-eligible inventory records before they are committed to permanent warehouse or shipping tables. Because it is a global temporary table, its rows are visible only within the session (or transaction, depending on the ON COMMIT setting) that populated it, and the data is automatically purged when that scope completes. In the documented 12.2.2 physical schema the table exposes 64 columns, reflecting a wide denormalized working set rather than a narrow normalized entity.

The ETRM metadata classifies this object heuristically as standalone in Data Vault terms. It therefore functions as an isolated working or staging structure rather than a true hub, link, or satellite; a data modeler would treat it as a temporary load table rather than a persistent warehouse entity. One foreign-key relationship is documented, from TRIP_ID to WSH_TRIPS, indicating that at least some rows are associated with a specific trip during the shipping stage.

Key Information Stored

The table holds a session-scoped row per packing material or move-order candidate line. The most significant columns fall into several functional groups:

No primary key or unique index is documented for this temporary table, which is consistent with its role as an unconstrained session work area rather than a persisting entity. The surrogate identifiers present are those of the upstream business entities (move order, delivery, trip, order), not keys intrinsic to the temporary table itself.

Common Use Cases and Queries

Typical uses include preparing a packing-material work set, sequencing LPN contents for a trip, and validating which lines are marked for selection before confirmation. A representative query pattern joins the temporary set to persistent entities via the identified keys:

SELECT t.organ ization_id, t.item, t.quantity, t.uom,
       t.lpn, t.parent_lpn, t.trip
FROM   wms_packing_material_gtemp t
WHERE  t.selected_flag = 'Y'
AND    t.trip_id = :p_trip_id
ORDER  BY t.outermost_lpn_id, t.lpn_id;

Reporting on packing throughput, LPN consolidation, or ship-set composition within a session is also common. Because the table is temporary, queries must execute in the same session that populated it.

Related Objects