Search Results order_line_num




Overview
Explore in AI Chat

Overview

APPS.WMS_PACKING_MATERIAL_V is a reporting view in the Oracle E-Business Suite Warehouse Management System (WMS) module, exposed under the APPS schema. It presents a consolidated, flattened projection of packing material content used during outbound packing and shipping operations, including data drawn from move orders, delivery details, LPN (License Plate Number) hierarchies, trip and carrier assignments, and the associated sales order or receiving document references. The view is defined in a straightforward manner: it selects every listed column from a single underlying object, WMS_PACKING_MATERIAL_GTEMP, without joins, filters, unions, or aggregations. Its role in Oracle EBS reporting and integration is therefore that of a stable, read-only presentation layer over a transient staging structure, allowing external reports, BI Publisher templates, and custom concurrent programs to query packing material content using a consistent name and column list rather than referencing the underlying global temporary table directly.

Underlying Base Objects

The ETRM metadata documents a single referenced base object: the synonym WMS_PACKING_MATERIAL_GTEMP, which resolves to the WMS global temporary table of the same name. Because the view is a one-to-one SELECT over that object, it inherits all of its semantics. A global temporary table in Oracle EBS stores rows only for the duration of a session or transaction, and typically its contents are populated by the packing or shipping UI or an API call prior to the user or concurrent program querying the data. Consequently, WMS_PACKING_MATERIAL_V does not hold persistent data of its own; each query reflects whatever is present in WMS_PACKING_MATERIAL_GTEMP for the current session at the moment of execution. This design is characteristic of WMS packing workbench functionality, where the material list is assembled dynamically and then consumed by downstream processes.

Key Columns

Common Use Cases and Queries

The view is most useful for building packing lists, verifying PTO versus non-PTO packing, and auditing LPN and ship set grouping. A typical query filtering on the PTO flag is:

  • SELECT item, quantity, uom, ptO_flag FROM apps.wms_packing_material_v WHERE pto_flag = 'Y';
  • SELECT delivery, lpn, parent_lpn, quantity FROM apps.wms_packing_material_v WHERE delivery_id = :p_delivery_id;
  • SELECT organization_code, subinventory, locator, item, lot_number FROM apps.wms_packing_material_v WHERE move_order_header_id = :p_mo_header_id;

Because the data is session-scoped, these queries must be executed within the session or process that populated WMS_PACKING_MATERIAL_GTEMP. In Oracle EBS 12.1.1 and 12.2.2 the object definition is unchanged, so reports developed against it remain portable across both releases.