SELECT DISTINCT PARTY.PARTY_ID , ACCTS.CUST_ACCOUNT_ID FROM HZ_PARTIES PARTY , HZ_CUST_ACCOUNTS ACCTS WHERE PARTY.PARTY_ID = ACCTS.PARTY_ID AND ACCTS.STATUS = 'A' AND PARTY.PARTY_TYPE = 'PERSON' AND PARTY.STATUS = 'A' UNION SELECT DISTINCT REL.SUBJECT_ID AS PARTY_ID , ROLE.CUST_ACCOUNT_ID FROM HZ_CUST_ACCOUNT_ROLES ROLE , HZ_ROLE_RESPONSIBILITY RESP , HZ_RELATIONSHIPS REL WHERE ROLE.CURRENT_ROLE_STATE = 'A' AND ROLE.ROLE_TYPE = 'CONTACT' AND ROLE.CUST_ACCT_SITE_ID IS NULL AND (ROLE.END_DATE IS NULL OR ROLE.END_DATE > SYSDATE) AND RESP.CUST_ACCOUNT_ROLE_ID = ROLE.CUST_ACCOUNT_ROLE_ID AND RESP.RESPONSIBILITY_TYPE = 'SELF_SERVICE_USER' AND REL.PARTY_ID = ROLE.PARTY_ID AND REL.SUBJECT_TYPE = 'PERSON' AND (REL.END_DATE IS NULL OR REL.END_DATE > SYSDATE) AND REL.STATUS = 'A' AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'