Page History

--Dar de Baja la Cuenta/Tarjeta del Usuario Operativamente (Operaciones via Acceso Cabal)
--Confirmacion de Permisos para dar de Baja el Usuario
--Pasar el Script a Basu (si es que ya no tiene)
--ELiminar usuario Dimo &pi_cedula cedula del usuario
--Dar de Baja la Cuenta/Tarjeta del Usuario Operativamente (Operaciones via Acceso Cabal)
--Confirmacion de Permisos para dar de Baja el Usuario
--Pasar el Script a Basu (si es que ya no tiene)
--ELiminar usuario Dimo &pi_cedula cedula del usuario

delete from dimo_sicoop.d_dusuario where cliente_id = 34044;

delete from dimo_sicoop.d_dispositivo 
where cliente_id = 34044;

delete from dimo_sicoop.d_sesion 
where cliente_id = 34044;

delete from dimo_sicoop.d_cliente_pin_cuenta 
where cuenta_id in (select cuenta_id from dimo_sicoop.d_cliente where cliente_id = 34044);

delete from dimo_sicoop.d_cuenta 
where cliente_id = 34044;

delete from dimo_sicoop.d_operacion 
where cliente_id = 34044;

delete from dimo_sicoop.d_operacion 
where beneficiario_id in (select beneficiario_id from dimo_sicoop.d_beneficiario where cliente_id = 34044);

delete from dimo_sicoop.d_beneficiario 
where beneficiario_id in (select beneficiario_id from dimo_sicoop.d_beneficiario where cliente_id = 34044);

delete from dimo_sicoop.d_cliente_participante 
where cliente_id = 34044;

delete from dimo_sicoop.d_cliente_pin 
where cliente_id = 34044;

delete from dimo_sicoop.D_CLIENTE_BLOQUEO
where cliente_id = 34044;

delete from dimo_sicoop.D_CLIENTE_LIMITE_TRANSACCIONAL_ACUMULADOR
where cliente_id = 34044;

delete from dimo_sicoop.D_CLIENTE_INCIDENCIA_DETALLE
where cliente_incidencia_id in(select cliente_incidencia_id from dimo_sicoop.D_CLIENTE_INCIDENCIA where cliente_id = 34044);

delete from dimo_sicoop.D_CLIENTE_INCIDENCIA
where cliente_id = 34044;

delete from dimo_sicoop.D_PERFIL_LIMITE_TRANSACCIONAL_CLIENTE
where cliente_id = 34044;

delete from dimo_sicoop.D_CLIENTE_DATOS_PERFIL
where cliente_id = 34044;

delete from dimo_sicoop.d_cliente_participante_crm
where cliente_id = 34044;

delete from dimo_sicoop.D_LISTA_NEGRA_USUARIO_DETALLE where LISTA_NEGRA_USUARIO_ID in
(select LISTA_NEGRA_USUARIO_ID from dimo_sicoop.D_LISTA_NEGRA_USUARIO where cliente_id = 34044);

delete from dimo_sicoop.D_LISTA_NEGRA_USUARIO
where cliente_id = 34044;

delete from dimo_sicoop.D_CLIENTE_PROMOCION_DIMO
where cliente_id = 34044;

delete from dimo_sicoop.D_USUARIOS_MAESTRO_VISTA dci 
where cliente_id = 34044;

delete from dimo_sicoop.d_Cliente_Selfie 
where cliente_id = 34044;

delete from dimo_sicoop.d_cliente 
where cliente_id = 34044;

delete from dimo_sicoop.d_catastro 
where  catastro_id= 39298;

commit;