You can use PIVOT in this case as following:

-- CREATING SAMPLE DATA
WITH FIRST_TABLE(PhoneNumberType, PhoneNumberTypeName)
AS
(
SELECT 101, 'Mobile' from dual union all
SELECT 102, 'Home' from dual union all
SELECT 103, 'Work' from dual
),
second_table (PhoneNumberType, PhoneNumber, PersonId)
AS
(
select 101, 90354351, 1001 from dual union all
select 102, 98345634, 1001 from dual union all
select 103, 92345123, 1002 from dual
)
--
-- ACTUAL QUERY STARTS FROM HERE
SELECT
    *
FROM
    (
        SELECT
            S.PERSONID,
            S.PHONENUMBER,
            F.PHONENUMBERTYPENAME
        FROM
            FIRST_TABLE F
            JOIN SECOND_TABLE S ON F.PHONENUMBERTYPE = S.PHONENUMBERTYPE
    ) PIVOT (
        MAX ( PHONENUMBER )
        FOR PHONENUMBERTYPENAME
        IN ( 'Mobile',
        'Home',
        'Work' )
    )
ORDER BY
    1

db<>fiddle demo

Cheers!!