USE T21S001





select * from RECEIVED_RETURN_GOODS_ITEM_DETAIL where BkItemName in (select ItemName from FINISHED_ITEM_MASTER where DescGST='SYNTHETIC FABRIC') and BkPer='p' and HSNCode='6005'

select * from BILL_ITEM_DETAIL where ItemName in (select ItemName from FINISHED_ITEM_MASTER where DescGST='SYNTHETIC FABRIC') and ItemPer='p' and HSNCode='6005'