PCB Layout Decoupling Capacitor Distance from source to sink
Yes.

The higher the frequency you are trying to decouple, the closer the cap needs to be.  Conversely, when a cap is intended to handle low frequencies, it can further away than one that handles the high frequencies.

The further away, the more inductance is in series with the cap.  The point is to minimize the impedance at the high frequencies, so obviously series inductance is bad.  The lower the frequency, the more series inductance you can tolerate before it becomes significant to the overall impedance.