Search Results number_picking_transactions

Overview

INV_3PL_SEEDED_SOURCES is an Oracle EBS PL/SQL package owned by the APPS schema and classified under the ETRM API classification of OTHER. It belongs to the Oracle Inventory (INV) module, specifically the third-party logistics (3PL) feature set that supports warehouse management and logistics service provider operations. The package supplies seeded data sources for Oracle's 3PL and warehouse management analytics, primarily serving as a collection of measurement providers for Key Performance Indicator (KPI) and counter-based reporting. Each documented procedure returns a numeric counter value and a return status, indicating that the package is designed to be invoked by a metric or KPI framework that consumes these values at runtime rather than by end-user transactional forms.

The package header indicates it is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user. The header comment places the source file at version 120.1, dated May 2010, which is consistent with the code line spanning EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes eleven documented program units. Eight are procedures that return a counter value and a return status, and three are functions.

• NUMBER_RECEIVE_TRANSACTIONS — returns a count-based counter for receiving transaction activity.
• NUMBER_SHIPMENT_LINES — returns a count-based counter for shipment lines.
• NUMBER_PICKING_TRANSACTIONS — returns a count-based counter for picking transactions.
• QTY_RECEIVING_TRANSACTIONS — returns a quantity-based counter for receiving transactions.
• NUMBER_PUTAWAY_TRANSACTIONS — returns a count-based counter for putaway transactions.
• CAPACITY_NUMBER_OF_DAYS — returns a capacity-oriented counter expressed as a number of days.
• VOLUME_UTILIZED — returns a counter for volume utilization.
• AREA_UTILIZED — returns a counter for area utilization.
• GET_ITEM_UOM_CODE — a function that returns the unit of measure code for an item; this is the unit referenced by the user search term "get_item_uom_code". The input is a UOM name.
• GET_AREA_FOR_LOCATOR — a function that returns the area associated with a given inventory locator and organization.
• GET_VOLUME_FOR_LOCATOR — a function that returns the volume for a given inventory locator, organization, and billing unit of measure.

Tables Accessed

The package reads from a defined set of APPS-synonym tables: MTL_3PL_LOCATOR_OCCUPANCY, MTL_ITEM_LOCATIONS, MTL_MATERIAL_TRANSACTIONS, MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_KFV, MTL_UNITS_OF_MEASURE, RCV_SHIPMENT_LINES, RCV_TRANSACTIONS, and DUAL. The MTL_ tables supply item, locator, transaction, and unit-of-measure data used by the counters and by GET_ITEM_UOM_CODE and the locator functions. The RCV_ tables supply receiving and shipment data for the receiving and shipment counters. DUAL supports single-row computations. The documentation does not indicate write operations; the package is read-oriented.

Usage Notes

Because each counter procedure uses an OUT NOCOPY parameter pattern for its value and return status, the package is intended to be called programmatically by a metric engine, dashboard, or concurrent process rather than directly by a user. In typical EBS deployments, such seeded source packages are invoked by warehouse management KPI reporting and 3PL analytics. Custom code may call the public functions, including GET_ITEM_UOM_CODE, to resolve an item's UOM code. The ETRM metadata records zero packages referencing this object, confirming it is a leaf-level source provider. It should be treated as Oracle-owned seeded code and not modified; extensions should wrap rather than alter it.