3906: FROM
3907: hz_cust_site_uses_all hcsua
3908: , hz_cust_acct_sites_all addr
3909: , hz_party_sites party_site
3910: , hz_locations loc
3911: , fnd_territories_tl terr
3912: WHERE addr.party_site_id = party_site.party_site_id
3913: AND loc.location_id = party_site.location_id
3914: AND hcsua.cust_acct_site_id = addr.cust_acct_site_id