Search Results eam_material_allocqty_pkg




Overview
Explore in AI Chat

Overview

APPS.EAM_MATERIAL_ALLOCQTY_PKG is a PL/SQL package body in the Oracle E-Business Suite Enterprise Asset Management (EAM) module that provides quantity calculation services for material allocation associated with maintenance work orders and material transactions. Its primary business purpose is to determine how much material is allocated, available, and open against work order material requirements, so that maintenance planners and shop floor users can make accurate replenishment and issuing decisions.

This package is classified as an "OTHER" API in the ETRM documentation. It is not a public, formally versioned API like the FND_API-based interfaces; instead, it is an internal utility package within the EAM schema that other EAM packages and forms consume. The package body is documented with a VALID status in the APPS schema and depends on several core Oracle applications packages, including FND_API, FND_PROFILE, INV_GLOBALS, INV_QUANTITY_TREE_PUB, INV_QUANTITY_TREE_PVT, and STANDARD.

Because EAM material requirements are expressed in multiple units of measure — including primary and secondary UOMs — the package relies on the INV quantity tree utilities to perform UOM conversions when computing allocated and open quantities.

Key Procedures and Functions

The ETRM documentation identifies four documented procedures or functions within this package:

  • ALLOCATED_QUANTITY — Returns the quantity of a material that has already been allocated to a work order or material transaction request. This is used to determine committed material quantities.
  • OPEN_QUANTITY — Returns the open (unfulfilled) quantity remaining against a work order material requirement. This supports backorder and shortage visibility.
  • QUANTITY_ALLOCATED — Provides an allocation quantity value, typically associated with the quantity already reserved or assigned through material allocation logic.
  • GET_ONHAND_AVAIL_QUANT — Retrieves the on-hand available quantity for an item, considering the current inventory position. This supports availability checking prior to allocation or issuing.

The parameter signatures for these procedures are not enumerated in the provided ETRM documentation. The evident pattern is that each function accepts item, organization, and work order context and returns a numeric quantity.

Tables Accessed

Per the documented dependency metadata, this package references the following base tables through APPS synonyms:

  • MTL_TXN_REQUEST_HEADERS — Header information for move order (material transaction request) documents. The package reads this to identify the context of material allocation.
  • MTL_TXN_REQUEST_LINES — Line-level material request details, including item, quantity, and source/destination subinventory. Allocation and open quantity calculations are derived from these lines.
  • MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_B_KFV — Item master details used to resolve item attributes and descriptions.
  • MTL_SECONDARY_INVENTORIES — Subinventory definitions, used to resolve allocation source and destination locations.
  • MTL_ITEM_QUANTITIES_VIEW — On-hand and available quantity view used by GET_ONHAND_AVAIL_QUANT.

Usage Notes

This package is typically invoked indirectly through EAM maintenance work order processing, material allocation workflows, and shop floor material issue forms. It is referenced by eight other database objects, indicating it is a shared internal service rather than a standalone API. It is not referenced by any EAM form or concurrent program directly as a public interface; instead, it is called from other EAM packages and potentially from custom extensions that need to compute allocated, open, or available quantities for maintenance material. Developers extending EAM material logic should call this package through its documented functions rather than querying the underlying tables directly, to preserve UOM conversion and profile-based behavior handled by INV_GLOBALS and FND_PROFILE.