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
INNER JOIN EX_DAY B ON B.EX_DATE = A.<!--MG_dateid-->
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