Search Results wms_suggestions_temp_v




Overview
Explore in AI Chat

Overview

WMS_SUGGESTIONS_TEMP_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite. It belongs to the Warehouse Management (WMS) product family and is documented as the "WMS SUGGESTIONS TEMP View" in the ETRM reference for releases 12.1.1 and 12.2.2. The view consolidates candidate putaway and picking suggestions generated by the warehouse management suggestion engine, exposing them in a single, uniformly shaped result set so that concurrent programs, mobile radio-frequency (RF) screens, and downstream integrations can consume suggestions without joining the individual transaction tables themselves.

Internally, the view is defined as a UNION of two distinct sources. The first branch reads from WMS_TRANSACTIONS_TEMP joined to MTL_TXN_REQUEST_LINES and is tagged with a REC_TYPE of 'WTT'; it isolates rows where LINE_TYPE_CODE = 2 and TYPE_CODE is either 1 (putaway) or 2 (picking). The second branch reads directly from MTL_MATERIAL_TRANSACTIONS_TEMP and is tagged with a REC_TYPE of 'MTT'. This union construction allows the suggestion logic to treat manually entered move-order transactions and system-generated material transactions through one consistent interface. Because the view draws only on temporary transaction tables, its contents are transient; rows appear while a suggestion is being evaluated or staged and disappear once the transaction is executed, purged, or converted to a permanent move order.

Underlying Base Objects

The documented base objects referenced by the view are MTL_MATERIAL_TRANSACTIONS_TEMP, MTL_SERIAL_NUMBERS_TEMP, MTL_TRANSACTION_LOTS_TEMP, MTL_TXN_REQUEST_LINES, and WMS_TRANSACTIONS_TEMP, all accessed through APPS synonyms. WMS_TRANSACTIONS_TEMP holds the WMS-specific transaction staging records, including rule identifiers, LPN data, and from/to organization and locator references. MTL_TXN_REQUEST_LINES supplies move-order line context such as ORGANIZATION_ID, INVENTORY_ITEM_ID, and SECONDARY_UOM_CODE, and is joined on WTT.TRANSACTION_TEMP_ID = MOL.LINE_ID. MTL_MATERIAL_TRANSACTIONS_TEMP provides the inventory transaction staging rows that populate the second UNION branch. The serial and lot temporary tables are referenced by the wider WMS suggestion code path to resolve serial numbers and lot attributes associated with a suggestion, though the documented view text exposes lot and serial columns directly from the transaction temp records.

Key Columns

Common Use Cases and Queries

The view is typically used to diagnose suggestion behaviour, to display pending putaway or picking work in custom RF or web pages, and to reconcile staged transactions against executed move orders. A representative query lists pending picking suggestions for an organization:

  • SELECT move_order_line_id, inventory_item_id, quantity, from_subinventory_code, to_subinventory_code, pick_rule_id FROM apps.wms_suggestions_temp_v WHERE rec_type = 'WTT' AND type_code = 2 AND organization_id = :org_id;
  • SELECT rec_type, type_code, count(*) FROM apps.wms_suggestions_temp_v GROUP BY rec_type, type_code; — Used to profile how many suggestions originate from move-order staging versus material transaction staging.
  • SELECT transaction_temp_id, lot_number, serial_number, lpn_id FROM apps.wms_suggestions_temp_v WHERE inventory_item_id = :item_id; — Used to verify lot, serial, and LPN detail before confirming a suggestion.

Because the underlying tables are temporary in nature, queries should be executed while suggestions are active, and results should never be treated as an audit history of warehouse movements.