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

Line 395: SELECT HZ_LOCATIONS.CITY

391: RETURN l_matched_value;
392: END IF;
393: IF p_attribute = 'CITY' THEN
394: BEGIN
395: SELECT HZ_LOCATIONS.CITY
396: INTO l_matched_value
397: FROM HZ_PARTY_SITES, HZ_LOCATIONS
398: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
399: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 397: FROM HZ_PARTY_SITES, HZ_LOCATIONS

393: IF p_attribute = 'CITY' THEN
394: BEGIN
395: SELECT HZ_LOCATIONS.CITY
396: INTO l_matched_value
397: FROM HZ_PARTY_SITES, HZ_LOCATIONS
398: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
399: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
400: EXCEPTION
401: WHEN NO_DATA_FOUND THEN

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

395: SELECT HZ_LOCATIONS.CITY
396: INTO l_matched_value
397: FROM HZ_PARTY_SITES, HZ_LOCATIONS
398: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
399: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
400: EXCEPTION
401: WHEN NO_DATA_FOUND THEN
402: l_matched_value := 'Err';
403: END;

Line 408: SELECT HZ_LOCATIONS.POSTAL_CODE

404: RETURN l_matched_value;
405: END IF;
406: IF p_attribute = 'POSTAL_CODE' THEN
407: BEGIN
408: SELECT HZ_LOCATIONS.POSTAL_CODE
409: INTO l_matched_value
410: FROM HZ_PARTY_SITES, HZ_LOCATIONS
411: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
412: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 410: FROM HZ_PARTY_SITES, HZ_LOCATIONS

406: IF p_attribute = 'POSTAL_CODE' THEN
407: BEGIN
408: SELECT HZ_LOCATIONS.POSTAL_CODE
409: INTO l_matched_value
410: FROM HZ_PARTY_SITES, HZ_LOCATIONS
411: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
412: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
413: EXCEPTION
414: WHEN NO_DATA_FOUND THEN

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

408: SELECT HZ_LOCATIONS.POSTAL_CODE
409: INTO l_matched_value
410: FROM HZ_PARTY_SITES, HZ_LOCATIONS
411: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
412: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
413: EXCEPTION
414: WHEN NO_DATA_FOUND THEN
415: l_matched_value := 'Err';
416: END;

Line 421: SELECT HZ_LOCATIONS.PROVINCE

417: RETURN l_matched_value;
418: END IF;
419: IF p_attribute = 'PROVINCE' THEN
420: BEGIN
421: SELECT HZ_LOCATIONS.PROVINCE
422: INTO l_matched_value
423: FROM HZ_PARTY_SITES, HZ_LOCATIONS
424: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
425: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 423: FROM HZ_PARTY_SITES, HZ_LOCATIONS

419: IF p_attribute = 'PROVINCE' THEN
420: BEGIN
421: SELECT HZ_LOCATIONS.PROVINCE
422: INTO l_matched_value
423: FROM HZ_PARTY_SITES, HZ_LOCATIONS
424: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
425: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
426: EXCEPTION
427: WHEN NO_DATA_FOUND THEN

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

421: SELECT HZ_LOCATIONS.PROVINCE
422: INTO l_matched_value
423: FROM HZ_PARTY_SITES, HZ_LOCATIONS
424: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
425: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
426: EXCEPTION
427: WHEN NO_DATA_FOUND THEN
428: l_matched_value := 'Err';
429: END;

Line 434: SELECT HZ_LOCATIONS.STATE

430: RETURN l_matched_value;
431: END IF;
432: IF p_attribute = 'STATE' THEN
433: BEGIN
434: SELECT HZ_LOCATIONS.STATE
435: INTO l_matched_value
436: FROM HZ_PARTY_SITES, HZ_LOCATIONS
437: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
438: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 436: FROM HZ_PARTY_SITES, HZ_LOCATIONS

432: IF p_attribute = 'STATE' THEN
433: BEGIN
434: SELECT HZ_LOCATIONS.STATE
435: INTO l_matched_value
436: FROM HZ_PARTY_SITES, HZ_LOCATIONS
437: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
438: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
439: EXCEPTION
440: WHEN NO_DATA_FOUND THEN

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

434: SELECT HZ_LOCATIONS.STATE
435: INTO l_matched_value
436: FROM HZ_PARTY_SITES, HZ_LOCATIONS
437: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
438: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
439: EXCEPTION
440: WHEN NO_DATA_FOUND THEN
441: l_matched_value := 'Err';
442: END;

Line 447: SELECT HZ_LOCATIONS.COUNTRY

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

Line 449: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

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

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

Line 6148: ,translate(HZ_LOCATIONS.CITY, '%',' ')

6144: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
6145: ) IS
6146: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6147: SELECT party_site_id
6148: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6149: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6150: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6151: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6152: ,translate(HZ_LOCATIONS.STATE, '%',' ')

Line 6149: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')

6145: ) IS
6146: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6147: SELECT party_site_id
6148: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6149: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6150: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6151: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6152: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6153: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

6146: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6147: SELECT party_site_id
6148: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6149: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6150: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6151: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6152: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6153: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6154: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

Line 6151: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')

6147: SELECT party_site_id
6148: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6149: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6150: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6151: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6152: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6153: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6154: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6155: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

Line 6152: ,translate(HZ_LOCATIONS.STATE, '%',' ')

6148: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6149: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6150: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6151: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6152: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6153: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6154: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6155: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6156:

Line 6153: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6149: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6150: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6151: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6152: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6153: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6154: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6155: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6156:
6157: I NUMBER;

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

6151: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6152: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6153: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6154: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6155: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6156:
6157: I NUMBER;
6158: J NUMBER:=1;
6159: l_party_site_id NUMBER;