USE E27S002


delete FROM INWARD_ITEM_DETAIL where SrNo in (select srno from INWARD WHERE WeaverCode='26LD001')
delete FROM INWARD_ITEM_GREY_TAKA_DETAIL where SrNo in (select srno from INWARD WHERE WeaverCode='26LD001')
delete FROM INWARD_ITEM_TAKA_DETAIL where SrNo in (select srno from INWARD WHERE WeaverCode='26LD001')
DELETE FROM INWARD WHERE WeaverCode='26LD001'




SELECT * FROM OPENING_INWARD WHERE WeaverCode='26LD001'
SELECT * FROM OPENING_INWARD_ITEM_DETAIL WHERE WeaverCode='26LD001'
SELECT * FROM OPENING WHERE WeaverCode='26LD001'
SELECT * FROM OPENING_INWARD WHERE WeaverCode='26LD001'
SELECT * FROM OPENING_INWARD WHERE WeaverCode='26LD001'