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_8 dependencies on HZ_LOCATIONS

Line 416: SELECT HZ_LOCATIONS.CITY

412: RETURN l_matched_value;
413: END IF;
414: IF p_attribute = 'CITY' THEN
415: BEGIN
416: SELECT HZ_LOCATIONS.CITY
417: INTO l_matched_value
418: FROM HZ_PARTY_SITES, HZ_LOCATIONS
419: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
420: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 418: FROM HZ_PARTY_SITES, HZ_LOCATIONS

414: IF p_attribute = 'CITY' THEN
415: BEGIN
416: SELECT HZ_LOCATIONS.CITY
417: INTO l_matched_value
418: FROM HZ_PARTY_SITES, HZ_LOCATIONS
419: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
420: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
421: EXCEPTION
422: WHEN NO_DATA_FOUND THEN

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

416: SELECT HZ_LOCATIONS.CITY
417: INTO l_matched_value
418: FROM HZ_PARTY_SITES, HZ_LOCATIONS
419: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
420: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
421: EXCEPTION
422: WHEN NO_DATA_FOUND THEN
423: l_matched_value := 'Err';
424: END;

Line 429: SELECT HZ_LOCATIONS.POSTAL_CODE

425: RETURN l_matched_value;
426: END IF;
427: IF p_attribute = 'POSTAL_CODE' THEN
428: BEGIN
429: SELECT HZ_LOCATIONS.POSTAL_CODE
430: INTO l_matched_value
431: FROM HZ_PARTY_SITES, HZ_LOCATIONS
432: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
433: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 431: FROM HZ_PARTY_SITES, HZ_LOCATIONS

427: IF p_attribute = 'POSTAL_CODE' THEN
428: BEGIN
429: SELECT HZ_LOCATIONS.POSTAL_CODE
430: INTO l_matched_value
431: FROM HZ_PARTY_SITES, HZ_LOCATIONS
432: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
433: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
434: EXCEPTION
435: WHEN NO_DATA_FOUND THEN

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

429: SELECT HZ_LOCATIONS.POSTAL_CODE
430: INTO l_matched_value
431: FROM HZ_PARTY_SITES, HZ_LOCATIONS
432: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
433: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
434: EXCEPTION
435: WHEN NO_DATA_FOUND THEN
436: l_matched_value := 'Err';
437: END;

Line 442: SELECT HZ_LOCATIONS.STATE

438: RETURN l_matched_value;
439: END IF;
440: IF p_attribute = 'STATE' THEN
441: BEGIN
442: SELECT HZ_LOCATIONS.STATE
443: INTO l_matched_value
444: FROM HZ_PARTY_SITES, HZ_LOCATIONS
445: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
446: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 444: FROM HZ_PARTY_SITES, HZ_LOCATIONS

440: IF p_attribute = 'STATE' THEN
441: BEGIN
442: SELECT HZ_LOCATIONS.STATE
443: INTO l_matched_value
444: FROM HZ_PARTY_SITES, HZ_LOCATIONS
445: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
446: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
447: EXCEPTION
448: WHEN NO_DATA_FOUND THEN

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

442: SELECT HZ_LOCATIONS.STATE
443: INTO l_matched_value
444: FROM HZ_PARTY_SITES, HZ_LOCATIONS
445: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
446: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
447: EXCEPTION
448: WHEN NO_DATA_FOUND THEN
449: l_matched_value := 'Err';
450: END;

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

6154: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
6155: ) IS
6156: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6157: SELECT party_site_id
6158: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6159: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6160: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6161: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6162: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

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

6155: ) IS
6156: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6157: SELECT party_site_id
6158: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6159: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6160: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6161: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6162: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6163: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

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

6156: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6157: SELECT party_site_id
6158: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6159: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6160: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6161: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6162: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6163: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6164:

Line 6161: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6157: SELECT party_site_id
6158: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6159: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6160: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6161: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6162: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6163: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6164:
6165: I NUMBER;

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

6159: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6160: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6161: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6162: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6163: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6164:
6165: I NUMBER;
6166: J NUMBER:=1;
6167: l_party_site_id NUMBER;