APPS.OE_DUAL_UOM_UTIL dependencies on MTL_UNITS_OF_MEASURE

Line 75: MTL_UNITS_OF_MEASURE muomt1,

71: p_inventory_item_rec.reservable_type ,
72: p_inventory_item_rec.primary_uom_class,
73: p_inventory_item_rec.secondary_uom_class
74: FROM mtl_system_items msi,
75: MTL_UNITS_OF_MEASURE muomt1,
76: MTL_UNITS_OF_MEASURE muomt2
77: WHERE msi.primary_uom_code = muomt1.uom_code
78: AND msi.secondary_uom_code = muomt2.uom_code(+)
79: AND msi.inventory_item_id = p_line_rec.inventory_item_id

Line 76: MTL_UNITS_OF_MEASURE muomt2

72: p_inventory_item_rec.primary_uom_class,
73: p_inventory_item_rec.secondary_uom_class
74: FROM mtl_system_items msi,
75: MTL_UNITS_OF_MEASURE muomt1,
76: MTL_UNITS_OF_MEASURE muomt2
77: WHERE msi.primary_uom_code = muomt1.uom_code
78: AND msi.secondary_uom_code = muomt2.uom_code(+)
79: AND msi.inventory_item_id = p_line_rec.inventory_item_id
80: AND msi.organization_id = p_line_rec.ship_from_org_id;

Line 337: FROM MTL_UNITS_OF_MEASURE

333: --5 .If Ordered UOM CLASS is same as Secondary UOM CLASS then return FB as 'S'
334: --------------------------------------------------------------
335: SELECT UOM_CLASS
336: INTO l_inventory_item_rec.ordered_uom_class
337: FROM MTL_UNITS_OF_MEASURE
338: WHERE uom_code = p_line_rec.order_quantity_uom ;
339:
340: IF l_debug_level > 0 THEN
341: oe_debug_pub.add('derive_fulfillment_base: ordered_uom_class ' ||l_inventory_item_rec.ordered_uom_class );