Follow that pipe and see where it goes!You will need to get under the car.
Pipe maybe fine and I suggested previously that you do a leak test first with a vaccum gun.
That plastic piece you broke ,you can find in a DIY shop in the water hose section.
Remove the broken piece and just measure the outside diametre of the broken piece on all sides.
__________________

2003 BMW X5 E53 3.0D-Auto, Sportpack,full extras.
Oxford green/
Leder Dakota interior.
56, 875miles @24th October 2024
Heavily OE modded,including full facelift grill install.4.6is body kit,wheels,exhaust tips and ext.fender flares
Non OE mods.Depo "custom" Angel eye headlights.