INSERT INTO BV_W005 
SELECT 
'd92bfbe438bc2dc49718cc6ab31b7f49',
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.VKEY1 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 
MVIEW0011_YYYYMM MEISAI
WHERE  
MEISAI.VPERIOD BETWEEN '201008' AND '201107'
GROUP BY 
MEISAI.VPERIOD,MEISAI.VKEY1
) GET_DATA


INSERT INTO BV_W005P 
SELECT 
'd92bfbe438bc2dc49718cc6ab31b7f49',
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 
KIKAN.PERIOD_CURR as VPERIOD,
MEISAI.VKEY1 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 
MVIEW0011_YYYYMM MEISAI, BV_W006 KIKAN
WHERE  
MEISAI.VPERIOD BETWEEN '200908' AND '201007' AND 
KIKAN.SSID='d92bfbe438bc2dc49718cc6ab31b7f49' AND 
KIKAN.JOBNO=000001 AND 
MEISAI.VPERIOD = KIKAN.PERIOD_PRE
GROUP BY 
KIKAN.PERIOD_CURR,MEISAI.VKEY1
) GET_DATA


INSERT INTO BV_W007 
SELECT 
'd92bfbe438bc2dc49718cc6ab31b7f49',
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='d92bfbe438bc2dc49718cc6ab31b7f49' 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='d92bfbe438bc2dc49718cc6ab31b7f49' AND 
JOBNO=000001
) GET_DATA