On a modded PAL or japanese console (with supercic or with the classic mod) it allows you to play USA games.
The same for a usa modded console and pal/jpn games.
It doesn't work on unmodified consoles.
For Canada and Australia: shipping usually takes about 4-6 weeks