I tried the MIN thing and it wasn't doing what I wanted because there were some empty strings rather than NULLS in the data but when I changed it to MAX it worked like a champ filtering out empty strings and NULL's and leaving me with the data set I needed which I subsequently aggregate at the PO_LINE level.

Thanks for all your suggestions. I had forgotten that you can use MIN and MAX against string data in certain scenarios.