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

Line 374: SELECT HZ_LOCATIONS.POSTAL_CODE

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

Line 376: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

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

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

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

5763: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5764: ) IS
5765: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5766: SELECT party_site_id
5767: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5768: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5769: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5770: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5771:

Line 5768: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5764: ) IS
5765: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5766: SELECT party_site_id
5767: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5768: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5769: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5770: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5771:
5772: I NUMBER;

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

5766: SELECT party_site_id
5767: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5768: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5769: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5770: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5771:
5772: I NUMBER;
5773: J NUMBER:=1;
5774: l_party_site_id NUMBER;