DROP MATERIALIZED VIEW LOG ON <!--MG_from0--> ;
DROP MATERIALIZED VIEW LOG ON EX_DAY ;

<!--MGREPEAT-->

DROP MATERIALIZED VIEW <!--MG_filename-->;
DROP TABLE <!--MG_filename--> PURGE;

CREATE TABLE <!--MG_filename--> 
NOLOGGING 
AS
SELECT 
B.<!--MG_period--> "VPERIOD",
A.KEY1 "VKEY1" ,
A.KEY2 "VKEY2" ,
A.KEY3 "VKEY3" ,
A.KEY4 "VKEY4" ,
A.KEY5 "VKEY5" ,
A.KEY6 "VKEY6" ,
A.KEY7 "VKEY7" ,
A.KEY8 "VKEY8" ,
A.KEY9 "VKEY9" ,
A.KEY10 "VKEY10" ,
A.KEY11 "VKEY11" ,
A.KEY12 "VKEY12" ,
A.KEY13 "VKEY13" ,
A.KEY14 "VKEY14" ,
A.KEY15 "VKEY15" ,
A.KEY16 "VKEY16" ,
A.KEY17 "VKEY17" ,
A.KEY18 "VKEY18" ,
A.KEY19 "VKEY19" ,
A.KEY20 "VKEY20" ,
A.KEY21 "VKEY21" ,
A.KEY22 "VKEY22" ,
A.KEY23 "VKEY23" ,
A.KEY24 "VKEY24" ,
A.KEY25 "VKEY25" ,
A.KEY26 "VKEY26" ,
A.KEY27 "VKEY27" ,
A.KEY28 "VKEY28" ,
A.KEY29 "VKEY29" ,
A.KEY30 "VKEY30",
SUM(A.D1) "VD1" ,
SUM(A.D2) "VD2" ,
SUM(A.D3) "VD3" ,
SUM(A.D4) "VD4" ,
SUM(A.D5) "VD5" ,
SUM(A.D6) "VD6" ,
SUM(A.D7) "VD7" ,
SUM(A.D8) "VD8" ,
SUM(A.D9) "VD9" ,
SUM(A.D10) "VD10" ,
SUM(A.D11) "VD11" ,
SUM(A.D12) "VD12" ,
SUM(A.D13) "VD13" ,
SUM(A.D14) "VD14" ,
SUM(A.D15) "VD15" ,
SUM(A.D16) "VD16" ,
SUM(A.D17) "VD17" ,
SUM(A.D18) "VD18" ,
SUM(A.D19) "VD19" ,
SUM(A.D20) "VD20" ,
SUM(A.D21) "VD21" ,
SUM(A.D22) "VD22" ,
SUM(A.D23) "VD23" ,
SUM(A.D24) "VD24" ,
SUM(A.D25) "VD25" ,
SUM(A.D26) "VD26" ,
SUM(A.D27) "VD27" ,
SUM(A.D28) "VD28" ,
SUM(A.D29) "VD29" ,
SUM(A.D30) "VD30" 
FROM 
<!--MG_from--> A, 
EX_DAY B
WHERE 
A.<!--MG_dateid--> = B.EX_DATE
GROUP BY 
B.<!--MG_period--> ,
A.KEY1 ,
A.KEY2 ,
A.KEY3 ,
A.KEY4 ,
A.KEY5 ,
A.KEY6 ,
A.KEY7 ,
A.KEY8 ,
A.KEY9 ,
A.KEY10 ,
A.KEY11 ,
A.KEY12 ,
A.KEY13 ,
A.KEY14 ,
A.KEY15 ,
A.KEY16 ,
A.KEY17 ,
A.KEY18 ,
A.KEY19 ,
A.KEY20 ,
A.KEY21 ,
A.KEY22 ,
A.KEY23 ,
A.KEY24 ,
A.KEY25 ,
A.KEY26 ,
A.KEY27 ,
A.KEY28 ,
A.KEY29 ,
A.KEY30 
;

ALTER TABLE <!--MG_filename--> ADD PRIMARY KEY 
(
VPERIOD, 
VKEY1, 
VKEY2, 
VKEY3, 
VKEY4, 
VKEY5, 
VKEY6, 
VKEY7, 
VKEY8, 
VKEY9, 
VKEY10, 
VKEY11, 
VKEY12, 
VKEY13, 
VKEY14, 
VKEY15, 
VKEY16, 
VKEY17, 
VKEY18, 
VKEY19, 
VKEY20, 
VKEY21, 
VKEY22, 
VKEY23, 
VKEY24, 
VKEY25, 
VKEY26, 
VKEY27, 
VKEY28, 
VKEY29, 
VKEY30
)
NOLOGGING
;

<!--MGREPEAT-->
CREATE INDEX IDX_<!--MG_filename2-->_<!--MG_keyno--> 
ON <!--MG_filename2--> 
(
VPERIOD, 
VKEY<!--MG_keyno-->
) 
NOLOGGING
;
<!--MGENDREPEAT-->

COMMIT;

<!--MGENDREPEAT-->

EXIT