OLD VERSION

CREATE OR REPLACE VIEW TRANFCT_A1_NOM (MEMBER_RANK, ID, MAGNET_NAME, MAGNET_TYPE, APERTURE_NUMBER, MEASURE_DATE, SET_CURRENT, RAMP_DIRECTION, FIELD_LENGTH, TEMPERATURE, REFERENCE_RADIUS, TRANSFER_FUNCTION, LOGIN_NAME, LOGIN_DATE, NOTES, MAGNET_STATE) AS
select V."MEMBER_RANK",V."ID",V."MAGNET_NAME",V."MAGNET_TYPE",V."APERTURE_NUMBER",V."MEASURE_DATE",V."SET_CURRENT",V."RAMP_DIRECTION",V."FIELD_LENGTH",V."TEMPERATURE",V."REFERENCE_RADIUS",V."TRANSFER_FUNCTION",V."LOGIN_NAME",V."LOGIN_DATE",V."NOTES",V."MAGNET_STATE" from (
SELECT rank() over(partition by MAGNET_NAME order by measure_date desc) as member_rank, T.*
FROM F_T_FUNCTION T
WHERE
((T.MAGNET_TYPE = 1 AND T.SET_CURRENT BETWEEN 11850-1 AND 11850+1)
OR (T.MAGNET_TYPE = 2 AND T.SET_CURRENT BETWEEN 11850-1 AND 11850+1))
AND T.APERTURE_NUMBER = 1
AND T.MAGNET_STATE = 'cryomagnet'
AND T.RAMP_DIRECTION = 1
AND T.TEMPERATURE BETWEEN 1.8-0.3 AND 1.8+0.3
ORDER BY T.MAGNET_NAME, T.APERTURE_NUMBER, round(T.SET_CURRENT), member_rank
) V where member_rank = 1;

NEW VERSION

CREATE OR REPLACE VIEW TRANFCT_A1_NOM (ID, MAGNET_NAME, MAGNET_TYPE, APERTURE_NUMBER, MEASURE_DATE, SET_CURRENT, RAMP_DIRECTION, FIELD_LENGTH, TEMPERATURE, REFERENCE_RADIUS, TRANSFER_FUNCTION, LOGIN_NAME, LOGIN_DATE, NOTES, MAGNET_STATE) AS
select V."ID",V."MAGNET_NAME",V."MAGNET_TYPE",V."APERTURE_NUMBER",V."MEASURE_DATE",V."SET_CURRENT",V."RAMP_DIRECTION",V."FIELD_LENGTH",V."TEMPERATURE",V."REFERENCE_RADIUS",V."TRANSFER_FUNCTION",V."LOGIN_NAME",V."LOGIN_DATE",V."NOTES",V."MAGNET_STATE" from (
SELECT rank() over(partition by MAGNET_NAME order by measure_date desc) as member_rank, T.*
FROM F_T_FUNCTION T
WHERE
((T.MAGNET_TYPE = 1 AND T.SET_CURRENT BETWEEN 11850-1 AND 11850+1)
OR (T.MAGNET_TYPE = 2 AND T.SET_CURRENT BETWEEN 11850-1 AND 11850+1))
AND T.APERTURE_NUMBER = 1
AND T.MAGNET_STATE = 'cryomagnet'
AND T.RAMP_DIRECTION = 1
AND T.TEMPERATURE BETWEEN 1.8-0.3 AND 1.8+0.3
) V where member_rank = 1;