James Bond 007: Agent Under Fire/Forbidden Depths
From StrategyWiki, the video game walkthrough and strategy guide wiki
At the warehouse area, if you shoot at fire extinguishers and monitors, a CH-6 rocket launcher will appear at the exit and you can use it.