update tbl_IMPORT_InitiativeTargets set manufacturer_name = where eai_batchid = update tbl_IMPORT_InitiativeTargets set purchasing_status = where eai_batchid = update tbl_IMPORT_InitiativeTargets set supplier_status = where eai_batchid = select eai_batchid from tbl_IMPORT_InitiativeTargets where eai_batchId = and ownerId = and ownerType = and companyType = 'OPERATOR' select eai_batchid from tbl_IMPORT_InitiativeTargets where eai_batchId = and ownerType = and ownerId = and companyType = 'DISTRIBUTOR' select count(*) lineCount from tbl_IMPORT_InitiativeTargets where eai_batchId = and ownerId = and ownerType = and nullif( purchasing_status, '' ) is not null and nullif( product_code, '' ) is not null and fseOperatorId is not null #qmd_batch.resultsText#

---

#_outputHTML# update tbl_EAI_inboundBatches set processingState = where batchId = and ownerId = and ownerType =