22 lines
795 B
MySQL
22 lines
795 B
MySQL
--da eseguire come utente DBCGO
|
|
|
|
-------------------------------------------------------------------------
|
|
|
|
-- nuovo sistema mittente MspCoop per il processo recipient
|
|
|
|
|
|
--DBCGO_LOV - filtro SISTEMA_MITTENTE
|
|
|
|
INSERT INTO DBCGO_LOV(LOV_ID, LOV_NAME, NAME, DESCR) VALUES (SEQ_LOV.nextval, 'SIST_MITTENTE', 'MSPCOOP', 'MspCoop');
|
|
|
|
|
|
--DBCGO_LOV_REF - filtro sistema mittente
|
|
|
|
insert into DBCGO_LOV_REF(lov_id, lov_id_ref) select lov_id,lov_id from DBCGO_LOV where lov_name='SIST_MITTENTE' and name='MSPCOOP';
|
|
|
|
update DBCGO_LOV_REF set lov_id_ref = (select lov_id from DBCGO_LOV where lov_name='CUST_TYPE' and name='CO') where lov_id=(select lov_id from DBCGO_LOV where lov_name='SIST_MITTENTE' and name='MSPCOOP');
|
|
|
|
|
|
-------------------------------------------------------------------------
|
|
|
|
commit; |