I think the problem is within the where "PARTY_PARTY_TYPE"=02 statement.
It should be "PARTY_PARTY_TYPE"=2 if the field is in number format, or "PARTY_PARTY_TYPE='02' if the field is a text (like varchar) field.
Try running the query from another query tool than Qv, just to be sure that Qv is messing something up. For a oracle db i would recommend SQL Developer (can be downloaded for free from oracles homepage). It's a wonderfull tool when working against an Oracle db.
Finally, i would but the where clause inside the select statement instead, but thats just me.