APPS.MTL_LOT_UOM_CONV_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 129: FROM mtl_units_of_measure

125:
126:
127: CURSOR get_uom_class (p_uom_code VARCHAR2) IS
128: SELECT uom_class
129: FROM mtl_units_of_measure
130: WHERE uom_code = p_uom_code;
131:
132: l_from_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
133: l_to_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

Line 132: l_from_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

128: SELECT uom_class
129: FROM mtl_units_of_measure
130: WHERE uom_code = p_uom_code;
131:
132: l_from_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
133: l_to_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
134: l_ret NUMBER;
135: l_revision NUMBER;
136:

Line 133: l_to_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

129: FROM mtl_units_of_measure
130: WHERE uom_code = p_uom_code;
131:
132: l_from_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
133: l_to_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
134: l_ret NUMBER;
135: l_revision NUMBER;
136:
137: l_header_id NUMBER := NULL;

Line 423: l_transaction_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

419: l_secondary_quantity NUMBER;
420: l_old_primary_quantity NUMBER;
421: l_old_secondary_quantity NUMBER;
422: l_batch_txn_qty NUMBER;
423: l_transaction_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
424: l_catch_weight_acc_id Number ; --MUOM Fulfillment Project
425:
426: BEGIN
427:

Line 544: FROM mtl_units_of_measure_vl

540: CLOSE get_lot_transactions;
541:
542: SELECT uom_class
543: INTO l_transaction_uom_class
544: FROM mtl_units_of_measure_vl
545: WHERE uom_code = x_batch_txns.transaction_uom;
546:
547: i:=1;
548: l_batch_txn_qty := 0;