⬅ Back Lot NO Remove Query.sql
use T24S001

select * from item_finalization where toplotno='1655'

select * from TblIFChallanTblIFChallan_KING where LotNo='1655'
select * from FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL where LotNo='1655'
select * from grey_send_to_mill where SrNo ='000024'
select * from GREY_SEND_TO_MILL_TAKA_DETAIL where SrNo ='000024'

select * from opening_grey_send_to_mill where SrNo='00094'
select * from GREY_RETURN_FROM_MILL_CHALLAN_DETAIL where millsendSrNo='00094'

update FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL set finitemname = ''