Get if field has max value and display value
I think this will give you want you want:
 select project_id,
        version,
        stop,
        t_id,
        status,
        mp,
        case when rowno = 1 then 'Y' else 'N' end is_last_version
        from (
              select project_id,
                     version,
                     stop,
                     t_id,
                     status,
                     mp,
                     row_number() over (partition by projecT_id order by version desc) 
                        as rowno
              from t_proj_f t
              order by project_id)