USE T23D001

---------------find job send by rec. sr. no.
SELECT * FROM SEND_TO_JOB_ITEM_DETAIL WHERE RECSRNO='00001'

---------------opening challan received from job delele
delete from opening_challan_received_from_job_challan_detail WHERE SRNO='00001'
delete from opening_challan_received_from_job WHERE SRNO='00001'