CREATE MATERIALIZED VIEW MVW_ODS_CUSTOMER_METER_I
	BUILD IMMEDIATE
	REFRESH FORCE
	START WITH SYSDATE
	NEXT (TRUNC (SYSDATE + 1) + 2.5/24)
	WITH PRIMARY KEY
		AS
		  SELECT
			/*+ PARALLEL(48) */
			   GMD.SERIAL_NUM || TO_CHAR (GMDM.ID_MARK) || TO_CHAR (GRMP.ID_MEASURING_POINT) CODIGO,
			   GMD.SERIAL_NUM,
			   GMD.FABRICATION_DATE,
			   GMD.IND_PREPAYMENT,
			   GMD.COD_STATUS METER_STATUS,
			   GMD.UPDATE_USER,
			   GRMP.ID_MEASURING_POINT,
			   GRMP.READ_SEQUENCE,
			   TO_CHAR (GRMP.ID_MP_CENTRALIZATION) METERBOX_V10,
			   GRMP.STATUS MEASURING_POINT_STATUS,
			   GMDM.ID_MARK,
			   GMDM.ID_MODEL,
			   GMDM.ID_DEVICE_TYPE,
			   GMDA_TIPFASE.VALUE DEVICE_PHASE,
			   GAV_TIPFASE.NAME_TYPE PHASE,
			   GMDA_TIPTEN.VALUE TIP_TENSION,
			   GREATEST(
				  NVL (GMD.UPDATE_DATE, TO_DATE ('19010101', 'YYYYMMDD')),
				  NVL (GRMP.UPDATE_DATE, TO_DATE ('19010101', 'YYYYMMDD')),
				  NVL (GMDM.UPDATE_DATE, TO_DATE ('19010101', 'YYYYMMDD')),
				  NVL (GMDA_TIPFASE.UPDATE_DATE, TO_DATE ('19010101', 'YYYYMMDD')),
				  NVL (GAV_TIPFASE.UPDATE_DATE, TO_DATE ('19010101', 'YYYYMMDD')),
				  NVL (GMDA_TIPTEN.UPDATE_DATE, TO_DATE ('19010101', 'YYYYMMDD')))
				  UPDATE_DATE,
			   GRMP.ID_SECTOR_SUPPLY
			FROM GCGT_ME_DEVICE@INCMS_ODS_SRC GMD
				INNER JOIN GCGT_RE_MEASUREMENT_POINT@INCMS_ODS_SRC GRMP ON GMD.ID_DEVICE = GRMP.ID_METER
				LEFT JOIN GCGT_ME_DEVICE_MODEL@INCMS_ODS_SRC GMDM ON GMD.ID_MODEL = GMDM.ID_MODEL
				LEFT JOIN GCGT_ME_DEVICE_ATTRIBUTE@INCMS_ODS_SRC GMDA_TIPFASE ON GMD.ID_DEVICE = GMDA_TIPFASE.ID_DEVICE
					 AND GMDA_TIPFASE.COD_MASTER_ATTRIBUTE = 'ELEATTCPH'
				LEFT JOIN GCGT_ATTRIBUTE_VALUES@INCMS_ODS_SRC GAV_TIPFASE ON GMDA_TIPFASE.VALUE = GAV_TIPFASE.COD_DEVELOP
				LEFT JOIN GCGT_ME_DEVICE_ATTRIBUTE@INCMS_ODS_SRC GMDA_TIPTEN ON GMD.ID_DEVICE = GMDA_TIPTEN.ID_DEVICE
								 AND GMDA_TIPTEN.COD_MASTER_ATTRIBUTE = 'ELEATTME';


CREATE INDEX IDX_MVW_ODS_CM_I_I ON MVW_ODS_CUSTOMER_METER_I (ID_SECTOR_SUPPLY);