Download Oracle Warehouse Management Implementation Guide

Frequently Asked Questions
material_transactions_temp, the base for this query, are deleted once the
transactions are completed.
--Replace &batch with the pick release batch number within single quotes
select bom.operation_code as task_type, item.concatenated_segments as item,
transaction_quantity as qty, transaction_uom as UOM, temp.lot_number,
r1.name as pick_rule, s1.name as pick_strategy,
temp.subinventory_code as source_sub, l1.concatenated_segments as
source_loc,
r2.name as put away_rule, s2.name as putway_strategy,
transfer_subinventory as dest_sub, l2.concatenated_segments as dest_loc
from bom_standard_operations bom, mtl_material_transactions_temp temp,
mtl_txn_request_lines mol, mtl_item_locations_kfv l1, mtl_item_
locations_kfv l2,
mtl_txn_request_headers head, mtl_system_items_kfv item,
wms_rules r1, wms_rules r2, wms_strategies_vl s1, wms_strategies_vl s2
where temp.move_order_line_id = mol.line_id
and temp.pick_rule_id = r1.rule_id
and temp.put_away_rule_id = r2.rule_id
and temp.pick_strategy_id = s1.strategy_id (+)
and temp.put_away_strategy_id = s2.strategy_id (+)
and item.inventory_item_id = temp.inventory_item_id
and item.organization_id = temp.organization_id
and mol.header_id = head.header_id
and head.request_number = &batch
and temp.standard_operation_id = bom.standard_operation_id (+)
and l1.inventory_location_id = temp.locator_id
and l2.inventory_location_id = temp.transfer_to_location
Frequently Asked Questions
1.
When are picking/put away rules used?
The picking and put away rules engine is used for every move order within
WMS-enabled organizations. This includes manual move orders, replenishment
move orders, and sales order staging move orders, which were new
transactions with Inventory in release 11i. This also include move orders which
are created in the background via the mobile LPN put away page.
2.
When are cost group rules used?
All material in the warehouse has a cost group. Therefore, the cost group rules
are used whenever new material, or material that does not already have a cost
group, is received into inventory. This occurs on miscellaneous receipts,
Warehouse Management Rules Engine
14-45