APPS.INL_SHIPMENT_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 1398: FROM mtl_units_of_measure

1394: p_var_value => x_unit_of_measure);
1395: -- Get the UOM Code
1396: SELECT uom_code
1397: INTO x_uom_code
1398: FROM mtl_units_of_measure
1399: WHERE unit_of_measure = x_unit_of_measure;
1400: INL_LOGGING_PVT.Log_Variable (
1401: p_module_name => g_module_name,
1402: p_procedure_name => l_program_name,

Line 1436: FROM mtl_units_of_measure_vl mum

1432: -- Get the transaction UOM description. This will be used to show the
1433: -- validation error message in the transaction uom instead of the primary uom.
1434: SELECT mum.unit_of_measure_tl
1435: INTO l_txn_uom_tl
1436: FROM mtl_units_of_measure_vl mum
1437: WHERE mum.uom_code = p_txn_uom_code;
1438: -- Since Primary and Transaction UOM are different, convert to Transaction UOM.
1439: IF p_txn_uom_code <> p_primary_uom_code THEN
1440: l_msg_tolerable_qty := INL_LANDEDCOST_PVT.converted_qty (

Line 1452: FROM mtl_units_of_measure_vl

1448: ELSE
1449: -- Get the Primary Unit of Measure Description
1450: SELECT unit_of_measure_tl
1451: INTO l_primary_uom_tl
1452: FROM mtl_units_of_measure_vl
1453: WHERE uom_code = p_primary_uom_code;
1454: l_msg_tolerable_qty := x_tolerable_quantity;
1455: l_msg_uom_tl := l_primary_uom_tl;
1456: END IF;

Line 1821: mtl_units_of_measure muom

1817: l_po_UOM_code,
1818: l_po_qty,
1819: l_inventory_item_id
1820: FROM inl_enter_receipts_v po, -- BUG#8229331 (Pls see bug 9179775)
1821: mtl_units_of_measure muom
1822: WHERE po.po_line_location_id = p_ship_line_src_id
1823: AND muom.unit_of_measure (+) = po.ordered_uom;
1824: INL_LOGGING_PVT.Log_Variable (
1825: p_module_name => g_module_name,

Line 5376: FROM mtl_units_of_measure um,

5372: SELECT rt.transaction_id,
5373: um.uom_code
5374: INTO l_rt_transaction_id,
5375: l_rt_uom_code
5376: FROM mtl_units_of_measure um,
5377: rcv_transactions rt,
5378: inl_ship_lines sl
5379: WHERE um.unit_of_measure = rt.unit_of_measure
5380: AND rt.destination_type_code = 'RECEIVING'

Line 5532: FROM mtl_units_of_measure um,

5528: SELECT rt.transaction_id,
5529: um.uom_code
5530: INTO l_rt_transaction_id,
5531: l_rt_uom_code
5532: FROM mtl_units_of_measure um,
5533: rcv_transactions rt,
5534: inl_ship_lines sl
5535: WHERE um.unit_of_measure = rt.unit_of_measure
5536: AND rt.destination_type_code = 'RECEIVING'