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 HZ_LOCATIONS

Line 82: hz_locations loc

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'
84: AND rt.country = 'DEFAULT'
85: AND rt.address_id = acct_site.cust_acct_site_id
86: and acct_site.party_site_id = party_site.party_site_id

Line 161: hz_locations.state%type,

157:
158:
159: PROCEDURE get_remit_to_address(
160: p_match_state IN
161: hz_locations.state%type,
162: p_match_country IN
163: hz_locations.country%type,
164: p_match_postal_code IN
165: hz_locations.postal_code%type,

Line 163: hz_locations.country%type,

159: PROCEDURE get_remit_to_address(
160: p_match_state IN
161: hz_locations.state%type,
162: p_match_country IN
163: hz_locations.country%type,
164: p_match_postal_code IN
165: hz_locations.postal_code%type,
166: p_match_address_id IN
167: NUMBER,

Line 165: hz_locations.postal_code%type,

161: hz_locations.state%type,
162: p_match_country IN
163: hz_locations.country%type,
164: p_match_postal_code IN
165: hz_locations.postal_code%type,
166: p_match_address_id IN
167: NUMBER,
168: p_match_site_use_id IN
169: NUMBER,

Line 177: l_match_state hz_locations.state%type;

173: address_rec_type
174: ) IS
175:
176:
177: l_match_state hz_locations.state%type;
178: l_match_country hz_locations.country%type;
179: l_match_postal_code hz_locations.postal_code%type;
180: l_remit_to_address_rec address_rec_type;
181:

Line 178: l_match_country hz_locations.country%type;

174: ) IS
175:
176:
177: l_match_state hz_locations.state%type;
178: l_match_country hz_locations.country%type;
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

Line 179: l_match_postal_code hz_locations.postal_code%type;

175:
176:
177: l_match_state hz_locations.state%type;
178: l_match_country hz_locations.country%type;
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

Line 184: of from hz_locations */

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,
188: loc.address3, loc.address4,

Line 194: hz_locations loc,

190: loc.province, loc.postal_code,
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

Line 303: hz_locations loc

299: l_match_country,
300: l_match_postal_code
301: FROM hz_cust_acct_sites acct_site,
302: hz_party_sites party_site,
303: hz_locations loc
304: WHERE acct_site.cust_acct_site_id = p_match_address_id
305: AND acct_site.party_site_id = party_site.party_site_id
306: AND loc.location_id = party_site.location_id;
307:

Line 330: hz_locations loc,

326: l_match_country,
327: l_match_postal_code
328: FROM hz_cust_acct_sites acct_site,
329: hz_party_sites party_site,
330: hz_locations loc,
331: hz_cust_site_uses su
332: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id
333: AND su.site_use_id = p_match_site_use_id
334: AND acct_site.party_site_id = party_site.party_site_id

Line 1376: p_state IN hz_locations.state%type,

1372: | |
1373: +===========================================================================*/
1374:
1375: PROCEDURE get_remit_to_default(
1376: p_state IN hz_locations.state%type,
1377: p_postal_code IN hz_locations.postal_code%type,
1378: p_country IN hz_locations.country%type,
1379: p_address_id OUT NOCOPY NUMBER,
1380: p_address1 OUT NOCOPY hz_locations.address1%type,

Line 1377: p_postal_code IN hz_locations.postal_code%type,

1373: +===========================================================================*/
1374:
1375: PROCEDURE get_remit_to_default(
1376: p_state IN hz_locations.state%type,
1377: p_postal_code IN hz_locations.postal_code%type,
1378: p_country IN hz_locations.country%type,
1379: p_address_id OUT NOCOPY NUMBER,
1380: p_address1 OUT NOCOPY hz_locations.address1%type,
1381: p_address2 OUT NOCOPY hz_locations.address2%type,

Line 1378: p_country IN hz_locations.country%type,

1374:
1375: PROCEDURE get_remit_to_default(
1376: p_state IN hz_locations.state%type,
1377: p_postal_code IN hz_locations.postal_code%type,
1378: p_country IN hz_locations.country%type,
1379: p_address_id OUT NOCOPY NUMBER,
1380: p_address1 OUT NOCOPY hz_locations.address1%type,
1381: p_address2 OUT NOCOPY hz_locations.address2%type,
1382: p_address3 OUT NOCOPY varchar2,

Line 1380: p_address1 OUT NOCOPY hz_locations.address1%type,

1376: p_state IN hz_locations.state%type,
1377: p_postal_code IN hz_locations.postal_code%type,
1378: p_country IN hz_locations.country%type,
1379: p_address_id OUT NOCOPY NUMBER,
1380: p_address1 OUT NOCOPY hz_locations.address1%type,
1381: p_address2 OUT NOCOPY hz_locations.address2%type,
1382: p_address3 OUT NOCOPY varchar2,
1383: p_concatenated_address OUT NOCOPY varchar2
1384: ) IS

Line 1381: p_address2 OUT NOCOPY hz_locations.address2%type,

1377: p_postal_code IN hz_locations.postal_code%type,
1378: p_country IN hz_locations.country%type,
1379: p_address_id OUT NOCOPY NUMBER,
1380: p_address1 OUT NOCOPY hz_locations.address1%type,
1381: p_address2 OUT NOCOPY hz_locations.address2%type,
1382: p_address3 OUT NOCOPY varchar2,
1383: p_concatenated_address OUT NOCOPY varchar2
1384: ) IS
1385: