Search Results inv_update_type

Overview

APPS.MTL_ITEM_LOT_UOM_CONV_ERV is a reporting view within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environment. The suffix "ERV" denotes an Enterprise Reporting View, a class of database objects engineered specifically to flatten normalized transactional data into a form suitable for operational reporting, data extraction, and integration with external systems or analytics platforms. As its name implies, the view consolidates unit-of-measure (UOM) conversion definitions and their associated audit history at the item, lot, and organization level, producing a denormalized result set that is simpler to query than the underlying transactional tables.

The view is particularly relevant to the inv_update_type lookup, which is the mechanism used to classify the action recorded against each conversion record (for example, create, update, or delete). By exposing the human-readable lookup meaning alongside the technical conversion attributes, the view supports auditing, traceability, and reconciliation of lot-specific and item-specific UOM conversion activity.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over the following base objects, joined in a UNION-all style construct that combines lot-level conversions with item intra-class conversions:

• MTL_LOT_UOM_CLASS_CONVERSIONS (LUC) — the primary driver of the lot-level branch, holding lot-to-lot UOM conversion rates.
• MTL_LOT_CONV_AUDIT (MLA) — the audit trail linked to each conversion via CONVERSION_ID.
• MFG_LOOKUPS (MLK) — supplies the UPDATE_TYPE meaning where LOOKUP_TYPE = 'INV_UPDATE_TYPE'.
• MTL_SYSTEM_ITEMS_KFV (MSI) — provides item number (concatenated segments), description, and primary/secondary UOM codes.
• MTL_PARAMETERS (MP) and HR_ALL_ORGANIZATION_UNITS (H) — resolve organization code and name.
• MTL_TRANSACTION_REASONS (MR) — offers the reason name for the audited change.
• GME_BATCH_HEADER (GBH) — supplies the batch number associated with the audit record.
• MTL_UNITS_OF_MEASURE, MTL_UOM_CLASS_CONVERSIONS, MTL_UOM_CONVERSIONS — feed the item intra-class branch of the union.

Key Columns

• EVENT_ID — a synthesized concatenation of CONVERSION_ID and CONV_AUDIT_ID, giving each audited event a unique identifier.
• CONVERSION_TYPE — distinguishes 'LOT' conversions from 'ITEM-INTRA' conversions within the union result.
• UPDATE_TYPE — the decoded lookup meaning from MFG_LOOKUPS for the INV_UPDATE_TYPE lookup type, indicating the nature of the audit action.
• LOT_NUMBER, ORGANIZATION_ID, INVENTORY_ITEM_ID, ITEM_NUMBER, ITEM_DESCRIPTION — identify the affected lot, organization, and item.
• FROM_UNIT_OF_MEASURE / TO_UNIT_OF_MEASURE with their UOM_CODE and UOM_CLASS counterparts — define the conversion direction and classes.
• CONVERSION_RATE, DISABLE_DATE, PRIMARY_UOM_CODE, SECONDARY_UOM_CODE — conversion magnitude and item UOM configuration.
• BATCH_ID, BATCH_NO, REASON_NAME — supporting audit context.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit columns for record provenance.

Common Use Cases and Queries

The view is typically used to report on UOM conversion changes for audit and compliance purposes, and to feed conversion data into downstream systems. A representative query filtering by the inv_update_type lookup meaning is shown below:

• Audit reporting: SELECT EVENT_ID, ITEM_NUMBER, LOT_NUMBER, FROM_UNIT_OF_MEASURE, TO_UNIT_OF_MEASURE, CONVERSION_RATE, UPDATE_TYPE FROM APPS.MTL_ITEM_LOT_UOM_CONV_ERV WHERE UPDATE_TYPE = 'Update' ORDER BY CREATION_DATE DESC;
• Organization-level extraction: filter by ORGANIZATION_CODE and a date range on CREATION_DATE or LAST_UPDATE_DATE.
• Integration feeds: select the full column set for a given INVENTORY_ITEM_ID for loading into external quality or inventory analytics repositories.

Because the view already resolves the INV_UPDATE_TYPE lookup meaning and joins organization, item, batch, and reason descriptors, it removes the need for report authors to replicate these joins, making it the preferred source for conversion-related reporting in EBS 12.1.1 and 12.2.2.