USE T23S001

delete from OPENING_CHALLAN_RECEIVED_FOR_JOB_BILL_CHALLAN_DETAIL  WHERE SRNO IN (SELECT SRNO FROM OPENING_CHALLAN_RECEIVED_FOR_JOB_BILL WHERE JOBCODE = '12LB006')
delete from OPENING_CHALLAN_RECEIVED_FOR_JOB_BILL WHERE JOBCODE = '12LB006'