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

Line 383: SELECT HZ_LOCATIONS.POSTAL_CODE

379: RETURN l_matched_value;
380: END IF;
381: IF p_attribute = 'POSTAL_CODE' THEN
382: BEGIN
383: SELECT HZ_LOCATIONS.POSTAL_CODE
384: INTO l_matched_value
385: FROM HZ_PARTY_SITES, HZ_LOCATIONS
386: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
387: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 385: FROM HZ_PARTY_SITES, HZ_LOCATIONS

381: IF p_attribute = 'POSTAL_CODE' THEN
382: BEGIN
383: SELECT HZ_LOCATIONS.POSTAL_CODE
384: INTO l_matched_value
385: FROM HZ_PARTY_SITES, HZ_LOCATIONS
386: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
387: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
388: EXCEPTION
389: WHEN NO_DATA_FOUND THEN

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

383: SELECT HZ_LOCATIONS.POSTAL_CODE
384: INTO l_matched_value
385: FROM HZ_PARTY_SITES, HZ_LOCATIONS
386: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
387: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
388: EXCEPTION
389: WHEN NO_DATA_FOUND THEN
390: l_matched_value := 'Err';
391: END;

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

5643: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5644: ) IS
5645: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5646: SELECT party_site_id
5647: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5648: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5649: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5650: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5651:

Line 5648: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5644: ) IS
5645: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5646: SELECT party_site_id
5647: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5648: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5649: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5650: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5651:
5652: I NUMBER;

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

5646: SELECT party_site_id
5647: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5648: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5649: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5650: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5651:
5652: I NUMBER;
5653: J NUMBER:=1;
5654: l_party_site_id NUMBER;