use T22V003

DELETE FROM OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL 
DELETE FROM OPENING_CHALLAN_RECEIVED_FROM_JOB_TAKA_DETAIL 
DELETE FROM OPENING_CHALLAN_RECEIVED_FROM_JOB_FINISHED_TAKA_DETAIL 
DELETE FROM OPENING_CHALLAN_RECEIVED_FROM_JOB_YARN_TAKA_DETAIL 
DELETE FROM OPENING_CHALLAN_RECEIVED_FROM_JOB_YARN_CONSUMPTION_DETAIL 
DELETE FROM OPENING_CHALLAN_RECEIVED_FROM_JOB 



UPDATE T23V003.DBO.CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL SET READYTOSALE=1