Search Results putaway_strategy_id




Overview
Explore in AI Chat

Overview

APPS.WMS_SUGGESTIONS_TEMP_V is a temporary-planning view used by Oracle Warehouse Management (WMS) within Oracle E-Business Suite 12.1.1 and 12.2.2. It presents the interim set of move-order and transaction suggestions generated by the putaway and picking engines, including the recommendations emitted when the system evaluates putaway rules, pick rules, and strategies. In practice the view consolidates rows from the WMS transactions staging table and the move-order request lines table so that suggestions from both the WMS temporary transaction buffer and standard inventory move orders are visible through a single relational interface. Because it exposes the RULE_ID column twice — once decoded as pick_rule_id and once decoded as putaway_rule_id — it is the object most commonly referenced when a developer or functional user searches for "putaway_rule_id" in the EBS data dictionary.

Underlying Base Objects

The view is defined as a UNION of two branches. The first branch selects from WMS_TRANSACTIONS_TEMP (aliased wtt) joined to MTL_TXN_REQUEST_LINES (aliased mol) on wtt.TRANSACTION_TEMP_ID = MOL.LINE_ID, with the predicates wtt.line_type_code = 2 and wtt.type_code IN (1,2). This branch produces Rec_type 'WTT'. The second branch selects from MTL_MATERIAL_TRANSACTIONS_TEMP (mtt) and is tagged Rec_type 'MTT'. Documented referenced base objects are the synonyms MTL_MATERIAL_TRANSACTIONS_TEMP, MTL_SERIAL_NUMBERS_TEMP, MTL_TRANSACTION_LOTS_TEMP, MTL_TXN_REQUEST_LINES, and WMS_TRANSACTIONS_TEMP — all owned physically under their respective INV and WMS schemas, with public synonyms granting APPS access. The view is read-only; it carries no DML semantics and is intended for inquiry, reporting, and integration extraction only.

Key Columns

Common Use Cases and Queries

The view is typically queried to audit or debug the putaway engine's output before the suggestions are confirmed. A typical query is:

SELECT inventory_item_id, putaway_rule_id, putaway_strategy_id, to_subinventory_code, to_locator_id, quantity FROM apps.wms_suggestions_temp_v WHERE organization_id = :p_org AND type_code = 1 AND putaway_rule_id IS NOT NULL;

Developers also use it to reconcile WMS suggestions back to MTL_TXN_REQUEST_LINES, grouping by rec_type to distinguish WMS-sourced rows from move-order rows, and to trace which rule drove a destination locator. Because the object is a temporary-surface view, results reflect the current session's or transaction's staging state and should not be used for historical reporting; the permanent audit trail resides in the WMS and INV transaction history tables.