SELECT CSU.SITE_USE_ID SITE_USE_ID , AD.ADDRESS CONTACT_ADDRESS FROM HZ_CUST_SITE_USES_ALL CSU , HZ_CUST_ACCT_SITES_ALL CAS , HZ_PARTY_SITES PAS , BIC_ADDRESS_V AD WHERE CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID AND CAS.PARTY_SITE_ID = PAS.PARTY_SITE_ID AND PAS.LOCATION_ID = AD.LOCATION_ID WITH READ ONLY