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

Line 411: SELECT HZ_LOCATIONS.CITY

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

Line 413: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

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

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

Line 424: SELECT HZ_LOCATIONS.POSTAL_CODE

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

Line 426: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

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

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

Line 437: SELECT HZ_LOCATIONS.PROVINCE

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

Line 439: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

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

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

Line 450: SELECT HZ_LOCATIONS.STATE

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

Line 452: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

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

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

Line 463: SELECT HZ_LOCATIONS.COUNTY

459: RETURN l_matched_value;
460: END IF;
461: IF p_attribute = 'COUNTY' THEN
462: BEGIN
463: SELECT HZ_LOCATIONS.COUNTY
464: INTO l_matched_value
465: FROM HZ_PARTY_SITES, HZ_LOCATIONS
466: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
467: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 465: FROM HZ_PARTY_SITES, HZ_LOCATIONS

461: IF p_attribute = 'COUNTY' THEN
462: BEGIN
463: SELECT HZ_LOCATIONS.COUNTY
464: INTO l_matched_value
465: FROM HZ_PARTY_SITES, HZ_LOCATIONS
466: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
467: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
468: EXCEPTION
469: WHEN NO_DATA_FOUND THEN

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

463: SELECT HZ_LOCATIONS.COUNTY
464: INTO l_matched_value
465: FROM HZ_PARTY_SITES, HZ_LOCATIONS
466: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
467: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
468: EXCEPTION
469: WHEN NO_DATA_FOUND THEN
470: l_matched_value := 'Err';
471: END;

Line 476: SELECT HZ_LOCATIONS.COUNTRY

472: RETURN l_matched_value;
473: END IF;
474: IF p_attribute = 'COUNTRY' THEN
475: BEGIN
476: SELECT HZ_LOCATIONS.COUNTRY
477: INTO l_matched_value
478: FROM HZ_PARTY_SITES, HZ_LOCATIONS
479: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
480: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 478: FROM HZ_PARTY_SITES, HZ_LOCATIONS

474: IF p_attribute = 'COUNTRY' THEN
475: BEGIN
476: SELECT HZ_LOCATIONS.COUNTRY
477: INTO l_matched_value
478: FROM HZ_PARTY_SITES, HZ_LOCATIONS
479: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
480: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
481: EXCEPTION
482: WHEN NO_DATA_FOUND THEN

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

476: SELECT HZ_LOCATIONS.COUNTRY
477: INTO l_matched_value
478: FROM HZ_PARTY_SITES, HZ_LOCATIONS
479: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
480: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
481: EXCEPTION
482: WHEN NO_DATA_FOUND THEN
483: l_matched_value := 'Err';
484: END;

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

6031: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
6032: ) IS
6033: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6034: SELECT party_site_id
6035: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6036: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6037: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
6038: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6039: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')

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

6032: ) IS
6033: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6034: SELECT party_site_id
6035: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6036: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6037: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
6038: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6039: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6040: ,translate(HZ_LOCATIONS.STATE, '%',' ')

Line 6037: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')

6033: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6034: SELECT party_site_id
6035: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6036: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6037: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
6038: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6039: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6040: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6041: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

6034: SELECT party_site_id
6035: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6036: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6037: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
6038: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6039: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6040: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6041: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6042: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

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

6035: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6036: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6037: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
6038: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6039: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6040: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6041: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6042: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6043: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

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

6036: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6037: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
6038: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6039: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6040: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6041: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6042: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6043: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6044:

Line 6041: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6037: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
6038: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6039: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6040: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6041: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6042: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6043: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6044:
6045: I NUMBER;

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

6039: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6040: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6041: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6042: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6043: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6044:
6045: I NUMBER;
6046: J NUMBER:=1;
6047: l_party_site_id NUMBER;