When joining an OPENQUERY, you do not need to include the OPENQUERY in a sub query, try this:

select

[ApEmail]

,[FirstName]

,[LastName]

,[UEmail]

,[PEmail]

,[SCode]

,r.AY, r.JN, r.APID, r.APUNAME, r.EMAIL,...