43 lines
2.2 KiB
MySQL
43 lines
2.2 KiB
MySQL
spool /mnpapp/script/MNP_RU258.log;
|
|
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','RV','Responsabile Vendite');
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','RVB','Responsabile VB');
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','CV','Coordinatore Venditori');
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','RMB','Responsabile MB');
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','TRAD','Trader');
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','PROC','Procacciatore');
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','AMM','Amministrazione');
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','OCC','Operatore CC');
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','FM','Fittizia (Medium)');
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','PRG','Progettista');
|
|
set define off;
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','FTL','Fittizia (Top&Large)');
|
|
set define on;
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','AM','Area Manager');
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','NTA','TELEACCOUNT');
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','TAC','TELEACCOUNT CROSS');
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','SHM','SOHO MOBILE');
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','SHMC','SOHO MOBILE CROSS');
|
|
INSERT INTO DBCGO_LOV (LOV_ID, LOV_NAME, NAME, DESCR)
|
|
VALUES (SEQ_LOV.NEXTVAL ,'CANALEVENDITA_BU','PAC','PARTNER ASSOCIAZIONI CROSS');
|
|
|
|
|
|
COMMIT;
|
|
|
|
spool off; |