Code:
Select PO.* 
from INVOICE I, PO, ACTIVITY A 
where I.ponumber        =    PO.ponumber       AND
      I.activitynumber  =    A.code            AND
      A.code            =    'ALL'
;
Is this you want?

Abhay.