OLD VERSION

CREATE OR REPLACE VIEW TST_TRANFCT_A1_CM (MEMBER_RANK, MAGNET_NAME, MAGNET_TYPE, MAGNET_STATE, APERTURE_NUMBER, MEASURE_DATE, SET_CURRENT, RAMP_DIRECTION, FIELD_LENGTH, TEMPERATURE, REFERENCE_RADIUS, TRANSFER_FUNCTION, LOGIN_NAME, LOGIN_DATE, NOTES) AS
select S."MEMBER_RANK",S."MAGNET_NAME",S."MAGNET_TYPE",S."MAGNET_STATE",S."APERTURE_NUMBER",S."MEASURE_DATE",S."SET_CURRENT",S."RAMP_DIRECTION",S."FIELD_LENGTH",S."TEMPERATURE",S."REFERENCE_RADIUS",S."TRANSFER_FUNCTION",S."LOGIN_NAME",S."LOGIN_DATE",S."NOTES" from (
	SELECT rank() over(partition by MAGNET_NAME order by measure_date desc) as member_rank, V.* from
	(
		select * from MV_F_T_FUNCTION T
			WHERE T.APERTURE_NUMBER = 1
				AND T.MAGNET_STATE = 'cold mass'
				AND T.RAMP_DIRECTION = 0
				AND T.TEMPERATURE > 273
	) V
) S where member_rank = 1;

NEW VERSION

CREATE OR REPLACE VIEW TST_TRANFCT_A1_CM (MAGNET_NAME, MAGNET_TYPE, MAGNET_STATE, APERTURE_NUMBER, MEASURE_DATE, SET_CURRENT, RAMP_DIRECTION, FIELD_LENGTH, TEMPERATURE, REFERENCE_RADIUS, TRANSFER_FUNCTION, LOGIN_NAME, LOGIN_DATE, NOTES) AS
select S."MAGNET_NAME",S."MAGNET_TYPE",S."MAGNET_STATE",S."APERTURE_NUMBER",S."MEASURE_DATE",S."SET_CURRENT",S."RAMP_DIRECTION",S."FIELD_LENGTH",S."TEMPERATURE",S."REFERENCE_RADIUS",S."TRANSFER_FUNCTION",S."LOGIN_NAME",S."LOGIN_DATE",S."NOTES" from (
	SELECT rank() over(partition by MAGNET_NAME order by measure_date desc) as member_rank, V.* from
	(
		select * 
                        -- from MV_F_T_FUNCTION T
                        from v_f_t_function@mms_db T
			WHERE T.APERTURE_NUMBER = 1
				AND T.MAGNET_STATE = 'cold mass'
				AND T.RAMP_DIRECTION = 0
				AND T.TEMPERATURE > 273
	) V
) S where member_rank = 1;