APPS.WMA_COMPLETION dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 145: from mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

141:
142: if(cmpRecord.item_lot_control_code = wip_constants.lot) then
143: select fm_serial_number
144: into l_serialNum
145: from mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
146: where mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
147: and mtlt.transaction_temp_id = cmpRecord.transaction_interface_id;
148: else
149: select fm_serial_number

Line 151: from mtl_serial_numbers_temp

147: and mtlt.transaction_temp_id = cmpRecord.transaction_interface_id;
148: else
149: select fm_serial_number
150: into l_serialNum
151: from mtl_serial_numbers_temp
152: where transaction_temp_id = cmpRecord.transaction_interface_id;
153: end if;
154: end if;
155: