



<!--MGREPEAT-->

DROP MATERIALIZED VIEW <!--MG_filename-->;
DROP TABLE <!--MG_filename--> PURGE;

CREATE TABLE <!--MG_filename-->
(
VPERIOD VARCHAR2(9) NOT NULL
, VKEY1 VARCHAR2(60) NOT NULL
, VKEY2 VARCHAR2(60) NOT NULL
, VKEY3 VARCHAR2(60) NOT NULL
, VKEY4 VARCHAR2(60) NOT NULL
, VKEY5 VARCHAR2(60) NOT NULL
, VKEY6 VARCHAR2(60) NOT NULL
, VKEY7 VARCHAR2(60) NOT NULL
, VKEY8 VARCHAR2(60) NOT NULL
, VKEY9 VARCHAR2(60) NOT NULL
, VKEY10 VARCHAR2(60) NOT NULL
, VKEY11 VARCHAR2(60) NOT NULL
, VKEY12 VARCHAR2(60) NOT NULL
, VKEY13 VARCHAR2(60) NOT NULL
, VKEY14 VARCHAR2(60) NOT NULL
, VKEY15 VARCHAR2(60) NOT NULL
, VKEY16 VARCHAR2(60) NOT NULL
, VKEY17 VARCHAR2(60) NOT NULL
, VKEY18 VARCHAR2(60) NOT NULL
, VKEY19 VARCHAR2(60) NOT NULL
, VKEY20 VARCHAR2(60) NOT NULL
, VKEY21 VARCHAR2(60) NOT NULL
, VKEY22 VARCHAR2(60) NOT NULL
, VKEY23 VARCHAR2(60) NOT NULL
, VKEY24 VARCHAR2(60) NOT NULL
, VKEY25 VARCHAR2(60) NOT NULL
, VKEY26 VARCHAR2(60) NOT NULL
, VKEY27 VARCHAR2(60) NOT NULL
, VKEY28 VARCHAR2(60) NOT NULL
, VKEY29 VARCHAR2(60) NOT NULL
, VKEY30 VARCHAR2(60) NOT NULL
, VKEY31 VARCHAR2(60) NOT NULL
, VKEY32 VARCHAR2(60) NOT NULL
, VKEY33 VARCHAR2(60) NOT NULL
, VKEY34 VARCHAR2(60) NOT NULL
, VKEY35 VARCHAR2(60) NOT NULL
, VKEY36 VARCHAR2(60) NOT NULL
, VKEY37 VARCHAR2(60) NOT NULL
, VKEY38 VARCHAR2(60) NOT NULL
, VKEY39 VARCHAR2(60) NOT NULL
, VKEY40 VARCHAR2(60) NOT NULL
, VKEY41 VARCHAR2(60) NOT NULL
, VKEY42 VARCHAR2(60) NOT NULL
, VKEY43 VARCHAR2(60) NOT NULL
, VKEY44 VARCHAR2(60) NOT NULL
, VKEY45 VARCHAR2(60) NOT NULL
, VKEY46 VARCHAR2(60) NOT NULL
, VKEY47 VARCHAR2(60) NOT NULL
, VKEY48 VARCHAR2(60) NOT NULL
, VKEY49 VARCHAR2(60) NOT NULL
, VKEY50 VARCHAR2(60) NOT NULL
, VKEY51 VARCHAR2(60) NOT NULL
, VKEY52 VARCHAR2(60) NOT NULL
, VKEY53 VARCHAR2(60) NOT NULL
, VKEY54 VARCHAR2(60) NOT NULL
, VKEY55 VARCHAR2(60) NOT NULL
, VKEY56 VARCHAR2(60) NOT NULL
, VKEY57 VARCHAR2(60) NOT NULL
, VKEY58 VARCHAR2(60) NOT NULL
, VKEY59 VARCHAR2(60) NOT NULL
, VKEY60 VARCHAR2(60) NOT NULL
, VD1 NUMBER
, VD2 NUMBER
, VD3 NUMBER
, VD4 NUMBER
, VD5 NUMBER
, VD6 NUMBER
, VD7 NUMBER
, VD8 NUMBER
, VD9 NUMBER
, VD10 NUMBER
, VD11 NUMBER
, VD12 NUMBER
, VD13 NUMBER
, VD14 NUMBER
, VD15 NUMBER
, VD16 NUMBER
, VD17 NUMBER
, VD18 NUMBER
, VD19 NUMBER
, VD20 NUMBER
, VD21 NUMBER
, VD22 NUMBER
, VD23 NUMBER
, VD24 NUMBER
, VD25 NUMBER
, VD26 NUMBER
, VD27 NUMBER
, VD28 NUMBER
, VD29 NUMBER
, VD30 NUMBER
, VD31 NUMBER
, VD32 NUMBER
, VD33 NUMBER
, VD34 NUMBER
, VD35 NUMBER
, VD36 NUMBER
, VD37 NUMBER
, VD38 NUMBER
, VD39 NUMBER
, VD40 NUMBER
, VD41 NUMBER
, VD42 NUMBER
, VD43 NUMBER
, VD44 NUMBER
, VD45 NUMBER
, VD46 NUMBER
, VD47 NUMBER
, VD48 NUMBER
, VD49 NUMBER
, VD50 NUMBER
, VD51 NUMBER
, VD52 NUMBER
, VD53 NUMBER
, VD54 NUMBER
, VD55 NUMBER
, VD56 NUMBER
, VD57 NUMBER
, VD58 NUMBER
, VD59 NUMBER
, VD60 NUMBER
, VKEYP NUMBER
)
NOLOGGING
;
INSERT /*+ APPEND */ INTO <!--MG_filename-->
SELECT T0.*, ROWNUM "VKEYP" FROM (SELECT
C.<!--MG_period--> "VPERIOD"
,A.VKEY1 "VKEY1"
,A.VKEY2 "VKEY2"
,A.VKEY3 "VKEY3"
,A.VKEY4 "VKEY4"
,A.VKEY5 "VKEY5"
,A.VKEY6 "VKEY6"
,A.VKEY7 "VKEY7"
,A.VKEY8 "VKEY8"
,A.VKEY9 "VKEY9"
,A.VKEY10 "VKEY10"
,A.VKEY11 "VKEY11"
,A.VKEY12 "VKEY12"
,A.VKEY13 "VKEY13"
,A.VKEY14 "VKEY14"
,A.VKEY15 "VKEY15"
,A.VKEY16 "VKEY16"
,A.VKEY17 "VKEY17"
,A.VKEY18 "VKEY18"
,A.VKEY19 "VKEY19"
,A.VKEY20 "VKEY20"
,A.VKEY21 "VKEY21"
,A.VKEY22 "VKEY22"
,A.VKEY23 "VKEY23"
,A.VKEY24 "VKEY24"
,A.VKEY25 "VKEY25"
,A.VKEY26 "VKEY26"
,A.VKEY27 "VKEY27"
,A.VKEY28 "VKEY28"
,A.VKEY29 "VKEY29"
,A.VKEY30 "VKEY30"
,A.VKEY31 "VKEY31"
,A.VKEY32 "VKEY32"
,A.VKEY33 "VKEY33"
,A.VKEY34 "VKEY34"
,A.VKEY35 "VKEY35"
,A.VKEY36 "VKEY36"
,A.VKEY37 "VKEY37"
,A.VKEY38 "VKEY38"
,A.VKEY39 "VKEY39"
,A.VKEY40 "VKEY40"
,A.VKEY41 "VKEY41"
,A.VKEY42 "VKEY42"
,A.VKEY43 "VKEY43"
,A.VKEY44 "VKEY44"
,A.VKEY45 "VKEY45"
,A.VKEY46 "VKEY46"
,A.VKEY47 "VKEY47"
,A.VKEY48 "VKEY48"
,A.VKEY49 "VKEY49"
,A.VKEY50 "VKEY50"
,A.VKEY51 "VKEY51"
,A.VKEY52 "VKEY52"
,A.VKEY53 "VKEY53"
,A.VKEY54 "VKEY54"
,A.VKEY55 "VKEY55"
,A.VKEY56 "VKEY56"
,A.VKEY57 "VKEY57"
,A.VKEY58 "VKEY58"
,A.VKEY59 "VKEY59"
,A.VKEY60 "VKEY60"
,SUM(A.VD1) "VD1"
,SUM(A.VD2) "VD2"
,SUM(A.VD3) "VD3"
,SUM(A.VD4) "VD4"
,SUM(A.VD5) "VD5"
,SUM(A.VD6) "VD6"
,SUM(A.VD7) "VD7"
,SUM(A.VD8) "VD8"
,SUM(A.VD9) "VD9"
,SUM(A.VD10) "VD10"
,SUM(A.VD11) "VD11"
,SUM(A.VD12) "VD12"
,SUM(A.VD13) "VD13"
,SUM(A.VD14) "VD14"
,SUM(A.VD15) "VD15"
,SUM(A.VD16) "VD16"
,SUM(A.VD17) "VD17"
,SUM(A.VD18) "VD18"
,SUM(A.VD19) "VD19"
,SUM(A.VD20) "VD20"
,SUM(A.VD21) "VD21"
,SUM(A.VD22) "VD22"
,SUM(A.VD23) "VD23"
,SUM(A.VD24) "VD24"
,SUM(A.VD25) "VD25"
,SUM(A.VD26) "VD26"
,SUM(A.VD27) "VD27"
,SUM(A.VD28) "VD28"
,SUM(A.VD29) "VD29"
,SUM(A.VD30) "VD30"
,SUM(A.VD31) "VD31"
,SUM(A.VD32) "VD32"
,SUM(A.VD33) "VD33"
,SUM(A.VD34) "VD34"
,SUM(A.VD35) "VD35"
,SUM(A.VD36) "VD36"
,SUM(A.VD37) "VD37"
,SUM(A.VD38) "VD38"
,SUM(A.VD39) "VD39"
,SUM(A.VD40) "VD40"
,SUM(A.VD41) "VD41"
,SUM(A.VD42) "VD42"
,SUM(A.VD43) "VD43"
,SUM(A.VD44) "VD44"
,SUM(A.VD45) "VD45"
,SUM(A.VD46) "VD46"
,SUM(A.VD47) "VD47"
,SUM(A.VD48) "VD48"
,SUM(A.VD49) "VD49"
,SUM(A.VD50) "VD50"
,SUM(A.VD51) "VD51"
,SUM(A.VD52) "VD52"
,SUM(A.VD53) "VD53"
,SUM(A.VD54) "VD54"
,SUM(A.VD55) "VD55"
,SUM(A.VD56) "VD56"
,SUM(A.VD57) "VD57"
,SUM(A.VD58) "VD58"
,SUM(A.VD59) "VD59"
,SUM(A.VD60) "VD60"
FROM <!--MG_from--> A
INNER JOIN EX_PERIOD B ON B.EX_PERIOD_ID='<!--MG_dateid-->' AND B.EX_PERIOD = A.VPERIOD
INNER JOIN EX_DAY C ON B.EX_START = C.EX_DATE
GROUP BY
C.<!--MG_period-->
,A.VKEY1
,A.VKEY2
,A.VKEY3
,A.VKEY4
,A.VKEY5
,A.VKEY6
,A.VKEY7
,A.VKEY8
,A.VKEY9
,A.VKEY10
,A.VKEY11
,A.VKEY12
,A.VKEY13
,A.VKEY14
,A.VKEY15
,A.VKEY16
,A.VKEY17
,A.VKEY18
,A.VKEY19
,A.VKEY20
,A.VKEY21
,A.VKEY22
,A.VKEY23
,A.VKEY24
,A.VKEY25
,A.VKEY26
,A.VKEY27
,A.VKEY28
,A.VKEY29
,A.VKEY30
,A.VKEY31
,A.VKEY32
,A.VKEY33
,A.VKEY34
,A.VKEY35
,A.VKEY36
,A.VKEY37
,A.VKEY38
,A.VKEY39
,A.VKEY40
,A.VKEY41
,A.VKEY42
,A.VKEY43
,A.VKEY44
,A.VKEY45
,A.VKEY46
,A.VKEY47
,A.VKEY48
,A.VKEY49
,A.VKEY50
,A.VKEY51
,A.VKEY52
,A.VKEY53
,A.VKEY54
,A.VKEY55
,A.VKEY56
,A.VKEY57
,A.VKEY58
,A.VKEY59
,A.VKEY60
) T0;
ALTER TABLE <!--MG_filename--> ADD PRIMARY KEY
(
VKEYP
)
NOLOGGING
;

<!--MGREPEAT-->

CREATE INDEX IDX_<!--MG_filename2-->_<!--MG_keyno-->
ON <!--MG_filename2-->
(
VPERIOD
,VKEY<!--MG_keyno-->
)
NOLOGGING
;
<!--MGENDREPEAT-->

COMMIT;

<!--MGENDREPEAT-->

EXIT