[Home] [Help]
577: SELECT rt.address_id
578: FROM hz_cust_acct_sites acct_site,
579: hz_party_sites party_site,
580: hz_locations loc,
581: ra_remit_tos rt
582: WHERE acct_site.cust_acct_site_id = rt.address_id
583: AND acct_site.party_site_id = party_site.party_site_id
584: AND loc.location_id = party_site.location_id
585: AND nvl(rt.status,'A') = 'A'