[CX] Resolution order of implicit field access

The resolution order should be closest to furthest.
 
select * from orders           
where pid in (select value pid from parts);     
means
 
select * from orders o         
where o.pid in (select value p.pid from parts p);