DBA Data[Home] [Help]

APPS.ARP_TRX_DEFAULTS_3 dependencies on RA_REMIT_TOS

Line 79: FROM ra_remit_tos rt,

75: loc.address4, loc.city, loc.state,
76: loc.province, loc.postal_code,
77: loc.country
78: INTO pg_remit_to_address_rec
79: FROM ra_remit_tos rt,
80: hz_cust_acct_sites acct_site,
81: hz_party_sites party_site,
82: hz_locations loc
83: WHERE rt.state = 'DEFAULT'

Line 196: ra_remit_tos rt

192: FROM hz_cust_acct_sites acct_site,
193: hz_party_sites party_site,
194: hz_locations loc,
195: fnd_territories_vl territory,
196: ra_remit_tos rt
197: WHERE NVL( acct_site.status, 'A' ) = 'A'
198: AND acct_site.cust_acct_site_id = rt.address_id
199: AND acct_site.party_site_id = party_site.party_site_id
200: AND loc.location_id = party_site.location_id