-- eseguire come utente DBCGO
-- anagrafica operatori DBCGO

INSERT INTO DBCGO_ANAGRAFICA_OPERATORI ( ID_OPERATORE, TIPO_OPERATORE, GESTORE_AOM,
ID_AMMINISTRATIVO, INIZIALE_ID_AMM, DESCRIZIONE ) VALUES ( 
'BLAD', 'VIRT', 'OPIV', 'O109', 'O', 'Bladna mobile'); 
-- aom virtuali donor e recipient

INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
VALUES (SEQ_LOV.nextval,'AOM_DONOR','BLAD','Bladna mobile',null);
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY) 
VALUES (SEQ_LOV.nextval,'AOM_RECIPIENT','BLAD','Bladna mobile',null);
-- aom donor e recipient per sla

INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
VALUES (SEQ_LOV.NEXTVAL,'AOM_DONOR_SLA','BLAD','Bladna mobile',null);
INSERT INTO DBCGO_LOV (LOV_ID,LOV_NAME,NAME,DESCR,ORDER_BY)
VALUES (SEQ_LOV.NEXTVAL,'AOM_RECIPIENT_SLA','BLAD','Bladna mobile',null);
COMMIT;