APPS.INV_LPN_TRX_PUB dependencies on MTL_LOT_NUMBERS

Line 632: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL; --12949776

628: l_exp_date DATE;
629: l_primary_uom VARCHAR2(3);
630: l_primary_qty NUMBER;
631: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
632: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL; --12949776
633: BEGIN
634: -- retrieve the expiration-date for the lot number
635: -- being inserted
636: BEGIN

Line 646: FROM mtl_lot_numbers

642: END IF;
643:
644: SELECT expiration_date, parent_lot_number
645: INTO l_exp_date, l_parent_lot_number
646: FROM mtl_lot_numbers
647: WHERE organization_id = curlpnrec.organization_id
648: AND inventory_item_id = curlpnrec.content_item_id
649: AND lot_number = curlpnrec.lot_number;
650: EXCEPTION

Line 3694: from mtl_transaction_lot_numbers mtln,mtl_lot_numbers mln

3690: );
3691: /* BUG 5361705 - raise opm qm event for every distinct lot */
3692: Cursor cr_get_distinct_lots(l_txn_id NUMBER) IS
3693: select distinct mtln.product_transaction_id,mln.gen_object_id
3694: from mtl_transaction_lot_numbers mtln,mtl_lot_numbers mln
3695: where transaction_id = l_txn_id
3696: and mln.lot_number = mtln.lot_number
3697: and mln.inventory_item_id = mtln.inventory_item_id
3698: and mln.organization_id = mtln.organization_id;