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.HZ_MATCH_RULE_48 dependencies on HZ_LOCATIONS

Line 422: SELECT HZ_LOCATIONS.CITY

418: RETURN l_matched_value;
419: END IF;
420: IF p_attribute = 'CITY' THEN
421: BEGIN
422: SELECT HZ_LOCATIONS.CITY
423: INTO l_matched_value
424: FROM HZ_PARTY_SITES, HZ_LOCATIONS
425: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
426: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 424: FROM HZ_PARTY_SITES, HZ_LOCATIONS

420: IF p_attribute = 'CITY' THEN
421: BEGIN
422: SELECT HZ_LOCATIONS.CITY
423: INTO l_matched_value
424: FROM HZ_PARTY_SITES, HZ_LOCATIONS
425: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
426: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
427: EXCEPTION
428: WHEN NO_DATA_FOUND THEN

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

422: SELECT HZ_LOCATIONS.CITY
423: INTO l_matched_value
424: FROM HZ_PARTY_SITES, HZ_LOCATIONS
425: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
426: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
427: EXCEPTION
428: WHEN NO_DATA_FOUND THEN
429: l_matched_value := 'Err';
430: END;

Line 435: SELECT HZ_LOCATIONS.STATE

431: RETURN l_matched_value;
432: END IF;
433: IF p_attribute = 'STATE' THEN
434: BEGIN
435: SELECT HZ_LOCATIONS.STATE
436: INTO l_matched_value
437: FROM HZ_PARTY_SITES, HZ_LOCATIONS
438: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
439: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 437: FROM HZ_PARTY_SITES, HZ_LOCATIONS

433: IF p_attribute = 'STATE' THEN
434: BEGIN
435: SELECT HZ_LOCATIONS.STATE
436: INTO l_matched_value
437: FROM HZ_PARTY_SITES, HZ_LOCATIONS
438: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
439: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
440: EXCEPTION
441: WHEN NO_DATA_FOUND THEN

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

435: SELECT HZ_LOCATIONS.STATE
436: INTO l_matched_value
437: FROM HZ_PARTY_SITES, HZ_LOCATIONS
438: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
439: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
440: EXCEPTION
441: WHEN NO_DATA_FOUND THEN
442: l_matched_value := 'Err';
443: END;

Line 448: SELECT HZ_LOCATIONS.COUNTRY

444: RETURN l_matched_value;
445: END IF;
446: IF p_attribute = 'COUNTRY' THEN
447: BEGIN
448: SELECT HZ_LOCATIONS.COUNTRY
449: INTO l_matched_value
450: FROM HZ_PARTY_SITES, HZ_LOCATIONS
451: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
452: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 450: FROM HZ_PARTY_SITES, HZ_LOCATIONS

446: IF p_attribute = 'COUNTRY' THEN
447: BEGIN
448: SELECT HZ_LOCATIONS.COUNTRY
449: INTO l_matched_value
450: FROM HZ_PARTY_SITES, HZ_LOCATIONS
451: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
452: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
453: EXCEPTION
454: WHEN NO_DATA_FOUND THEN

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

448: SELECT HZ_LOCATIONS.COUNTRY
449: INTO l_matched_value
450: FROM HZ_PARTY_SITES, HZ_LOCATIONS
451: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
452: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
453: EXCEPTION
454: WHEN NO_DATA_FOUND THEN
455: l_matched_value := 'Err';
456: END;

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

5734: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5735: ) IS
5736: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5737: SELECT party_site_id
5738: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5739: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5740: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5741: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5742: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

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

5735: ) IS
5736: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5737: SELECT party_site_id
5738: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5739: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5740: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5741: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5742: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5743: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

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

5736: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5737: SELECT party_site_id
5738: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5739: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5740: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5741: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5742: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5743: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5744:

Line 5741: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5737: SELECT party_site_id
5738: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5739: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5740: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5741: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5742: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5743: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5744:
5745: I NUMBER;

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

5739: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5740: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5741: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5742: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5743: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5744:
5745: I NUMBER;
5746: J NUMBER:=1;
5747: l_party_site_id NUMBER;