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

Line 390: SELECT HZ_LOCATIONS.POSTAL_CODE

386: RETURN l_matched_value;
387: END IF;
388: IF p_attribute = 'POSTAL_CODE' THEN
389: BEGIN
390: SELECT HZ_LOCATIONS.POSTAL_CODE
391: INTO l_matched_value
392: FROM HZ_PARTY_SITES, HZ_LOCATIONS
393: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
394: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 392: FROM HZ_PARTY_SITES, HZ_LOCATIONS

388: IF p_attribute = 'POSTAL_CODE' THEN
389: BEGIN
390: SELECT HZ_LOCATIONS.POSTAL_CODE
391: INTO l_matched_value
392: FROM HZ_PARTY_SITES, HZ_LOCATIONS
393: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
394: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
395: EXCEPTION
396: WHEN NO_DATA_FOUND THEN

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

390: SELECT HZ_LOCATIONS.POSTAL_CODE
391: INTO l_matched_value
392: FROM HZ_PARTY_SITES, HZ_LOCATIONS
393: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
394: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
395: EXCEPTION
396: WHEN NO_DATA_FOUND THEN
397: l_matched_value := 'Err';
398: END;

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

5890: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5891: ) IS
5892: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5893: SELECT party_site_id
5894: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5895: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5896: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5897: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5898:

Line 5895: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5891: ) IS
5892: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5893: SELECT party_site_id
5894: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5895: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5896: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5897: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5898:
5899: I NUMBER;

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

5893: SELECT party_site_id
5894: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5895: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5896: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5897: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5898:
5899: I NUMBER;
5900: J NUMBER:=1;
5901: l_party_site_id NUMBER;