SELECT HZ_PARTIES.PARTY_ID ID, HZ_PARTIES.PARTY_TYPE TYPE, HZ_PARTIES.PARTY_NAME VALUE FROM HZ_PARTIES HZ_PARTIES WHERE party_type in ('ORGANIZATION','PERSON')
View Text - HTML Formatted
SELECT HZ_PARTIES.PARTY_ID ID , HZ_PARTIES.PARTY_TYPE TYPE , HZ_PARTIES.PARTY_NAME VALUE FROM HZ_PARTIES HZ_PARTIES WHERE PARTY_TYPE IN ('ORGANIZATION' , 'PERSON')