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