INSERT INTO BV_W005 
SELECT 
'1bfbf570993cd7f912e546571ba9a22a',
000001,
GET_DATA.*,
RPAD(NVL(VKEY1,' '),30,' ') || RPAD(NVL(VKEY2,' '),30,' ') || RPAD(NVL(VKEY3,' '),30,' ') || RPAD(NVL(VKEY4,' '),30,' ') || RPAD(NVL(VKEY5,' '),30,' ') || RPAD(NVL(VKEY6,' '),30,' ') || RPAD(NVL(VKEY7,' '),30,' ') || RPAD(NVL(VKEY8,' '),30,' ') || RPAD(NVL(VKEY9,' '),30,' ') || RPAD(NVL(VKEY10,' '),30,' ') || RPAD(NVL(VKEY11,' '),30,' ') || RPAD(NVL(VKEY12,' '),30,' ') || RPAD(NVL(VKEY13,' '),30,' ') || RPAD(NVL(VKEY14,' '),30,' ') || RPAD(NVL(VKEY15,' '),30,' ') 
FROM
(
SELECT 
MEISAI.VPERIOD,
MEISAI.VKEY3 AS VKEY1,
MEISAI.VKEY7 AS VKEY2,
' ' AS VKEY3,
' ' AS VKEY4,
' ' AS VKEY5,
' ' AS VKEY6,
' ' AS VKEY7,
' ' AS VKEY8,
' ' AS VKEY9,
' ' AS VKEY10,
' ' AS VKEY11,
' ' AS VKEY12,
' ' AS VKEY13,
' ' AS VKEY14,
' ' AS VKEY15,
SUM(MEISAI.VD1) as VD1,
SUM(MEISAI.VD2) as VD2,
SUM(MEISAI.VD3) as VD3,
SUM(MEISAI.VD4) as VD4,
SUM(MEISAI.VD5) as VD5,
SUM(MEISAI.VD6) as VD6,
SUM(MEISAI.VD7) as VD7,
SUM(MEISAI.VD8) as VD8,
SUM(MEISAI.VD9) as VD9,
SUM(MEISAI.VD10) as VD10,
SUM(MEISAI.VD11) as VD11,
SUM(MEISAI.VD12) as VD12,
SUM(MEISAI.VD13) as VD13,
SUM(MEISAI.VD14) as VD14,
SUM(MEISAI.VD15) as VD15

FROM 
MVIEW0011_YYYYMM MEISAI
WHERE  
MEISAI.VPERIOD BETWEEN '201008' AND '201107'
GROUP BY 
MEISAI.VPERIOD,MEISAI.VKEY3,MEISAI.VKEY7
) GET_DATA