--Remplace el signo #, ## por el/los codigo(s) de usuarios a eliminar (según la columna Codusuario de la tabla USUARIOS)

DELETE from Group_users Where CODUSUARIO in (#, ##);
DELETE from Asdk_user_vendor Where USER_ID in (#, ##); 
update Asdk_templates set FL_INT_USER_ID = 1 Where FL_INT_USER_ID in (#, ##); 
update Asdk_projects set fl_int_owner_id = 1 Where fl_int_owner_id in (#, ##); 
update Ass_article set fl_int_autor_id = 1 Where fl_int_autor_id in (#, ##); 
DELETE From Asdk_usuarioxproject  Where FL_INT_USUARIO_ID in (#, ##); 
Update Contract set Fl_int_user_id = 1 Where Fl_int_user_id in (#, ##); 
DELETE from Ci_share_user Where FL_INT_USER_ID in (#, ##); 
Update Asdk_incident_change Set Inch_user_id_modifier = 1  Where Inch_user_id_modifier in (#, ##); 
Update Asdk_service_call_problem Set Inpr_user_id_modifier = 1 Where Inpr_user_id_modifier in (#, ##); 
Update Asdk_service_call_self Set inse_user_id_modifier = 1 Where inse_user_id_modifier in (#, ##); 
Update Asdk_service_call_ci Set serv_user_id_modifier = 1  Where serv_user_id_modifier in (#, ##); 
Update Asdk_service_call Set serv_codreceptor = 1 Where serv_codreceptor in (#, ##); 
Update Asdk_service_call Set serv_responsible_id = 1 Where serv_responsible_id in (#, ##); 
Update Asdk_service_call Set serv_author = 1 Where serv_author in (#, ##); 
Update Asdk_service_call Set serv_user_id_modifier = 1 Where serv_user_id_modifier in (#, ##); 

Update Asdk_service_call Set serv_customer_id = 1 Where serv_customer_id in (#, ##); 
Update Asdk_incident_service_call Set Inch_user_id_modifier = 1 Where Inch_user_id_modifier in (#, ##); 
Update Asdk_service Set serv_author = 1 Where serv_author in (#, ##); 
delete from ASS_SEARCH_RESULT Where sere_user_id in (#, ##); 
Update Ass_article Set fl_int_responsible_id = 1 Where fl_int_responsible_id in (#, ##); 
Update ASDK_ACCOUNTING_DETAIL Set acde_user = 1 Where acde_user in (#, ##); 
Update Ass_article Set ARTI_USER_ID_MODIFIER = 1 Where ARTI_USER_ID_MODIFIER in (#, ##); 
delete from Ass_FAVORITE Where favo_user_id in (#, ##); 
Update Asdk_service_call_change Set Inch_user_id_modifier = 1 Where Inch_user_id_modifier in (#, ##); 
Update Asdk_incident_problem Set Inpr_user_id_modifier = 1 Where Inpr_user_id_modifier in (#, ##); 
Update Asdk_problem_change Set Prch_user_id_modifier = 1 Where Prch_user_id_modifier in (#, ##); 
Update Asdk_problem_ci Set Prci_user_id_modifier = 1 Where Prci_user_id_modifier in (#, ##); 
Update asdk_change_ci Set Chci_user_id_modifier = 1 Where Chci_user_id_modifier in (#, ##); 
Update asdk_problem_self Set Prse_user_id_modifier = 1 Where Prse_user_id_modifier in (#, ##); 
Update Asdk_problem Set prob_codreceptor = 1 Where prob_codreceptor in (#, ##); 
Update Asdk_problem Set prob_responsible_id = 1 Where prob_responsible_id in (#, ##); 
Update Asdk_problem Set prob_author = 1 Where prob_author in (#, ##); 
Update Asdk_problem Set prob_user_id_modifier = 1 Where prob_user_id_modifier in (#, ##); 
Update Asdk_change_self Set Prch_user_id_modifier = 1 Where Prch_user_id_modifier in (#, ##); 
Update Asdk_router_hist Set rohi_old_user = 1 Where rohi_old_user in (#, ##); 
Update Asdk_router_hist Set rohi_new_user = 1 Where rohi_new_user in (#, ##); 
Update Asdk_action_hist Set achi_author = 1 Where achi_author in (#, ##); 
Update Asdk_incident_self Set inse_user_id_modifier = 1 Where inse_user_id_modifier in (#, ##); 
Update Asdk_alarms Set RESPONSABLEID = 1 Where RESPONSABLEID in (#, ##); 
Update Ci_configuration_audit Set FL_INT_RESPONSIBLE_ID = 1 Where FL_INT_RESPONSIBLE_ID in (#, ##); 
update Asdk_service set FL_INT_RESPONSABLE_ID = 1  Where FL_INT_RESPONSABLE_ID in (#, ##); 
Update Asdk_voting Set Voti_user_id = 1  Where Voti_user_id in (#, ##); 
Update Asdk_hist_notes Set hino_author = 1  Where hino_author in (#, ##); 
DELETE from Asdk_service_user  Where seus_user_id in (#, ##); 
DELETE from Additionaldata_user  Where CODUSUARIO in (#, ##); 
DELETE from Role_users Where codusuario in (#, ##); 
Update Asdk_hist_voting Set Voti_user_id = 1  Where Voti_user_id in (#, ##); 
Update Asdk_change Set Chan_codreceptor = 1  Where Chan_codreceptor in (#, ##); 
Update Asdk_change Set chan_responsible_id = 1  Where chan_responsible_id in (#, ##); 
Update Asdk_change Set chan_author = 1  Where chan_author in (#, ##); 
Update Asdk_change Set chan_user_id_modifier = 1  Where chan_user_id_modifier in (#, ##); 
Update Asdk_change Set chan_customer_id = 1  Where chan_customer_id in (#, ##); 
DELETE from Asdk_sla_ula_user  Where suus_user_id in (#, ##); 
Update Ci_historical_item Set FL_INT_USER_COMMENT_ID = 1  Where FL_INT_USER_COMMENT_ID in (#, ##); 
Update Asdk_incident_ci Set Inci_user_id_modifier = 1  Where Inci_user_id_modifier in (#, ##); 
Update Asdk_incident Set Inci_codreceptor = 1  Where Inci_codreceptor in (#, ##); 
Update Asdk_incident Set Inci_responsible_id = 1  Where Inci_responsible_id in (#, ##); 
Update Asdk_incident Set Inci_author = 1  Where Inci_author in (#, ##); 
Update Asdk_incident Set Inci_user_id_modifier = 1  Where Inci_user_id_modifier in (#, ##); 
Update Asdk_incident Set Inci_customer_id = 1  Where Inci_customer_id in (#, ##); 
Update Ci_configuration_item Set FL_INT_USER_INCHARGE_ID = 1  Where FL_INT_USER_INCHARGE_ID in (#, ##); 
Update Divices Set CodUsuario = 1  Where CodUsuario in (#, ##); 
Update Divicestype Set CodUsuario = 1  Where CodUsuario in (#, ##); 
Update Asdk_groupsxproject Set FL_INT_USERELATION = 1  Where FL_INT_USERELATION in (#, ##); 
Update Asdk_Category Set FL_INT_COD_ESPECIALISTA = 1  Where FL_INT_COD_ESPECIALISTA in (#, ##); 
DELETE from Users_config_mail  Where FL_INT_CODUSUARIO in (#, ##); 
Update Vendor Set Contact_id = 1  Where Contact_id in (#, ##); 
Update Workstationprofile set Codusuario = 1  Where Codusuario in (#, ##); 
DELETE from dash_group_usuarios  Where Codusuario in (#, ##); 
Update APRTM_PRINTJOB set Userid = 1 Where Userid in (#, ##); 
Update PARTTYPE set Codusuario = 1 Where Codusuario in (#, ##); 
Update Grouphd set grp_user = 1 Where grp_user in (#, ##); 
Update PCLISTNOTE set Codusuario = 1 Where Codusuario in (#, ##); 
Update AQM_REPORT_DETAIL set Codusuario_created = 1 Where Codusuario_created in (#, ##); 
Update AQM_REPORT_DETAIL set Codusuario_modified = 1 Where Codusuario_modified in (#, ##); 
delete from AQM_GROUP_USERS Where codusuario in (#, ##); 
Delete From ADASH_USUARIOxGROUP Where CODUSUARIO in (#, ##);
Delete from ASDK_CONCURRENCY Where FL_STR_SESSIONID in (Select FL_STR_SESSIONID from ASDK_LICENCE Where FL_INT_USER_ID in (#, ##)); 
Delete from ASDK_LICENCE Where FL_INT_USER_ID in (#, ##); 
Delete from APRTM_USERLICENCE Where USERID in (#, ##); 
Delete from AFW_ADSYNCHRONIZATION_CONTROL Where sync_userid in (#, ##); 
Update asdk_survey_cases set SURV_USER_ID = 1 where SURV_USER_ID in (#, ##);
update dbo.AQM_FOLDER set CODUSUARIO_CREATED = 1 where CODUSUARIO_CREATED in (#, ##);
update dbo.AQM_FOLDER set CODUSUARIO_MODIFIED = 1 where CODUSUARIO_MODIFIED in (#, ##);
update dbo.AQM_REPORT set CODUSUARIO_CREATED = 1 where CODUSUARIO_CREATED in (#, ##);
update dbo.AQM_REPORT set CODUSUARIO_MODIFIED = 1 where CODUSUARIO_MODIFIED in (#, ##);
update CI_CONFIGURATION_ITEM set conf_user_id_modifier = null where conf_user_id_modifier in (#, ##);
update CI_CONFIGURATION_ITEM set conf_user_id_creation = null where conf_user_id_creation in (#, ##);

Delete from AFW_CONFIG_FRONTEND Where ID_USER in (#, ##); 
Delete from ASDK_HIST_FILES where hifi_author in (#, ##); 
Delete from ASDK_CALC_DATES_CONTROL where cdco_user in (#, ##); 
delete from AFW_ROUTING_CONFIG where roco_routing in (select rout_id from afw_routing where rout_inactiveuser in(#, ##))
Delete from AFW_ROUTING_EXEC where roex_routing in (#, ##);
Delete from AFW_ROUTING where rout_inactiveuser in (#, ##); 
Delete from AFW_ROUTING_MANUAL where roma_initialuser in (#, ##); 
Delete from AFW_ROUTING_MANUAL where roma_finaluser in (#, ##); 
Delete from AFW_ROUTING_MANUAL where roma_modifyuser in (#, ##); 
Update ASDK_PRECASE Set prec_author = 1  Where prec_author in (#, ##); 
Update ASDK_PRECASE Set prec_customer = 1  Where prec_customer in (#, ##);

DELETE from USUARIOS where codusuario in (#, ##);

--Commit; --Solo para Oracle