delete from task.processes where ProcessID in(
select a.ProcessID from task.processes A
inner join WorkFlow.ProcessDefinition B on a.ProcessDefID=b.ProcessDefID
where b.TableID in (select TableID from generator.ModuleTables where TableName in (
'AdjustInventoryDetails'
,'AdjustInventory'
,'ASNDetails'
,'ASNPDATemp'
,'ASN'
,'StockDraftDetails'
,'StockDraftRecPDATemp'
,'StockDraft'
,'Delivery'
,'IssueOrderDetails'
,'BasketDiff'
,'BasketLog'
,'BasketControlItemPDATemp'
,'BasketControlItem'
,'Basket'
,'IssueOrder'
,'PurchaseInvoiceDetails'
,'PurchaseInvoice'
,'ShelfHistory'
,'ShelfStock'
,'DeliveryDetails'
,'InventoryFirstStockDetails'
,'InventoryFirstStock'
,'OnLineSaleDetails'
,'OnLineSale'
,'MojodiReview'
,'MojodiReviewIdentification'
,'MojodiReviewPDATemp'
,'MojodiReviewSetting'
))) |