APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 5946: mtl_transaction_lot_numbers mtln,

5942: AND ROWNUM = 1
5943: UNION --uncommented code for 6965008
5944: select '1'
5945: FROM mtl_unit_transactions mut,
5946: mtl_transaction_lot_numbers mtln,
5947: mtl_material_transactions mmt
5948: WHERE mut.inventory_item_id = p_item_id
5949: AND mut.serial_number = p_srl_num
5950: AND mtln.organization_id = mut.organization_id

Line 6190: FROM mtl_transaction_lot_numbers

6186: SELECT transaction_id,
6187: lot_number
6188: INTO l_mtl_txn_id,
6189: l_lot_number
6190: FROM mtl_transaction_lot_numbers
6191: WHERE serial_transaction_id = unit_txn_rec.transaction_id;
6192: EXCEPTION
6193: WHEN no_data_found THEN
6194: l_mtl_txn_id := unit_txn_rec.transaction_id;