APPS.MTL_LOT_UOM_CONV_PVT dependencies on MTL_LOT_NUMBERS

Line 370: from mtl_lot_numbers table */

366: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%TYPE;
367: l_secondary_uom MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE%TYPE;
368:
369: /* Bug#5228919 added the following cursor to get the lot attributes
370: from mtl_lot_numbers table */
371: CURSOR c_get_attr IS
372: SELECT mln.*
373: FROM mtl_lot_numbers mln
374: WHERE organization_id = p_lot_uom_conv_rec.organization_id

Line 373: FROM mtl_lot_numbers mln

369: /* Bug#5228919 added the following cursor to get the lot attributes
370: from mtl_lot_numbers table */
371: CURSOR c_get_attr IS
372: SELECT mln.*
373: FROM mtl_lot_numbers mln
374: WHERE organization_id = p_lot_uom_conv_rec.organization_id
375: AND inventory_item_id = p_lot_uom_conv_rec.inventory_item_id
376: AND lot_number = p_lot_uom_conv_rec.lot_number;
377:

Line 378: l_lot_rec mtl_lot_numbers%ROWTYPE;

374: WHERE organization_id = p_lot_uom_conv_rec.organization_id
375: AND inventory_item_id = p_lot_uom_conv_rec.inventory_item_id
376: AND lot_number = p_lot_uom_conv_rec.lot_number;
377:
378: l_lot_rec mtl_lot_numbers%ROWTYPE;
379:
380: -- Bug 5533886
381: Cursor get_batch_transactions IS
382: SELECT *