612: SELECT count(hcsu.location)
613: FROM hz_cust_accounts hca,
614: hz_parties hp,
615: hz_cust_site_uses hcsu,
616: hz_cust_acct_sites hcas,
617: hz_party_sites hps
618: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
619: AND hcas.party_site_id = hps.party_site_id
620: AND hcsu.status = 'A'