Results for “po_uniteff_pkg”

48 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PO_UNITEFF_PKG is a small Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the OTHER API category. Its name reflects its narrow purpose, the resolution of unit effective information for purchase order shipments. In Oracle Purchasing, a single shipment line can be sourced from serialized inventory, meaning that the delivered quantity is physically represented by individually tracked serial numbers held in Oracle Inventory. Standard purchasing and receiving inquiry windows must therefore be able to display which serialized unit corresponds to a given shipment line and item. PO_UNITEFF_PKG provides that single lookup, exposing one documented function that maps a shipment line and item combination to the end item unit number recorded in MTL_SERIAL_NUMBERS. The package is an internal, low-level utility rather than a transactional API. It performs query-only work, and its header carries a disabled RESTRICT_REFERENCES pragma declaring WNDS, WNPS and RNPS, indicating that the function was intended to write no database state, read no package state, and reference no packaged variables. The package header bears a source control identifier dated 2008, consistent with the 12.1.1 code line, and it remains present in 12.2.2 as an unchanged utility.

Key Procedures and Functions

  • GET_UNIT_NUMBER — The only documented program unit in the package. Based on the source comment block, it accepts a shipment line identifier and an item identifier and returns the end item unit number stored in MTL_SERIAL_NUMBERS for that combination. The return type is VARCHAR2. It is explicitly documented as being called by the PO_SHIP_RCV_SUPPLY_VIEW and PO_SHIP_SUPPLY_VIEW views, where it supplies the unit number column projected against shipment supply rows. As a function with a scalar return, it is suitable for direct use in a SQL SELECT list or WHERE clause within those view definitions, as well as from any custom query that needs the same resolution. No formal parameter list should be assumed beyond the two identifiers named in the documentation; callers should rely on the shipped package specification.

Tables Accessed

  • MTL_SERIAL_NUMBERS — The primary source of the returned value. This Oracle Inventory table stores one row per tracked serial number, including the serial number itself and its association to an inventory item and organization. GET_UNIT_NUMBER reads it to derive the end item unit number for the requested shipment line and item.
  • RCV_SERIALS_SUPPLY — The receiving supply table that ties serial numbers to receiving and shipment supply records. It provides the linkage needed to translate the incoming shipment line identifier into the specific serialized unit, which is then confirmed against MTL_SERIAL_NUMBERS.

Both objects are referenced through APPS synonyms. The package performs read operations only; no inserts, updates or deletes are documented.

Usage Notes

PO_UNITEFF_PKG is not intended to be called directly by end users or by external integrations. Its documented consumers are the two shipment supply views, PO_SHIP_RCV_SUPPLY_VIEW and PO_SHIP_SUPPLY_VIEW, which are in turn queried by purchasing and receiving inquiry forms and by related reporting. The three packages documented as referencing PO_UNITEFF_PKG do so to obtain unit number information in the same manner. Custom code should invoke GET_UNIT_NUMBER only when the objective matches the packaged behavior, that is, resolving the end item unit number for a known shipment line and item. Because the function is deterministic relative to the underlying serial data and is declared with RESTRICT_REFERENCES intent, it is safe for read-only reporting, but callers should hold no expectation of write behavior. The package is fully supported in both 12.1.1 and 12.2.2; no Online Patching or editioning considerations alter the documented interface between the two releases.