eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_TRX_DEFAULTS_3 dependencies on FND_TERRITORIES_VL

Line 183: the Remit_to Country will be picked Up from fnd_territories_vl instead

179: l_match_postal_code hz_locations.postal_code%type;
180: l_remit_to_address_rec address_rec_type;
181:
182: /* BugFix:2107873 Modified the Following SELECT statement so that
183: the Remit_to Country will be picked Up from fnd_territories_vl instead
184: of from hz_locations */
185: CURSOR remit_to IS
186: SELECT acct_site.cust_acct_site_id,
187: loc.address1, loc.address2,

Line 195: fnd_territories_vl territory,

191: territory.territory_short_name --loc.country
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