I saw the movie on tv more than 15 years ago.
In the middle there are some guys (maybe a girl with them?) lost in the desert. At one point one of the guys thinks he saw water and runs towards it ripping of clothes while the others watch him with a “tired of your stupidity look”.
I don’t remember what happens next but at the end they open a cafe or restaurant named after something in their adventure and a camel.
Ishtar, I think.
That sounds exactly like
In the Army Now
https://www.imdb.com/title/tt0110123/
All the scenes you mentioned fit perfectly, and at the end they open a stereo store called Sahara Stereo with a camel logo.