116 lines
6.2 KiB
SQL
116 lines
6.2 KiB
SQL
-- Da eseguire come utente mnp
|
|
|
|
spool /mnpapp/log/script/dbc_delete_11052006.log;
|
|
|
|
-- Richiesta nello stato 16 OPIV_9439484
|
|
select * from mnp_storico_richiesta where id_richiesta = 'OPIV_9439484';
|
|
select * from mnp_xml_richiesta_in where id_richiesta = 'OPIV_9439484';
|
|
select * from mnp_xml_richiesta_out where id_richiesta = 'OPIV_9439484';
|
|
select * from mnp_crm_validazione_in where id_richiesta = 'OPIV_9439484';
|
|
select * from mnp_ccrm_notifica_out where id_richiesta = 'OPIV_9439484';
|
|
select * from mnp_asp_crm_cessazione_out where id_richiesta = 'OPIV_9439484';
|
|
select * from mnp_circe_out where id_richiesta = 'OPIV_9439484';
|
|
select * from mnp_mss_cessazione_in where id_richiesta = 'OPIV_9439484';
|
|
select * from mnp_dbcgo_notifica_donor_out where id_richiesta = 'OPIV_9439484';
|
|
select * from mnp_sms_l1 where id_richiesta = 'OPIV_9439484';
|
|
select * from mnp_sms_l1v where id_richiesta = 'OPIV_9439484';
|
|
select * from mnp_gestione_richiesta where id_richiesta = 'OPIV_9439484';
|
|
|
|
delete from mnp_storico_richiesta where id_richiesta = 'OPIV_9439484';
|
|
delete from mnp_xml_richiesta_in where id_richiesta = 'OPIV_9439484';
|
|
delete from mnp_xml_richiesta_out where id_richiesta = 'OPIV_9439484';
|
|
delete from mnp_crm_validazione_in where id_richiesta = 'OPIV_9439484';
|
|
delete from mnp_ccrm_notifica_out where id_richiesta = 'OPIV_9439484';
|
|
delete from mnp_asp_crm_cessazione_out where id_richiesta = 'OPIV_9439484';
|
|
delete from mnp_circe_out where id_richiesta = 'OPIV_9439484';
|
|
delete from mnp_mss_cessazione_in where id_richiesta = 'OPIV_9439484';
|
|
delete from mnp_dbcgo_notifica_donor_out where id_richiesta = 'OPIV_9439484';
|
|
delete from mnp_sms_l1 where id_richiesta = 'OPIV_9439484';
|
|
delete from mnp_sms_l1v where id_richiesta = 'OPIV_9439484';
|
|
delete from mnp_gestione_richiesta where id_richiesta = 'OPIV_9439484';
|
|
|
|
-- Richieste nello stato 4
|
|
-- OPIV_8645189
|
|
select * from mnp_storico_richiesta where id_richiesta = 'OPIV_8645189';
|
|
select * from mnp_xml_richiesta_in where id_richiesta = 'OPIV_8645189';
|
|
select * from mnp_xml_richiesta_out where id_richiesta = 'OPIV_8645189';
|
|
select * from mnp_ccrm_notifica_out where id_richiesta = 'OPIV_8645189';
|
|
select * from mnp_dbcgo_notifica_donor_out where id_richiesta = 'OPIV_8645189' ;
|
|
select * from mnp_gestione_richiesta where id_richiesta = 'OPIV_8645189';
|
|
|
|
delete from mnp_storico_richiesta where id_richiesta = 'OPIV_8645189';
|
|
delete from mnp_xml_richiesta_in where id_richiesta = 'OPIV_8645189';
|
|
delete from mnp_xml_richiesta_out where id_richiesta = 'OPIV_8645189';
|
|
delete from mnp_ccrm_notifica_out where id_richiesta = 'OPIV_8645189';
|
|
delete from mnp_dbcgo_notifica_donor_out where id_richiesta = 'OPIV_8645189' ;
|
|
delete from mnp_gestione_richiesta where id_richiesta = 'OPIV_8645189';
|
|
|
|
-- OPIV_9284923
|
|
|
|
select * from mnp_storico_richiesta where id_richiesta = 'OPIV_9284923';
|
|
select * from mnp_xml_richiesta_in where id_richiesta = 'OPIV_9284923';
|
|
select * from mnp_xml_richiesta_out where id_richiesta = 'OPIV_9284923';
|
|
select * from mnp_ccrm_notifica_out where id_richiesta = 'OPIV_9284923';
|
|
select * from mnp_dbcgo_notifica_donor_out where id_richiesta = 'OPIV_9284923';
|
|
select * from mnp_gestione_richiesta where id_richiesta = 'OPIV_9284923';
|
|
|
|
delete from mnp_storico_richiesta where id_richiesta = 'OPIV_9284923';
|
|
delete from mnp_xml_richiesta_in where id_richiesta = 'OPIV_9284923';
|
|
delete from mnp_xml_richiesta_out where id_richiesta = 'OPIV_9284923';
|
|
delete from mnp_ccrm_notifica_out where id_richiesta = 'OPIV_9284923';
|
|
delete from mnp_dbcgo_notifica_donor_out where id_richiesta = 'OPIV_9284923';
|
|
delete from mnp_gestione_richiesta where id_richiesta = 'OPIV_9284923';
|
|
|
|
|
|
|
|
-- OPIV_9308862
|
|
|
|
select * from mnp_storico_richiesta where id_richiesta = 'OPIV_9308862';
|
|
select * from mnp_xml_richiesta_in where id_richiesta = 'OPIV_9308862';
|
|
select * from mnp_xml_richiesta_out where id_richiesta = 'OPIV_9308862';
|
|
select * from mnp_ccrm_notifica_out where id_richiesta = 'OPIV_9308862';
|
|
select * from mnp_dbcgo_notifica_donor_out where id_richiesta = 'OPIV_9308862';
|
|
select * from mnp_gestione_richiesta where id_richiesta = 'OPIV_9308862';
|
|
|
|
delete from mnp_storico_richiesta where id_richiesta = 'OPIV_9308862';
|
|
delete from mnp_xml_richiesta_in where id_richiesta = 'OPIV_9308862';
|
|
delete from mnp_xml_richiesta_out where id_richiesta = 'OPIV_9308862';
|
|
delete from mnp_ccrm_notifica_out where id_richiesta = 'OPIV_9308862';
|
|
delete from mnp_dbcgo_notifica_donor_out where id_richiesta = 'OPIV_9308862';
|
|
delete from mnp_gestione_richiesta where id_richiesta = 'OPIV_9308862';
|
|
|
|
|
|
-- OPIV_9368998
|
|
select * from mnp_storico_richiesta where id_richiesta = 'OPIV_9368998';
|
|
select * from mnp_xml_richiesta_in where id_richiesta = 'OPIV_9368998';
|
|
select * from mnp_xml_richiesta_out where id_richiesta = 'OPIV_9368998';
|
|
select * from mnp_ccrm_notifica_out where id_richiesta = 'OPIV_9368998';
|
|
select * from mnp_dbcgo_notifica_donor_out where id_richiesta = 'OPIV_9368998';
|
|
select * from mnp_gestione_richiesta where id_richiesta = 'OPIV_9368998';
|
|
|
|
delete from mnp_storico_richiesta where id_richiesta = 'OPIV_9368998';
|
|
delete from mnp_xml_richiesta_in where id_richiesta = 'OPIV_9368998';
|
|
delete from mnp_xml_richiesta_out where id_richiesta = 'OPIV_9368998';
|
|
delete from mnp_ccrm_notifica_out where id_richiesta = 'OPIV_9368998';
|
|
delete from mnp_dbcgo_notifica_donor_out where id_richiesta = 'OPIV_9368998';
|
|
delete from mnp_gestione_richiesta where id_richiesta = 'OPIV_9368998';
|
|
|
|
-- OPIV_9410164
|
|
select * from mnp_storico_richiesta where id_richiesta = 'OPIV_9410164';
|
|
select * from mnp_xml_richiesta_in where id_richiesta = 'OPIV_9410164';
|
|
select * from mnp_xml_richiesta_out where id_richiesta = 'OPIV_9410164';
|
|
select * from mnp_ccrm_notifica_out where id_richiesta = 'OPIV_9410164';
|
|
select * from mnp_dbcgo_notifica_donor_out where id_richiesta = 'OPIV_9410164';
|
|
select * from mnp_gestione_richiesta where id_richiesta = 'OPIV_9410164';
|
|
|
|
delete from mnp_storico_richiesta where id_richiesta = 'OPIV_9410164';
|
|
delete from mnp_xml_richiesta_in where id_richiesta = 'OPIV_9410164';
|
|
delete from mnp_xml_richiesta_out where id_richiesta = 'OPIV_9410164';
|
|
delete from mnp_ccrm_notifica_out where id_richiesta = 'OPIV_9410164';
|
|
delete from mnp_dbcgo_notifica_donor_out where id_richiesta = 'OPIV_9410164';
|
|
delete from mnp_gestione_richiesta where id_richiesta = 'OPIV_9410164';
|
|
|
|
commit;
|
|
|
|
spool off
|