CREATE GLOBAL TEMPORARY TABLE TMP_TABLE  ON COMMIT PRESERVE ROWS AS (
  SELECT *
  FROM VIEW_1
)

SELECT * FROM TMP_TABLE

INSERT INTO TMP_TABLE (COL_1, COL_2, COL_3, COL_4, COL_5, COL_6)
VALUES ('00000000', '2445883',  '20140401', '20990331', '20160401', '20170331')