Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE person ( personid, name ) AS
SELECT 'MXSDFD', 'Alice' FROM DUAL;
1 rows affected

CREATE TABLE phone ( personid, phonenum, phoneid, type, isprimary, rowstamp1 ) AS
SELECT 'MXSDFD', '012346', 1, 'A', 'N', TIMESTAMP '2020-10-13 09:00:00' FROM DUAL UNION ALL
SELECT 'MXSDFD', '555666', 3, 'C', 'N', TIMESTAMP '2020-10-13 08:30:00' FROM DUAL UNION ALL
SELECT 'MXSDFD', '987654', 2, 'B', 'Y', TIMESTAMP '2020-10-13 08:00:00' FROM DUAL;
3 rows affected

select personid,
       "1_PHONEID"   AS phoneid1,
       "1_PHONENUM"  AS phonenum1,
       "1_TYPE"      AS type1,
       "1_ISPRIMARY" AS isprimary1,
       "1_ROWSTAMP1" AS rowstamp1,
       "2_PHONEID"   AS phoneid2,
       "2_PHONENUM"  AS phonenum2,
       "2_TYPE"      AS type2,
       "2_ISPRIMARY" AS isprimary2,
       "2_ROWSTAMP1" AS rowstamp2,
       "3_PHONEID"   AS phoneid3,
       "3_PHONENUM"  AS phonenum3,
       "3_TYPE"      AS type3,
       "3_ISPRIMARY" AS isprimary3,
       "3_ROWSTAMP1" AS rowstamp3
from   (
  SELECT p.personid,
         t.phoneid,
         t.phonenum,
         t.type,
         t.isprimary,
         t.rowstamp1,
         ROW_NUMBER() OVER (
           PARTITION BY p.personid ORDER BY t.isprimary DESC, t.rowstamp1 DESC
         ) AS seqnum
  FROM   person p
         left join phone t   
         ON ( t.PERSONID = p.PERSONID )
  where  t.PERSONID = 'MXSDFD'
)
PIVOT (
  MAX( phoneid ) AS phoneid,
  MAX( phonenum ) AS phonenum,
  MAX( type ) AS type,
  MAX( isprimary ) AS isprimary,
  MAX( rowstamp1 ) AS rowstamp1
  FOR seqnum IN ( 1, 2, 3 )
)


PERSONID
PHONEID1
PHONENUM1
TYPE1
ISPRIMARY1
ROWSTAMP1
PHONEID2
PHONENUM2
TYPE2
ISPRIMARY2
ROWSTAMP2
PHONEID3
PHONENUM3
TYPE3
ISPRIMARY3
ROWSTAMP3


MXSDFD
2
987654
B
Y
13-OCT-20 08.00.00.000000000
1
012346
A
N
13-OCT-20 09.00.00.000000000
3
555666
C
N
13-OCT-20 08.30.00.000000000