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