INSERT INTO BV_W005 SELECT 'c15a40a805b53a2bf37bc90cd8cbaa5e',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.VKEY4 AS VKEY1,' ' 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 V_A0101M MEISAI
WHERE  MEISAI.VPERIOD BETWEEN '200908' AND '201007'
GROUP BY MEISAI.VPERIOD,MEISAI.VKEY4) GET_DATA










INSERT INTO BV_W007 SELECT 'c15a40a805b53a2bf37bc90cd8cbaa5e',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 VPERIOD,VKEY1,VKEY2,VKEY3,VKEY4,VKEY5,VKEY6,VKEY7,VKEY8,VKEY9,VKEY10,VKEY11,VKEY12,VKEY13,VKEY14,VKEY15 FROM BV_W005 WHERE SSID='c15a40a805b53a2bf37bc90cd8cbaa5e' AND JOBNO=000001 UNION SELECT VPERIOD,VKEY1,VKEY2,VKEY3,VKEY4,VKEY5,VKEY6,VKEY7,VKEY8,VKEY9,VKEY10,VKEY11,VKEY12,VKEY13,VKEY14,VKEY15 FROM BV_W005P WHERE SSID='c15a40a805b53a2bf37bc90cd8cbaa5e' AND JOBNO=000001) GET_DATA