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

Line 425: SELECT HZ_LOCATIONS.CITY

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

Line 427: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

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

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

Line 438: SELECT HZ_LOCATIONS.STATE

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

Line 440: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

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

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

Line 451: SELECT HZ_LOCATIONS.COUNTRY

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

Line 453: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

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

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

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

5883: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5884: ) IS
5885: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5886: SELECT party_site_id
5887: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5888: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5889: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5890: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5891: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

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

5884: ) IS
5885: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5886: SELECT party_site_id
5887: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5888: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5889: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5890: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5891: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5892: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

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

5885: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5886: SELECT party_site_id
5887: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5888: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5889: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5890: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5891: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5892: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5893:

Line 5890: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5886: SELECT party_site_id
5887: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5888: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5889: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5890: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5891: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5892: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5893:
5894: I NUMBER;

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

5888: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5889: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5890: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5891: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5892: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5893:
5894: I NUMBER;
5895: J NUMBER:=1;
5896: l_party_site_id NUMBER;