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 5772: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')

5768: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5769: ) IS
5770: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5771: SELECT party_site_id
5772: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5773: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5774: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5775: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5776:

Line 5773: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5769: ) IS
5770: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5771: SELECT party_site_id
5772: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5773: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5774: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5775: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5776:
5777: I NUMBER;

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

5771: SELECT party_site_id
5772: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5773: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5774: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5775: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5776:
5777: I NUMBER;
5778: J NUMBER:=1;
5779: l_party_site_id NUMBER;