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:
IC_ITEM_CNV(synonym) — the item conversion table (CNV), supplying the conversion rows,UM_TYPE, and the forward/reverse conversion factors.IC_ITEM_MST(synonym) — the item master (ITEM), supplying item identity and the item's base UOM (ITEM_UM).IC_LOTS_MST(synonym) — the lot master (LOT), supplyingLOT_ID,LOT_NO, andSUBLOT_NO.SY_UOMS_MST_V(view) — the UOM master (FROM_ITEM_UOM), providing the UOM code andUM_TYPEthat anchors the "from" side of the conversion.SY_UOMS_TYP_V(view) — aliased twice, asFROM_UOM_TYPandTO_UOM_TYP, to resolve UOM types and their standard UOMs on both sides of the conversion.
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 ofITEM_UM. - TO_UOM_TYP.UM_TYPE / CNV.UM_TYPE — the UOM type of the conversion's target unit on the
IC_ITEM_CNVrow. - 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.
-
This is created on top of OPM IC_ITEM_CNV. This view gives UOM Conversion factor at item lot level.
APPS.PMITS_ITEM_LOT_UOM_CONV_V·↳ IC_ITEM_CNV·↳ IC_ITEM_MST·↳ IC_LOTS_MST·Explore PMI module →
-
This is created on top of OPM IC_ITEM_CNV. This view gives UOM Conversion factor at item lot level.
APPS.PMITS_ITEM_LOT_UOM_CONV_V·↳ IC_ITEM_CNV·↳ IC_ITEM_MST·↳ IC_LOTS_MST·Explore PMI module →