Search Results get_lot

Overview

GMI_GLOBAL_GRP is a global inventory utility package body owned by the APPS schema and classified as a GRP (group) object under Oracle Process Manufacturing (OPM/GMI) in Oracle E-Business Suite 12.1.1 and 12.2.2. Its stated purpose, per the package header documentation, is to contain "global Inventory procedures" — a shared library of lookup and retrieval routines used throughout the OPM inventory and lot-tracking modules. The package encapsulates the most frequently repeated data-access patterns in process manufacturing: resolving an item number to its item master and CPG (compliance/product grouping) records, retrieving lot and lot-inventory context, resolving a warehouse identifier, and normalizing units of measure. By centralizing these lookups, the package provides a single, consistent path to the core OPM inventory tables and shields calling code from the underlying schema.

Key Procedures and Functions

• GET_ITEM — Retrieves item master details for a given item number, returning both the IC_ITEM_MST record and the associated IC_ITEM_CPG record.
• GET_LOT — Retrieves lot master information, providing lot-level context for inventory and quality transactions.
• GET_WAREHOUSE — Resolves and returns warehouse information from the warehouse master, used to validate and describe the stocking location of inventory.
• GET_LOCT_INV — Retrieves location-inventory details, exposing on-hand balances by inventory location.
• GET_UM — Returns unit-of-measure details, used to resolve and describe UOM codes and their associated types.
• GET_LOT_INV — Retrieves lot inventory information, combining lot and inventory context for a given lot at a location.

Tables Accessed

• IC_ITEM_MST — OPM item master; source for item definition details in GET_ITEM.
• IC_ITEM_CPG — Item CPG (compliance/product grouping) attributes returned alongside the item master.
• IC_LOTS_MST — Lot master; source for lot definitions used by GET_LOT and GET_LOT_INV.
• IC_LOTS_CPG — Lot CPG attributes. Note that historical header comments reference the removal of a query against IC_LOTS_CPG in an earlier release, so the package's dependency on this table evolved across versions.
• IC_LOCT_INV — Location inventory; source of on-hand quantities by location for GET_LOCT_INV.
• IC_WHSE_MST — Warehouse master; source for warehouse definitions used by GET_WAREHOUSE.
• SY_UOMS_MST and SY_UOMS_TYP — Unit-of-measure master and UOM type tables backing GET_UM.

All tables are referenced through APPS synonyms, consistent with standard EBS deployment.

Usage Notes

Because the package is classified as a GRP object and is referenced by four other packages, it functions primarily as an internal API layer rather than a user-facing interface. It is typically invoked from OPM inventory and lot-tracking forms, from concurrent programs, and from custom PL/SQL extensions that need item, lot, warehouse, or UOM lookups without re-implementing direct table queries. The 2002 revision added the NOCOPY hint to out-parameters, improving performance for large record outputs — a relevant consideration for custom callers passing full %ROWTYPE records. Callers should treat the procedures as read-only retrieval helpers and rely on the package to remain the authoritative, version-consistent access path to the OPM inventory master tables across 12.1.1 and 12.2.2.