Customer Details with site numbers and location -- Oracle Apps

SELECT HCA.ACCOUNT_NUMBER,
HP.PARTY_NAME,HP.PARTY_NUMBER,
HP.ADDRESS1 PARTY_ADD1,HP.ADDRESS2 PARTY_ADD1,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,
HL.ADDRESS1 SITE_ADD1, HL.ADDRESS2 SITE_ADD2, HL.ADDRESS3 SITE_ADD1, HL.ADDRESS4 SITE_ADD4, HL.CITY, HL.POSTAL_CODE SITE_CODE, HL.STATE SITE_STATE,
HPS.PARTY_SITE_ID,HPS.PARTY_SITE_NUMBER SITE_NUMBER,
HCAS.CUST_ACCT_SITE_ID,
HCS.SITE_USE_ID LOCATION_ID,HCS.SITE_USE_CODE,HCS.LOCATION,HCS.CREATION_DATE SITE_CREATION_DATE
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
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 SITE_USE_CODE = 'BILL_TO'
AND HCA.ACCOUNT_NUMBER = 'AA01132'