How to Delete Stuckked/corrupted Lock Box Transmission format

select * from APPS.AR_TRANSMISSIONS_ALL
where TRANSMISSION_NAME='IMCC161107';


delete from apps.ar_transmissions_all
where transmission_name='IMCC161107'


select * from apps.ar_payments_interface_all
where ORG_ID=82
and TRANSMISSION_ID=12172459;


Thanks,
Nagaraju M