Search Results back_ordered

Overview

The APPS.WMS_WP_WAVE_DETAILS_GTMP_V view is a reporting and integration object within the Oracle Warehouse Management (WMS) module of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It presents aggregated wave-planning information stored in the wave details global temporary table, exposing metrics that warehouse supervisors, planners, and downstream systems require to monitor and release wave activity. The object is owned by the APPS schema, carries a status of VALID, and belongs to the WMS product family. Its name suffix "GTMP" indicates that the underlying source is a global temporary table, meaning the data it surfaces is session-scoped and typically populated during wave planning or wave execution processing before being consumed within the same session or transaction.

Underlying Base Objects

According to the documented view text, WMS_WP_WAVE_DETAILS_GTMP_V is defined exclusively over a single base object: WMS_WP_WAVE_DETAILS_GTMP, which is referenced in the ETRM metadata as a SYNONYM. The view is a straight projection — it contains no joins, unions, filters, or expressions — selecting every documented column directly from the global temporary table. Because the underlying object is a synonym pointing to a global temporary table, the view inherits its session-scoped behavior: rows are visible only to the session that inserted them and are cleared at transaction or session boundaries depending on how the temporary table was declared. No other WMS tables (such as wave headers, tasks, or inventory tables) are documented as participating in the view definition.

Key Columns

The view exposes wave identification, status, scheduling, and performance metrics. Wave identity and lifecycle columns include WAVE_HEADER_ID, WAVE_NAME, and STATUS, along with audit columns CREATED_BY, START_TIME, TARGET_COMPLETION, and ACTUAL_COMPLETION. Aggregate volume and value metrics are represented by TOTAL_LINES, TOTAL_WEIGHT, TOTAL_VALUE, TOTAL_VOLUME, and TOTAL_TASKS. Exception tracking is provided by TOTAL_EXCEPTIONS, MODERATE_EXCEPTIONS, and SEVERE_EXCEPTIONS. Planning and progress state columns include READY_TO_RELEASE, BACK_ORDERED, CROSSDOCK_PLANNED, REPLENISHMENT_PLANNED, TASKED, PICKED, PACKED, STAGED, LOADED_TO_DOCK, and SHIPPED. The TOTAL_WEIGHT column in particular is relevant to the "total_weight" search term, as it quantifies the cumulative weight of all lines assigned to a wave and is commonly used for load planning, carrier selection, and trailer capacity checks.

Common Use Cases and Queries

Typical use cases include wave progress dashboards, outbound load weight verification, exception monitoring, and status-driven release decisions. The following queries illustrate common patterns.

• Wave summary with weight and status:
  SELECT wave_name, status, total_lines, total_weight, total_value FROM wms_wp_wave_details_gtmp_v WHERE status = 'PLANNED';
• Waves exceeding weight thresholds:
  SELECT wave_name, total_weight, total_volume FROM wms_wp_wave_details_gtmp_v WHERE total_weight > 20000 ORDER BY total_weight DESC;
• Exception monitoring:
  SELECT wave_name, total_exceptions, moderate_exceptions, severe_exceptions FROM wms_wp_wave_details_gtmp_v WHERE severe_exceptions > 0;
• Progress tracking of released waves:
  SELECT wave_name, ready_to_release, tasked, picked, packed, staged, loaded_to_dock, shipped FROM wms_wp_wave_details_gtmp_v;

Because the view is a direct projection over a global temporary table, results must be queried from the session that populated the table; cross-session queries will not return the transient data. Integrations and reports should therefore be invoked within the appropriate wave-processing context.