I can see the bill raising revenue in the short run, and...

I can see the bill raising revenue in the short run, and maybe some revenue from overseas will be brought back. But there's no guarantee, and it's unclear that the money would go for new investment or anything that would stimulate jobs in the short run.