Results for “primary_uom_class”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MTL_UOM_CONVERSIONS_VIEW is an APPS-owned database view in the Oracle E-Business Suite Inventory (INV) module. It is defined with VALID status and is available in both the 12.1.1 and 12.2.2 releases. Its documented purpose is to present unit of measure (UOM) conversion rates between an item's primary unit of measure and another unit of measure. Rather than exposing the raw conversion rows stored in the underlying conversion tables, the view resolves and computes the effective conversion factor between the primary UOM and each associated UOM based on item-specific, class-level, and standard conversion data.
Because the view operates at the intersection of items, organizations, UOM classes, and conversion definitions, it plays a central role in reporting and integration scenarios that require a normalized, query-ready representation of item UOM relationships. Report developers, interface builders, and conversion programs query it to avoid re-implementing the complex resolution logic embedded in the view text.
Underlying Base Objects
The view is defined over four documented base objects, resolved through synonyms in the APPS schema:
- MTL_SYSTEM_ITEMS_B (synonym) — supplies the item identity, owning organization, primary unit of measure, and primary UOM code.
- MTL_UNITS_OF_MEASURE_VL (view) — referenced twice to resolve the UOM code of the primary unit of measure and the UOM class of the target unit of measure.
- MTL_UOM_CONVERSIONS (synonym) — the central conversion table, joined three times to obtain item-specific conversion rates and the standard (item-independent) conversion rate.
- MTL_UOM_CLASS_CONVERSIONS (synonym) — provides class-to-class conversion rates where the primary and target UOMs belong to different UOM classes.
The joins are largely outer joins on item and UOM code, which allows the view to return conversion information even when item-specific overrides are absent, falling back to standard and class-level rates.
Key Columns
The view exposes the following significant columns:
- INVENTORY_ITEM_ID — the inventory item for which the conversion is resolved.
- ORGANIZATION_ID — the organization context of the item.
- PRIMARY_UNIT_OF_MEASURE / PRIMARY_UOM_CODE — the item's primary UOM and its internal code.
- UOM_CLASS — the class of the primary unit of measure (from MTL_UNITS_OF_MEASURE_VL).
- UNIT_OF_MEASURE / UOM_CODE — the secondary (target) unit of measure and its internal code.
- CONV2.UOM_CLASS — the UOM class of the secondary unit of measure.
The computed conversion factor is produced by the view's DECODE expression, which multiplies an intra-class factor (1 when both UOMs share a class, otherwise the class conversion rate) by the secondary conversion rate, then divides by the effective primary conversion rate after considering disable dates and item-level overrides.
Common Use Cases and Queries
Typical scenarios include reporting all UOMs available for an item with their resolved conversion factors, validating that an interface supplies conversions consistent with the item definition, and searching by UOM class to group items. A representative query is:
SELECT inventory_item_id, organization_id, primary_uom_code, uom_class, uom_code
FROM apps.mtl_uom_conversions_view
WHERE inventory_item_id = :item_id
AND organization_id = :org_id;
To filter by UOM class, as suggested by the search term "uom_class":
SELECT inventory_item_id, primary_uom_code, uom_class, unit_of_measure
FROM apps.mtl_uom_conversions_view
WHERE uom_class = :uom_class;
Because the view performs significant join and decode work, queries should always be constrained by item, organization, or UOM class to maintain acceptable performance.
-
View giving unit of measure conversion rates between the primary unit of measure and another unit of measure
APPS.MTL_UOM_CONVERSIONS_VIEW·↳ MTL_SYSTEM_ITEMS_B·↳ MTL_UNITS_OF_MEASURE_VL·↳ MTL_UOM_CLASS_CONVERSIONS·Explore INV module →
-
APPS.MSC_UOM_CONVERSIONS_VIEW·↳ MSC_SYSTEM_ITEMS·↳ MSC_UNITS_OF_MEASURE·↳ MSC_UOM_CLASS_CONVERSIONS·Explore MSC module →
-
PACKAGE: APPS.WIP_VALIDATE 12.1.1
-
PACKAGE: APPS.WIP_VALIDATE 12.2.2
-
View giving unit of measure conversion rates between the primary unit of measure and another unit of measure
APPS.MTL_UOM_CONVERSIONS_VIEW·↳ MTL_SYSTEM_ITEMS_B·↳ MTL_UNITS_OF_MEASURE_VL·↳ MTL_UOM_CLASS_CONVERSIONS·Explore INV module →
-
View: INL_ENTER_RECEIPTS_V 12.1.1
A supplementary view used to simplify UI coding (Cloned from RCV_ENTER_RECEIPTS_V).
APPS.INL_ENTER_RECEIPTS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ INL_ENTER_RECEIPTS_PO_V·Explore INL module →
-
APPS.MSC_UOM_CONVERSIONS_VIEW·↳ MSC_SYSTEM_ITEMS·↳ MSC_UNITS_OF_MEASURE·↳ MSC_UOM_CLASS_CONVERSIONS·Explore MSC module →
-
View: POR_RCV_ALL_ITEMS_V1 12.2.2
View for all items that can be received
APPS.POR_RCV_ALL_ITEMS_V1·↳ FND_GLOBAL·↳ MTL_UNITS_OF_MEASURE·↳ PER_ALL_PEOPLE_F·Explore ICX module →
-
APPS.POR_CONFIRM_INTERNAL_RECEIPT_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_UNITS_OF_MEASURE·↳ OE_ORDER_HEADERS·Explore ICX module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_SUPPLIER_V·↳ PO_CLM_INTG_GRP·↳ RCV_ENTER_RECEIPTS_ASN_V·↳ RCV_ENTER_RECEIPTS_PO_V·Explore PO module →
-
View: POR_RCV_ALL_ITEMS_V1 12.1.1
View for all items that can be received
APPS.POR_RCV_ALL_ITEMS_V1·↳ FND_GLOBAL·↳ MTL_UNITS_OF_MEASURE·↳ PER_ALL_PEOPLE_F·Explore ICX module →
-
View: RCV_ENTER_RECEIPTS_V 12.2.2
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ OE_SYS_PARAMETERS·Explore PO module →
-
View: INL_RMA_SOURCE_LINES_V 12.2.2
This view shows expected receipts from Return Material Authorizations.
APPS.INL_RMA_SOURCE_LINES_V·↳ ARPT_SQL_FUNC_UTIL·↳ HZ_CUSTOMER_PARTY_FIND_V·↳ INL_ENTER_RECEIPTS_V·Explore INL module →
-
View: POR_RCV_REQ_ITEMS_V 12.2.2
APPS.POR_RCV_REQ_ITEMS_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_SYSTEM_ITEMS·Explore ICX module →
-
View: RCV_TRANSACTIONS_V 12.1.1
- Retrofitted
APPS.RCV_TRANSACTIONS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_RMA_V·↳ OE_PO_ENTER_RECEIPTS_V·↳ OE_SYS_PARAMETERS·Explore PO module →
-
Requests to process cost transactions
-
Foreign-key data for WIP_COST_TXN_INTERFACE
APPS.WIP_COST_TXN_INTERFACE_V·↳ BOM_RESOURCES·↳ HR_ALL_ORGANIZATION_UNITS·↳ MFG_LOOKUPS·Explore WIP module →
-
APPS.POR_RCV_PURCHASE_ITEMS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_UNITS_OF_MEASURE·↳ PO_DISTRIBUTIONS·Explore ICX module →
-
APPS.POR_RCV_INTERNAL_ITEMS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_UNITS_OF_MEASURE·↳ OE_ORDER_HEADERS_ALL·Explore ICX module →
-
View: POR_RCV_SHIPMENTS_V 12.1.1
APPS.POR_RCV_SHIPMENTS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_UNITS_OF_MEASURE·↳ OE_ORDER_HEADERS_ALL·Explore ICX module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_INTERNAL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ RCV_ENTER_RECEIPTS_INT_REQ_V·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_INTERNAL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ RCV_ENTER_RECEIPTS_INT_REQ_V·Explore PO module →
-
View: INL_RMA_SOURCE_LINES_V 12.1.1
This view shows expected receipts from Return Material Authorizations.
APPS.INL_RMA_SOURCE_LINES_V·↳ ARPT_SQL_FUNC_UTIL·↳ HR_GENERAL·↳ HR_SECURITY·Explore INL module →
-
View: RCV_TRANSACTIONS_V 12.2.2
- Retrofitted
APPS.RCV_TRANSACTIONS_V·↳ FINANCIALS_SYSTEM_PARAMS_ALL·↳ FND_GLOBAL·↳ GL_DAILY_CONVERSION_TYPES·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_RMA_V·↳ OE_PO_ENTER_RECEIPTS_V·↳ OE_SYS_PARAMETERS·Explore PO module →
-
APPS.POR_RCV_ORD_REQUESTER_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore ICX module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_INVENTORY_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·↳ HR_SECURITY·Explore PO module →
-
A supplementary view used to simplify UI coding (Cloned from RCV_ENTER_RECEIPTS_PO_V).
APPS.INL_ENTER_RECEIPTS_PO_V·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_LOCATIONS_ALL_TL·↳ MTL_SYSTEM_ITEMS·Explore INL module →
-
View: POR_RECEIVE_ORDERS_V 12.1.1
Items available for receiving
APPS.POR_RECEIVE_ORDERS_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ HR_EMPLOYEES_CURRENT_V·Explore ICX module →
-
View: INL_IR_SOURCE_LINES_V 12.1.1
This view shows expected receipts from Internal Requisition.
APPS.INL_IR_SOURCE_LINES_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ INL_ENTER_RECEIPTS_V·Explore INL module →
-
APPS.POR_RCV_PURCHASE_ITEMS_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_SYSTEM_ITEMS·Explore ICX module →
-
APPS.POR_RCV_INTERNAL_ITEMS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·↳ HR_SECURITY·Explore ICX module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_INT_REQ_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·↳ HR_SECURITY·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_INT_REQ_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·↳ HR_SECURITY·Explore PO module →
-
View: RCV_ENTER_RECEIPTS_V 12.1.1
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ OE_SYS_PARAMETERS·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_SUP_INT_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ RCV_ENTER_RECEIPTS_ASN_V·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_SUP_INT_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PO_CLM_INTG_GRP·Explore PO module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_SUPPLIER_V·↳ RCV_ENTER_RECEIPTS_ASN_V·↳ RCV_ENTER_RECEIPTS_PO_V·Explore PO module →
-
View: OE_PO_ENTER_RECEIPTS_V 12.1.1
For enter receipts to invoice.
APPS.OE_PO_ENTER_RECEIPTS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ MTL_CUSTOMER_ITEMS·Explore ONT module →
-
- Retrofitted
APPS.POFV_INBOUND_SHIPMENT_LINES·↳ GL_CODE_COMBINATIONS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore PO module →
-
View: RCV_CONFIRM_RECEIPT_V 12.1.1
- Retrofitted
APPS.RCV_CONFIRM_RECEIPT_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore PO module →
-
View: INL_IR_SOURCE_LINES_V 12.2.2
This view shows expected receipts from Internal Requisition.
APPS.INL_IR_SOURCE_LINES_V·↳ INL_ENTER_RECEIPTS_V·Explore INL module →
-
APPS.POR_RCV_ORD_REQUESTER_V·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore ICX module →
-
View: INL_PO_SOURCE_LINES_V 12.2.2
This view shows expected receipts from Purchase Orders.
APPS.INL_PO_SOURCE_LINES_V·↳ FND_GLOBAL·↳ INL_ENTER_RECEIPTS_V·↳ PO_VENDORS·Explore INL module →
-
- Retrofitted
APPS.POFV_RECEIVING_TRANSACTIONS·↳ AP_INVOICES_ALL·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·Explore PO module →
-
View: POR_RCV_REQ_ITEMS_V 12.1.1
APPS.POR_RCV_REQ_ITEMS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_UNITS_OF_MEASURE·↳ OE_ORDER_HEADERS_ALL·Explore ICX module →
-
10SC ONLY - Retrofitted
APPS.RCV_ENTER_RECEIPTS_ASN_V·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_LOCATIONS_ALL_TL·↳ MTL_SYSTEM_ITEMS·Explore PO module →