DBA Data[Home] [Help]

APPS.AR_INVOICE_SQL_FUNC_PUB dependencies on RA_REMIT_TOS

Line 581: ra_remit_tos rt

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'