Search Results fetch_next_drop

Overview

WMS_PICK_DROP_PVT is a private PL/SQL package in the Oracle Warehouse Management (WMS) module of Oracle E-Business Suite, owned by the APPS schema. Its header identifies it as WMSPKDPS.pls and records a constant version string referencing the 12.1.1 release lineage (120.1.12010000.1, dated 2008/07/28). The package encapsulates the internal business logic that governs the pick-and-drop workflow used in WMS-directed material handling. In warehouse operations, a "drop" represents the destination or final resting location to which picked material is moved after being removed from its source location. The package therefore resolves which drop a user or task should move to, determines whether a pick should be deconsolidated into multiple drops, validates LPN (license plate number) transfers, and processes the actual transaction that records the pick and drop movement in inventory. Because it is classified as a PVT (private) API, it is intended for internal use by WMS application code rather than as a public integration point, and it should be regarded as unsupported for direct customer invocation.

Key Procedures and Functions

The package exposes 17 documented procedures and functions covering the full pick-drop cycle:

• CHK_IF_DECONSOLIDATE — Evaluates whether an existing pick should be deconsolidated, returning flags for multiple drops, drop type, bulk pick, and the applicable drop LPN option.
• FETCH_NEXT_DROP — Returns the next drop in the pick-drop sequence along with its type, delivery context, and an open ref cursor of tasks.
• PICK_DROP — The principal transaction driver that performs the pick-and-drop movement.
• VALIDATE_PICK_DROP_LPN and VALIDATE_XFER_TO_LPN — Perform validation on the LPN involved in the pick-drop and transfer-to-LPN operations.
• PROCESS_INNER_LPN, PROCESS_LOOSE_QTY, PROCESS_SERIAL, and PROCESS_CONF_ITEM — Handle inner LPN contents, loose quantity moves, serial-numbered material, and configured items respectively.
• CANCEL_TASK — Cancels an outstanding pick task.
• GET_DEFAULT_DROP_LPN, GET_LOT_LOV, GET_SERIAL_LOV, and CREATE_TEMP_ID_LIST — Provide defaults, list-of-values lookups for lot and serial selection, and temporary ID list construction.
• GET_WIP_JOB_INFO — Retrieves work-in-process job context (job, line, department, operation sequence, dates, assembly).
• GET_SUB_XFER_DEST_INFO — Returns subinventory transfer destination details, including project and task references.
• GET_DELIVERY_INFO — Supplies outbound delivery information for the drop.

Tables Accessed

The package reads and writes material handling and transaction data through APPS synonyms. It references MTL_MATERIAL_TRANSACTIONS_TEMP and MTL_MATERIAL_TRANSACTIONS_S to stage and record inventory transactions; MTL_TRANSACTION_LOTS_TEMP, MTL_SERIAL_NUMBERS, and MTL_SERIAL_NUMBERS_TEMP for lot and serial control; MTL_ITEM_LOCATIONS, MTL_SECONDARY_INVENTORIES, and MTL_ITEM_REVISIONS for location and item validation; MTL_ALLOCATIONS_GTMP for allocation detail; MTL_CROSS_REFERENCES for alternate item references; MTL_SYSTEM_ITEMS_KFV for item descriptions; and MTL_TXN_REQUEST_HEADERS and MTL_TXN_REQUEST_LINES for move order context. Outbound order context is drawn from OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL.

Usage Notes

WMS_PICK_DROP_PVT is invoked internally by WMS mobile radio-frequency (RF) screens and task-driven pick-drop flows, and it is referenced by one other package as recorded in the ETRM metadata. It is not designed for direct customer calls. Any customization should target supported public WMS APIs instead, and modifications should be applied through the standard Oracle support process using the documented package specification.