Search Results inv_select_inventory_pkg




Overview
Explore in AI Chat

Overview

INV_SELECT_INVENTORY_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It is classified under the ETRM object registry as an OTHER-type API, indicating that it is not part of the formally published Open Interfaces or public APIs, but rather an internal utility package used by Oracle Applications components. Its status is recorded as VALID in both Oracle EBS 12.1.1 and 12.2.2.

The package provides the selection and retrieval logic used to identify available inventory and source information across a range of supply types. It consolidates queries against on-hand balances, lots, material transaction staging tables, discrete and process manufacturing entities, and order management tables. In practical terms, INV_SELECT_INVENTORY_PKG supports the reservation, picking, and transaction entry flows by resolving which material is available, where it resides, and how it should be sourced. Because it is referenced by internal Oracle forms and transaction processing logic, it acts as a shared query engine rather than a transactional write API.

Key Procedures and Functions

The documented package exposes three program units:

  • GET_SOURCE_INFO — Resolves source information for an inventory or transaction context. This routine supplies the source type, source reference, and related attributes needed to determine where material originates, supporting transaction entry and material movement screens.
  • GET_DETAILS — Returns detailed inventory or transaction attributes for a given selection context. It is used to populate detail-level information such as item, lot, subinventory, and locator data required by downstream processing.
  • GET_AVAILABLE_INVENTORY — Retrieves available inventory quantities based on selection criteria. It drives on-hand availability checks used during reservation, picking, and allocation, and is the principal entry point for availability lookups.

Consistent with its OTHER classification, the package is not documented as a supported public API. Parameter lists are not published in the ETRM metadata, and callers should treat these signatures as internal and subject to change across patch levels.

Tables Accessed

The package reads and writes a defined set of tables through APPS synonyms. On-hand and availability data is drawn from MTL_AVAILABLE_INVENTORY_TEMP. Lot information is sourced from MTL_LOT_NUMBERS, with transaction-lot associations in MTL_TRANSACTION_LOTS_TEMP and staged material movements in MTL_MATERIAL_TRANSACTIONS_TEMP. Move-order lines are accessed via MTL_TXN_REQUEST_LINES. Process manufacturing data is read from GME_BATCH_HEADER and GME_MATERIAL_DETAILS, while discrete manufacturing context is supplied by WIP_ENTITIES. Sales order context comes from OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL, and PLITBLM is referenced as an Oracle Forms PL/SQL table construct. Together these tables allow the package to correlate demand from order management and manufacturing with available supply in inventory.

Usage Notes

INV_SELECT_INVENTORY_PKG is typically invoked from Oracle Inventory and Order Management forms, and from concurrent or background transaction processing that requires availability and source resolution. It is not intended for direct invocation by custom code, and no other packages are documented as referencing it, which limits its exposure but also means Oracle may modify it without notice. Developers extending EBS functionality should prefer supported public APIs for reservation and material transaction processing and use this package only for diagnostic or read-only investigation. Because it accesses temporary and staging tables, concurrent invocations should be assessed for session-level data isolation.