1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
|
INSERT INTO GP3U00.BTARIF
(BPRO_EAN,
BPRO_CINT,
BTAR_CENT,
BTAR_CENTB,
BTAR_CTAR,
BTAR_PV01,
BTAR_PVMO,
BTAR_DAT2,
BTAR_DAT3,
BTAR_QUTE,
BTAR_TAX1,
BTAR_TAX2,
BTAR_TVAL,
BTAR_PVA1,
BTAR_PVMA,
BTAR_CGRP,
BTAR_REGI,
BTAR_ECOT)
VALUES (
(SELECT BPXACH.BPRO_EAN, BPXACH.BPRO_CINT, BPXACH.BPXA_CENT, BPXACH.BPXA_CENT
FROM GP3U00.BPRODT, GP3U00.BPXACH
WHERE BPRODT.BPRO_CINT = BPXACH.BPRO_CINT
AND BPRODT.BPRO_EAN = BPXACH.BPRO_EAN
AND NOT EXISTS (
SELECT BTARIFSRC.BPRO_EAN, BTARIFSRC.BPRO_CINT, BTARIFSRC.BTAR_CENT, BTARIFSRC.BTAR_CENT
FROM GP3U00.BPRODT BPRODTSRC, GP3U00.BTARIF BTARIFSRC
WHERE BPRODTSRC.BPRO_EAN = BTARIFSRC.BPRO_EAN
AND BPRODTSRC.BPRO_CINT = BTARIFSRC.BPRO_CINT
AND BPRODT.BPRO_EAN = BPRODTSRC.BPRO_EAN
AND BPRODT.BPRO_CINT = BPRODTSRC.BPRO_CINT
AND BPXACH.BPXA_CENT = BTARIFSRC.BTAR_CENT
GROUP BY BPRODTSRC.BPRO_EAN, BPRODTSRC.BPRO_CINT
)
), 'T3', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'GROUP', 0, 0) |
Partager