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

Line 449: SELECT HZ_LOCATIONS.POSTAL_CODE

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

Line 451: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

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

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

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

5845: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5846: ) IS
5847: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5848: SELECT party_site_id
5849: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5850: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5851: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5852: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5853:

Line 5850: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5846: ) IS
5847: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5848: SELECT party_site_id
5849: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5850: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5851: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5852: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5853:
5854: I NUMBER;

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

5848: SELECT party_site_id
5849: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5850: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5851: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5852: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5853:
5854: I NUMBER;
5855: J NUMBER:=1;
5856: l_party_site_id NUMBER;