Customer Site Information - Detailed Site Use

SELECT HZ.PARTY_ID,
       CUSTOMERACCOUNTSITEPEO.CUST_ACCOUNT_ID,
       HZ.PARTY_NAME,
       lOCATIONPEO.ADDRESS_STYLE,
       lOCATIONPEO.COUNTRY ||','|| LOCATIONPEO.ADDRESS1 ||','|| LOCATIONPEO.CITY ||','|| LOCATIONPEO.POSTAL_CODE AS LOCATION,
       CUSTOMERACCOUNTSITEPEO.STATUS AS "Account Site Status",
       CUSTOMERACCOUNTSITEPEO.BILL_TO_FLAG,
       CUSTOMERACCOUNTSITEPEO.SHIP_TO_FLAG,
       CUSTOMERACCOUNTSITEUSEPEO.SITE_USE_CODE,
       CUSTOMERACCOUNTSITEUSEPEO.PRIMARY_FLAG,
       CUSTOMERACCOUNTSITEUSEPEO.STATUS AS "Cust_Site_Use Status",
       CUSTOMERACCOUNTSITEUSEPEO.ORIG_SYSTEM_REFERENCE,
       CUSTOMERACCOUNTSITEUSEPEO.CUST_ACCT_SITE_ID,
       CUSTOMERACCOUNTSITEPEO.SET_ID
FROM fusion.HZ_PARTIES HZ,
     fusion.HZ_PARTY_SITES PartySitePEO,
     fusion.HZ_LOCATIONS LocationPEO,
     fusion.HZ_CUST_ACCT_SITES_ALL CustomerAccountSitePEO,
     fusion.HZ_CUST_SITE_USES_ALL CustomerAccountSiteUsePEO
WHERE HZ.PARTY_ID = PARTYSITEPEO.PARTY_ID
  AND PARTYSITEPEO.LOCATION_ID = LOCATIONPEO.LOCATION_ID
  AND PARTYSITEPEO.PARTY_SITE_ID = CUSTOMERACCOUNTSITEPEO.PARTY_SITE_ID
  AND CUSTOMERACCOUNTSITEPEO.CUST_ACCT_SITE_ID = CUSTOMERACCOUNTSITEUSEPEO.CUST_ACCT_SITE_ID
  AND upper(HZ.PARTY_NAME) LIKE upper('&CUSTOMER_NAME%');