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"
,NVL(C.EX_VALUE,' ') "VKEY16"
,NVL(D.EX_VALUE,' ') "VKEY17"
,NVL(E.EX_VALUE,' ') "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-->
LEFT OUTER JOIN EX_HENKAN C ON C.EX_KUBUN = '•”' AND C.EX_KEY = A.KEY3
LEFT OUTER JOIN EX_HENKAN D ON D.EX_KUBUN = '‰Û' AND D.EX_KEY = A.KEY3
LEFT OUTER JOIN EX_HENKAN E ON E.EX_KUBUN = '’S“–ŽÒ' AND E.EX_KEY = A.KEY4
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
,C.EX_VALUE
,D.EX_VALUE
,E.EX_VALUE
,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