DBA Data[Home] [Help]

APPS.INL_SHIPMENT_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 1216: FROM mtl_units_of_measure

1212: p_var_value => x_unit_of_measure);
1213: -- Get the UOM Code
1214: SELECT uom_code
1215: INTO x_uom_code
1216: FROM mtl_units_of_measure
1217: WHERE unit_of_measure = x_unit_of_measure;
1218:
1219: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,
1220: p_procedure_name => l_proc_name,

Line 1279: FROM mtl_units_of_measure_vl

1275: -- Get the Primary Unit of Measure Description that will be
1276: -- used as the token for the over tolerance error message.
1277: SELECT unit_of_measure_tl
1278: INTO l_primary_uom_tl
1279: FROM mtl_units_of_measure_vl
1280: WHERE uom_code = p_primary_uom_code;
1281:
1282: FND_MESSAGE.SET_TOKEN ('SHIP_LINE_NUM', p_ship_line_num) ;
1283: FND_MESSAGE.SET_TOKEN ('QTY', x_tolerable_quantity) ;

Line 1497: mtl_units_of_measure muom

1493: l_po_UOM_code,
1494: l_po_qty,
1495: l_inventory_item_id
1496: FROM inl_enter_receipts_po_v po, -- BUG: 8229331
1497: mtl_units_of_measure muom
1498: WHERE po.po_line_location_id = p_ship_line_src_id
1499: AND muom.unit_of_measure (+) = po.ordered_uom;
1500:
1501:

Line 3369: FROM mtl_units_of_measure um,

3365: SELECT rt.transaction_id,
3366: um.uom_code
3367: INTO l_rt_transaction_id,
3368: l_rt_uom_code
3369: FROM mtl_units_of_measure um,
3370: rcv_transactions rt,
3371: inl_ship_lines sl
3372: WHERE um.unit_of_measure = rt.unit_of_measure
3373: AND rt.destination_type_code = 'RECEIVING'