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.

[Home] [Help]

APPS.HZ_MATCH_RULE_51 dependencies on HZ_LOCATIONS

Line 375: SELECT HZ_LOCATIONS.CITY

371: RETURN l_matched_value;
372: END IF;
373: IF p_attribute = 'CITY' THEN
374: BEGIN
375: SELECT HZ_LOCATIONS.CITY
376: INTO l_matched_value
377: FROM HZ_PARTY_SITES, HZ_LOCATIONS
378: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
379: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 377: FROM HZ_PARTY_SITES, HZ_LOCATIONS

373: IF p_attribute = 'CITY' THEN
374: BEGIN
375: SELECT HZ_LOCATIONS.CITY
376: INTO l_matched_value
377: FROM HZ_PARTY_SITES, HZ_LOCATIONS
378: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
379: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
380: EXCEPTION
381: WHEN NO_DATA_FOUND THEN

Line 379: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

375: SELECT HZ_LOCATIONS.CITY
376: INTO l_matched_value
377: FROM HZ_PARTY_SITES, HZ_LOCATIONS
378: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
379: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
380: EXCEPTION
381: WHEN NO_DATA_FOUND THEN
382: l_matched_value := 'Err';
383: END;

Line 388: SELECT HZ_LOCATIONS.STATE

384: RETURN l_matched_value;
385: END IF;
386: IF p_attribute = 'STATE' THEN
387: BEGIN
388: SELECT HZ_LOCATIONS.STATE
389: INTO l_matched_value
390: FROM HZ_PARTY_SITES, HZ_LOCATIONS
391: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
392: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 390: FROM HZ_PARTY_SITES, HZ_LOCATIONS

386: IF p_attribute = 'STATE' THEN
387: BEGIN
388: SELECT HZ_LOCATIONS.STATE
389: INTO l_matched_value
390: FROM HZ_PARTY_SITES, HZ_LOCATIONS
391: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
392: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
393: EXCEPTION
394: WHEN NO_DATA_FOUND THEN

Line 392: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

388: SELECT HZ_LOCATIONS.STATE
389: INTO l_matched_value
390: FROM HZ_PARTY_SITES, HZ_LOCATIONS
391: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
392: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
393: EXCEPTION
394: WHEN NO_DATA_FOUND THEN
395: l_matched_value := 'Err';
396: END;

Line 401: SELECT HZ_LOCATIONS.COUNTRY

397: RETURN l_matched_value;
398: END IF;
399: IF p_attribute = 'COUNTRY' THEN
400: BEGIN
401: SELECT HZ_LOCATIONS.COUNTRY
402: INTO l_matched_value
403: FROM HZ_PARTY_SITES, HZ_LOCATIONS
404: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
405: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 403: FROM HZ_PARTY_SITES, HZ_LOCATIONS

399: IF p_attribute = 'COUNTRY' THEN
400: BEGIN
401: SELECT HZ_LOCATIONS.COUNTRY
402: INTO l_matched_value
403: FROM HZ_PARTY_SITES, HZ_LOCATIONS
404: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
405: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
406: EXCEPTION
407: WHEN NO_DATA_FOUND THEN

Line 405: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

401: SELECT HZ_LOCATIONS.COUNTRY
402: INTO l_matched_value
403: FROM HZ_PARTY_SITES, HZ_LOCATIONS
404: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
405: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
406: EXCEPTION
407: WHEN NO_DATA_FOUND THEN
408: l_matched_value := 'Err';
409: END;

Line 4386: ,translate(HZ_LOCATIONS.CITY, '%',' ')

4382: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
4383: ) IS
4384: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
4385: SELECT party_site_id
4386: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4387: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4388: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4389: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4390: FROM HZ_PARTY_SITES, HZ_LOCATIONS

Line 4387: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')

4383: ) IS
4384: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
4385: SELECT party_site_id
4386: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4387: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4388: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4389: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4390: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4391: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

Line 4388: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')

4384: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
4385: SELECT party_site_id
4386: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4387: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4388: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4389: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4390: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4391: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
4392: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

Line 4389: ,translate(HZ_LOCATIONS.STATE, '%',' ')

4385: SELECT party_site_id
4386: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4387: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4388: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4389: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4390: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4391: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
4392: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
4393:

Line 4390: FROM HZ_PARTY_SITES, HZ_LOCATIONS

4386: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4387: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4388: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4389: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4390: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4391: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
4392: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
4393:
4394: I NUMBER;

Line 4392: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

4388: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4389: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4390: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4391: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
4392: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
4393:
4394: I NUMBER;
4395: J NUMBER:=1;
4396: l_party_site_id NUMBER;