Search Results inv_view_mtl_txn




Overview
Explore in AI Chat

Overview

INV_VIEW_MTL_TXN is an Oracle Application Object Library package owned by the APPS schema and classified under ETRM as OTHER. It is a presentation-support package for the Oracle Inventory transaction inquiry interface. Its principal business function is to assemble and return the descriptive information that Oracle EBS displays when a user examines a material transaction from the Transaction View window rather than the raw coded values that are physically stored in the transaction tables. The package resolves foreign-key relationships between the transaction and the surrounding Inventory and Warehouse Management setup, converts internal identifiers into user-recognizable text, and supplies the descriptive output consumed by the view interface.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents two callable units within the package:

  • GET_DESCRIPTION — Retrieves and returns the descriptive text associated with a material transaction attribute. It supplies the human-readable equivalent of stored identifiers so that the Transaction View screen presents meaningful labels to the user instead of numeric keys.
  • UPDATE_MMT_PROCESS_COST — Operates against MTL_MATERIAL_TRANSACTIONS to update the process-cost indicator on a transaction record. This supports the costing status maintained on the material transaction row and is used when the transaction inquiry process determines that the cost-processing flag must be adjusted.

Tables Accessed

The package reads and writes through APPS synonyms over the following tables. Setup tables resolve transaction attributes into display values: MTL_TRANSACTION_TYPES and MTL_TXN_SOURCE_TYPES identify the transaction type and source; MTL_TRANSACTION_REASONS supplies the reason name associated with a transaction; CST_COST_GROUPS and BOM_DEPARTMENTS provide cost group and department descriptions; HR_ALL_ORGANIZATION_UNITS resolves the owning organization; and MTL_PARAMETERS provides Inventory organization-level defaults and controls. The Warehouse Management tables WMS_LICENSE_PLATE_NUMBERS, WMS_RULES, and WMS_STRATEGIES supply license plate, rule, and strategy descriptions for LPN-enabled transactions. MTL_MATERIAL_TRANSACTIONS is the central transaction entity read by the package and the table updated by UPDATE_MMT_PROCESS_COST.

Usage Notes

INV_VIEW_MTL_TXN is invoked from the Oracle Inventory Transaction View form and related inquiry windows, where its description routines populate display fields and its cost-processing update handles the process-cost flag on the underlying material transaction. It is not referenced by any other database package in the ETRM 12.2.2 dependency set, so its consumers are form-level and custom-code callers rather than other PL/SQL APIs. Customizations that extend transaction inquiry screens can call the package directly to obtain consistent descriptions rather than duplicating the joins against transaction type, reason, cost group, and WMS setup tables. Because the package reads and updates MTL_MATERIAL_TRANSACTIONS, any custom invocation must respect the standard Inventory transaction validation and locking conventions. Both 12.1.1 and 12.2.2 maintain the package in VALID status under the APPS schema; 12.2.x Online Patching requires that modifications to the package body and its dependent objects be delivered as covered objects in a patch cycle. All access is routed through APPS synonyms, and behavior depends on the effective user's security profile for Inquiries Only versus full update capability.