Search Results get_lpn_order_lov

Overview

WMS_SHIPPING_LOVS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the "OTHER" API category. It is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking session rather than the definer. The package serves the Warehouse Management System (WMS) shipping and logistics module by supplying list-of-values (LOV) query logic used to populate selection fields in the shipping execution user interface. Its header comment ($Header: WMSSHPLS.pls 115.2 2003/10/30) confirms it as a long-standing component of the WMS shipping feature set, carried forward into EBS 12.1.1 and 12.2.2.

Functionally, the package answers questions such as "which sales orders or order lines are associated with a given License Plate Number (LPN)?" and "which pick slips or orders are associated with a manifest?" This supports warehouse operators who must select the correct order, line, or manifest during packing, shipping, and manifesting activities. It is a query-only helper package; it does not create, update, or delete transactional data.

Key Procedures and Functions

ETRM documents four procedures in this package. All return a generic T_GENREF REF CURSOR as an OUT NOCOPY parameter, which the calling form or program then renders as an LOV result set.

• GET_LPN_ORDER_LOV — Returns the list of sales orders associated with a given LPN. The LPN is identified by its delivery detail ID in WSH_DELIVERY_DETAILS. Inputs include an organization ID, the parent delivery detail ID of the LPN, and a partial order string to restrict search results.
• GET_LPN_ORDERLINE_LOV — Returns the list of sales order lines associated with a given LPN, similarly identified by the LPN's delivery detail ID. Inputs include the organization ID, the source header ID of the sales order, the parent delivery detail ID, and a partial order-line search string.
• GET_MANIFEST_PICKSLIP_LOV — Populates an LOV of pick slips available for manifest selection, drawing on dispatched task and delivery data.
• GET_MANIFEST_ORDER_LOV — Populates an LOV of sales orders available for manifest selection.

The package reports no dependency from other packages (referenced by 0), indicating it is a top-level utility consumed directly by UI code rather than embedded in a larger API call stack.

Tables Accessed

The package reads from a broad set of shipping, order management, and inventory tables through APPS synonyms. WSH_DELIVERY_DETAILS and WMS_DISPATCHED_TASKS supply the LPN and manifest-to-task relationships. OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, MTL_SALES_ORDERS, and OE_TRANSACTION_TYPES_TL provide sales order header, line, and transaction type descriptions. MTL_SYSTEM_ITEMS_KFV, MTL_SECONDARY_INVENTORIES, and MTL_MATERIAL_TRANSACTIONS_TEMP support item and inventory context. HZ_CUST_ACCOUNTS and HZ_PARTIES resolve customer and party names for display in the LOV. BOM_RESOURCES and its related employee and equipment tables support resource-driven LOV logic, likely tied to carrier or service selections. All access is read-only.

Usage Notes

WMS_SHIPPING_LOVS is invoked from the WMS shipping execution forms layer when an operator opens an LOV in a packing, shipping, or manifesting window. It may also be called from custom Oracle Forms or OAF extensions that replicate shipping LOV behavior, and from report or concurrent program code requiring LPN-to-order resolution. Because it is a private, UI-oriented helper rather than a documented public API, Oracle does not guarantee its signature across releases; customizations should reference it cautiously and validate behavior against the specific EBS 12.1.1 or 12.2.2 instance in use.