SELECT PARTY_ID , PARTY_NAME , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , PROVINCE , STATE , POSTAL_CODE , COUNTY , COUNTRY , STATUS , PERSON_LAST_NAME , PERSON_FIRST_NAME , PERSON_MIDDLE_NAME , PERSON_PRE_NAME_ADJUNCT , NULL , NULL , NULL FROM HZ_PARTIES WHERE PARTY_TYPE='PERSON' AND STATUS IN ('A' , 'I')