Results for “wms_packing_material_gtemp”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• Move order context — MOVE_ORDER_HEADER_ID and MOVE_ORDER_LINE_ID identify the originating move order and line, providing the transactional anchor for the row.
• Inventory and item attributes — ORGANIZATION_ID, SUBINVENTORY, LOCATOR_ID, INVENTORY_ITEM_ID, ITEM, ITEM_DESCRIPTION, REVISION, LOT_NUMBER, UOM, and QUANTITY describe what material is being packed.
• Logistics unit (LPN) hierarchy — LPN_ID, PARENT_LPN_ID, and OUTERMOST_LPN_ID (with their descriptive counterparts) capture the license-plate nesting structure essential to packing.
• Delivery and trip linkage — DELIVERY_ID, DELIVERY_DETAIL_ID, and TRIP_ID connect the row to the outbound shipment; TRIP_ID is the sole documented foreign key (to WSH_TRIPS).
• Order and customer references — ORDER_HEADER_ID, ORDER_NUMBER, ORDER_LINE_ID, CUSTOMER_ID, SHIP_TO_LOCATION_ID.
• Flags and controls — SELECTED_FLAG, PTO_FLAG, and SHIP_SET_ID control processing or grouping.
• Secondary units — SECONDARY_QUANTITY, SECONDARY_UOM_CODE, and GRADE_CODE support dual-UOM and quality attributes.

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

• WSH_TRIPS — joined on TRIP_ID; the documented foreign-key target.
• WSH_DELIVERIES / WSH_DELIVERY_DETAILS — joined on DELIVERY_ID and DELIVERY_DETAIL_ID for shipment content.
• WMS_LICENSE_PLATE_NUMBERS (LPN) — joined on LPN_ID, PARENT_LPN_ID, and OUTERMOST_LPN_ID.
• MTL_MATERIAL_TRANSACTIONS / MTL_SYSTEM_ITEMS — joined on INVENTORY_ITEM_ID for item and transaction validation.
• OE_ORDER_HEADERS / OE_ORDER_LINES — joined on ORDER_HEADER_ID and ORDER_LINE_ID.
• WMS_MOVE_ORDER_HEADERS / LINES — joined on MOVE_ORDER_HEADER_ID and MOVE_ORDER_LINE_ID.
• WMS_PACKING_MATERIAL_PUB / WMS_PACKING APIs — server-side routines that populate and consume the staging rows.