[Home] [Help]
97: loc.state,
98: loc.postal_code,
99: loc.country
100: FROM hz_cust_acct_sites acct_site,
101: hz_party_sites party_site,
102: hz_locations loc,
103: hz_cust_site_uses site_uses
104: WHERE acct_site.cust_account_id =p_customer_id
105: AND nvl(acct_site.status,'A') = 'A'