Join bw JAI_CMN_CUS_ADDRESSES and HZ_CUST_ACCOUNTS -- Oracle Apps

SELECT HCA.ACCOUNT_NUMBER,
HP.PARTY_NAME,
--HP.PARTY_NUMBER,HP.ADDRESS1 PARTY_ADDR1,HP.ADDRESS2 PARTY_ADDR2,
----HP.CITY PARTY_CITY,HP.STATE PARTY_STATE,HP.POSTAL_CODE PARTY_POSTAL,
HP.PRIMARY_PHONE_AREA_CODE STD_CODE,
HP.PRIMARY_PHONE_NUMBER PARTY_PHONE,
HCS.SITE_USE_CODE,
HCS.SITE_USE_ID LOCATION_ID,HCS.LOCATION,
HL.ADDRESS1 SITE_ADD1,
HL.ADDRESS2 SITE_ADD2,
HL.ADDRESS3 SITE_ADD3,
HL.ADDRESS4 SITE_ADD4, HL.CITY,
HL.POSTAL_CODE ,
HL.STATE SITE_STATE,
--HPS.PARTY_SITE_ID,
HPS.PARTY_SITE_NUMBER SITE_NUMBER,
--HCAS.CUST_ACCT_SITE_ID,
--HCS.CREATION_DATE SITE_CREATION_DATE
CUS.EXCISE_DUTY_REG_NO,
CUS.EXCISE_DUTY_RANGE,
CUS.EXCISE_DUTY_DIVISION,
CUS.EXCISE_DUTY_COMM,
CUS.ST_REG_NO,
CUS.CST_REG_NO,
CUS.EC_CODE,
CUS.VAT_REG_NO
FROM
HZ_CUST_ACCOUNTS HCA,
HZ_PARTIES HP,
HZ_PARTY_SITES HPS,
HZ_CUST_ACCT_SITES_ALL HCAS,
HZ_CUST_SITE_USES_ALL HCS,
HZ_LOCATIONS HL,
JAI_CMN_CUS_ADDRESSES CUS
WHERE
HCA.PARTY_ID = HP.PARTY_ID
AND HP.PARTY_ID = HPS.PARTY_ID
AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
AND HCAS.CUST_ACCT_SITE_ID = HCS.CUST_ACCT_SITE_ID
AND HPS.LOCATION_ID = HL.LOCATION_ID
AND HCA.CUST_ACCOUNT_ID = CUS.CUSTOMER_ID
AND HCS.CUST_ACCT_SITE_ID = CUS.ADDRESS_ID
--AND SITE_USE_CODE = 'BILL_TO'