Results for “from_uom_typ”

4 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PMITS_ITEM_LOT_UOM_CONV_V is an Oracle E-Business Suite view owned by the APPS schema. It exposes unit-of-measure (UOM) conversion definitions at the intersection of an inventory item and a specific lot/sublot. The view is part of the process manufacturing (Process Manufacturing / Oracle Process Manufacturing) data model that EBS 12.1.1 and 12.2.2 retain for legacy inventory and lot conversion reporting. Unlike many conversion views that operate purely at the item level, this view joins item master, lot master, and UOM type master data so that each row represents a conversion factor applicable to a defined item-lot combination.

The name embeds ITEM_LOT_UOM_CONV, indicating the three dimensions the view resolves: item, lot, and unit of measure. The PMITS prefix reflects its association with the process manufacturing item/inventory stack. A user searching for from_uom_typ is looking at the column that carries the UOM type of the item's primary/from UOM (for example, weight, volume, or quantity). The view also projects a to_uom_typ derived from the conversion's target UM type, enabling type-to-type conversion analysis.

Underlying Base Objects

Per the ETRM metadata, the view is defined over the following referenced objects:

The join condition ITEM.ITEM_UM = FROM_ITEM_UOM.UM_CODE AND FROM_ITEM_UOM.UM_TYPE = FROM_UOM_TYP.UM_TYPE establishes that the "from" UOM type is the type of the item's base UOM. The "to" side is resolved via TO_UOM_TYP.UM_TYPE = CNV.UM_TYPE. Lot linkage is enforced with CNV.ITEM_ID = LOT.ITEM_ID AND CNV.LOT_ID = LOT.LOT_ID.

Key Columns

  • FROM_UOM_TYP.UM_TYPE — the UOM type of the item's base unit, the column referenced by searches for from_uom_typ; corresponds to the type of ITEM_UM.
  • TO_UOM_TYP.UM_TYPE / CNV.UM_TYPE — the UOM type of the conversion's target unit on the IC_ITEM_CNV row.
  • FROM_UOM_TYP.STD_UM / TO_UOM_TYP.STD_UM — the standard UOM associated with each resolved type, useful for normalization.
  • LOT_ID, LOT_NO, SUBLOT_NO — lot and sublots identifying the specific batch context of the conversion.
  • ITEM_ID, ITEM_NO, ITEM_UM — item identity and base UOM.
  • TYPE_FACTOR / TYPE_FACTORREV — forward and reverse conversion factors between the UOM types.
  • DELETE_MARK — soft-delete flag; active rows expect a value indicating not deleted.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, TEXT_CODE — standard audit and reference columns.

Common Use Cases and Queries

Typical uses include validating lot-level conversion factors, reconciling quantity conversions between weight and volume for a specific batch, and reporting which UOM types participate in an item's conversions.

SELECT item_no, lot_no, sublot_no,
       um_type AS to_um_type,
       type_factor, type_factorrev
FROM   apps.pmits_item_lot_uom_conv_v
WHERE  item_no = :item
AND    from_uom_typ = :uom_type
AND    delete_mark = 0;

Analysts filtered by from_uom_typ use it to isolate conversions originating from a given UOM type (for example, all weight-based conversions) and compare them against the resolved target type. Because the view surfaces both sides of the type relationship plus the item and lot identifiers, it is well suited to audit, reconciliation, and integration extracts where per-lot conversion accuracy is required.