INSERT INTO BV_W005 SELECT '01a4b7c24d37e2a96513421c351d3540',000001,GET_DATA.*,RPAD(NVL(VKEY1,' '),60,' ') || RPAD(NVL(VKEY2,' '),60,' ') || RPAD(NVL(VKEY3,' '),60,' ') || RPAD(NVL(VKEY4,' '),60,' ') || RPAD(NVL(VKEY5,' '),60,' ') || RPAD(NVL(VKEY6,' '),60,' ') || RPAD(NVL(VKEY7,' '),60,' ') || RPAD(NVL(VKEY8,' '),60,' ') || RPAD(NVL(VKEY9,' '),60,' ') || RPAD(NVL(VKEY10,' '),60,' ') || RPAD(NVL(VKEY11,' '),60,' ') || RPAD(NVL(VKEY12,' '),60,' ') || RPAD(NVL(VKEY13,' '),60,' ') || RPAD(NVL(VKEY14,' '),60,' ') || RPAD(NVL(VKEY15,' '),60,' ') FROM(SELECT MEISAI.VPERIOD,MEISAI.VKEY3 AS VKEY1,MEISAI.VKEY4 AS VKEY2,MEISAI.VKEY6 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,SUM(MEISAI.VD16) as VD16,SUM(MEISAI.VD17) as VD17,SUM(MEISAI.VD18) as VD18,SUM(MEISAI.VD19) as VD19,SUM(MEISAI.VD20) as VD20,SUM(MEISAI.VD21) as VD21,SUM(MEISAI.VD22) as VD22,SUM(MEISAI.VD23) as VD23,SUM(MEISAI.VD24) as VD24,SUM(MEISAI.VD25) as VD25,SUM(MEISAI.VD26) as VD26,SUM(MEISAI.VD27) as VD27,SUM(MEISAI.VD28) as VD28,SUM(MEISAI.VD29) as VD29,SUM(MEISAI.VD30) as VD30
FROM WVIEW0011_YYYYMM MEISAI
WHERE MEISAI.VKEY3 = '118' AND MEISAI.VKEY4 = '00625' AND MEISAI.VPERIOD BETWEEN '202501' AND '202512'
GROUP BY MEISAI.VPERIOD,MEISAI.VKEY3,MEISAI.VKEY4,MEISAI.VKEY6) GET_DATA
INSERT INTO BV_W007 SELECT '01a4b7c24d37e2a96513421c351d3540',000001,GET_DATA.*,RPAD(NVL(VKEY1,' '),60,' ') || RPAD(NVL(VKEY2,' '),60,' ') || RPAD(NVL(VKEY3,' '),60,' ') || RPAD(NVL(VKEY4,' '),60,' ') || RPAD(NVL(VKEY5,' '),60,' ') || RPAD(NVL(VKEY6,' '),60,' ') || RPAD(NVL(VKEY7,' '),60,' ') || RPAD(NVL(VKEY8,' '),60,' ') || RPAD(NVL(VKEY9,' '),60,' ') || RPAD(NVL(VKEY10,' '),60,' ') || RPAD(NVL(VKEY11,' '),60,' ') || RPAD(NVL(VKEY12,' '),60,' ') || RPAD(NVL(VKEY13,' '),60,' ') || RPAD(NVL(VKEY14,' '),60,' ') || RPAD(NVL(VKEY15,' '),60,' ') FROM( SELECT VPERIOD,VKEY1,VKEY2,VKEY3,VKEY4,VKEY5,VKEY6,VKEY7,VKEY8,VKEY9,VKEY10,VKEY11,VKEY12,VKEY13,VKEY14,VKEY15 FROM BV_W005 WHERE SSID='01a4b7c24d37e2a96513421c351d3540' 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='01a4b7c24d37e2a96513421c351d3540' AND JOBNO=000001) GET_DATA