Search Results wms_rules




Overview
Explore in AI Chat

Overview

INV_VIEW_MTL_TXN is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It supports the Inventory module and Warehouse Management System (WMS) functionality by providing display, validation, and supplemental update logic for material transactions viewed through the Oracle EBS user interface. The package is classified as "OTHER" rather than as a formal public API, indicating that it is an internal support utility rather than a documented integration interface. Its dependency graph confirms its role as a read-oriented companion to the transaction tables: it resolves foreign-key references between MTL_MATERIAL_TRANSACTIONS and the surrounding setup and WMS entities so that descriptive values (organization, department, reason, source type, license plate, rule, and strategy) can be presented to users. The package is currently VALID in the data dictionary. Notably, it is not referenced by any other database object, which confirms that it is a leaf-level utility consumed directly by forms rather than a library used by other server-side code.

Key Procedures and Functions

Two documented program units are exposed by the package:

  • GET_DESCRIPTION — Returns a descriptive string for a material transaction or one of its related reference entities. Given its dependency list, it is intended to translate coded transaction attributes into user-readable text, resolving values such as transaction type, reason name, WMS rule, or WMS strategy into meaningful labels for display.
  • UPDATE_MMT_PROCESS_COST — Updates the processing cost information associated with a row in MTL_MATERIAL_TRANSACTIONS (MMT). This is the sole write operation documented for the package and is presumably invoked after a transaction has been created or modified, allowing costing attributes to be stamped onto the transaction record.

No parameter signatures are documented in the ETRM metadata; the names above reflect only the purpose of each unit.

Tables Accessed

The package reads and writes the following documented tables:

Additional dependencies (PO_VENDORS, PO_VENDOR_SITES_ALL, MFG_LOOKUPS, FND_API, FND_MSG_PUB, INV_CONTROL, INV_RELEASE) support supplier name resolution, lookup decoding, and error message handling.

Usage Notes

INV_VIEW_MTL_TXN is typically invoked from the Inventory transaction viewing forms and from WMS-related inquiry screens where a user needs to see decoded transaction detail. Because it is not referenced by any other package or database object, customizations should call it directly rather than expecting it to be triggered indirectly. Developers extending transaction views or building custom inquiry forms can reuse GET_DESCRIPTION to apply consistent decoding logic, while UPDATE_MMT_PROCESS_COST should be invoked only in the controlled circumstances for which Oracle designed it, since it writes to MTL_MATERIAL_TRANSACTIONS. Standard change-control practice applies: the package should not be modified directly; any extension should be implemented through a custom wrapper in a separate schema.