SELECT REL.SUBJECT_ID AS PARTY_ID , ROLE.CUST_ACCOUNT_ID , ROLE.CUST_ACCT_SITE_ID FROM HZ_CUST_ACCOUNT_ROLES ROLE , HZ_ROLE_RESPONSIBILITY RESP , HZ_RELATIONSHIPS REL , HZ_CUST_ACCT_SITES SITES WHERE ROLE.STATUS = 'A' AND ROLE.ROLE_TYPE = 'CONTACT' AND ROLE.CUST_ACCT_SITE_ID IS NOT 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.END_DATE IS NULL OR REL.END_DATE > SYSDATE) AND REL.STATUS = 'A' AND REL.SUBJECT_TYPE = 'PERSON' AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND SITES.CUST_ACCT_SITE_ID = ROLE.CUST_ACCT_SITE_ID