Oracle AR Remit to address query

1SELECT terr.territory_short_name country,
2         hr.name                 operating_unit,
3         loc.address1,
4         acctsites.cust_acct_site_id,
5         acctsites.party_site_id,
6         acctsites.org_id        org_id,
7         loc.country             country_code,
8         loc.location_id,
9         hz_format_pub.format_address (loc.location_id,
10                                       NULL,
11                                       NULL,
12                                       ',',
13                                       NULL,
14                                       NULL,
15                                       NULL,
16                                       NULL)
17            formatted_address
18    FROM hz_party_sites   sites,
19         hz_cust_acct_sites_all acctsites,
20         hz_locations     loc,
21         hr_operating_units hr,
22         fnd_territories_vl terr
23   WHERE     sites.party_id = -1
24         AND acctsites.cust_account_id = -1
25         AND sites.party_site_id = acctsites.party_site_id
26         AND sites.location_id = loc.location_id
27         AND hr.organization_id = acctsites.org_id
28         AND terr.territory_code = loc.country
29         AND acctsites.status = 'A'
30ORDER BY country, operating_unit