What is the idea that a physiological need creates a state of tension that motivates an organism to satisfy the need?

That is the theory of motivation. If the body needs water, a state of tension that is recognized as thirst is created until that need is fulfilled.