select nel.* from tbl_IMPORT_NewEquipmentList nel where nel.eai_batchId = and nel.ownerId = and nel.ownerType = delete from tbl_OPR_AvailableEquipment where ownerId = and ownerType = delete from tbl_OPR_EquipmentStatus where ownerId = and ownerType = INSERT INTO tbl_OPR_AvailableEquipment ( ownerId, ownerType, equipmentCode, category, manufacturer, modelName, modelNbr, createUserId, createDate, updateUserId, updateDate, obsolete ) VALUES ( , , , , , , , 0, {fn now()}, 0, {fn now()}, ) update tbl_IMPORT_NewEquipmentList set fseProcessLine = 'Y' where eai_batchId = and eai_lineNumber = and ownerId = and ownerType =