DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 3418: from mtl_transaction_lot_numbers mtln,mtl_lot_numbers mln

3414: );
3415: /* BUG 5361705 - raise opm qm event for every distinct lot */
3416: Cursor cr_get_distinct_lots(l_txn_id NUMBER) IS
3417: select distinct mtln.product_transaction_id,mln.gen_object_id
3418: from mtl_transaction_lot_numbers mtln,mtl_lot_numbers mln
3419: where transaction_id = l_txn_id
3420: and mln.lot_number = mtln.lot_number
3421: and mln.inventory_item_id = mtln.inventory_item_id
3422: and mln.organization_id = mtln.organization_id;