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

Line 468: SELECT HZ_LOCATIONS.CITY

464: RETURN l_matched_value;
465: END IF;
466: IF p_attribute = 'CITY' THEN
467: BEGIN
468: SELECT HZ_LOCATIONS.CITY
469: INTO l_matched_value
470: FROM HZ_PARTY_SITES, HZ_LOCATIONS
471: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
472: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 470: FROM HZ_PARTY_SITES, HZ_LOCATIONS

466: IF p_attribute = 'CITY' THEN
467: BEGIN
468: SELECT HZ_LOCATIONS.CITY
469: INTO l_matched_value
470: FROM HZ_PARTY_SITES, HZ_LOCATIONS
471: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
472: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
473: EXCEPTION
474: WHEN NO_DATA_FOUND THEN

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

468: SELECT HZ_LOCATIONS.CITY
469: INTO l_matched_value
470: FROM HZ_PARTY_SITES, HZ_LOCATIONS
471: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
472: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
473: EXCEPTION
474: WHEN NO_DATA_FOUND THEN
475: l_matched_value := 'Err';
476: END;

Line 481: SELECT HZ_LOCATIONS.POSTAL_CODE

477: RETURN l_matched_value;
478: END IF;
479: IF p_attribute = 'POSTAL_CODE' THEN
480: BEGIN
481: SELECT HZ_LOCATIONS.POSTAL_CODE
482: INTO l_matched_value
483: FROM HZ_PARTY_SITES, HZ_LOCATIONS
484: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
485: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 483: FROM HZ_PARTY_SITES, HZ_LOCATIONS

479: IF p_attribute = 'POSTAL_CODE' THEN
480: BEGIN
481: SELECT HZ_LOCATIONS.POSTAL_CODE
482: INTO l_matched_value
483: FROM HZ_PARTY_SITES, HZ_LOCATIONS
484: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
485: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
486: EXCEPTION
487: WHEN NO_DATA_FOUND THEN

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

481: SELECT HZ_LOCATIONS.POSTAL_CODE
482: INTO l_matched_value
483: FROM HZ_PARTY_SITES, HZ_LOCATIONS
484: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
485: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
486: EXCEPTION
487: WHEN NO_DATA_FOUND THEN
488: l_matched_value := 'Err';
489: END;

Line 494: SELECT HZ_LOCATIONS.PROVINCE

490: RETURN l_matched_value;
491: END IF;
492: IF p_attribute = 'PROVINCE' THEN
493: BEGIN
494: SELECT HZ_LOCATIONS.PROVINCE
495: INTO l_matched_value
496: FROM HZ_PARTY_SITES, HZ_LOCATIONS
497: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
498: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 496: FROM HZ_PARTY_SITES, HZ_LOCATIONS

492: IF p_attribute = 'PROVINCE' THEN
493: BEGIN
494: SELECT HZ_LOCATIONS.PROVINCE
495: INTO l_matched_value
496: FROM HZ_PARTY_SITES, HZ_LOCATIONS
497: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
498: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
499: EXCEPTION
500: WHEN NO_DATA_FOUND THEN

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

494: SELECT HZ_LOCATIONS.PROVINCE
495: INTO l_matched_value
496: FROM HZ_PARTY_SITES, HZ_LOCATIONS
497: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
498: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
499: EXCEPTION
500: WHEN NO_DATA_FOUND THEN
501: l_matched_value := 'Err';
502: END;

Line 507: SELECT HZ_LOCATIONS.STATE

503: RETURN l_matched_value;
504: END IF;
505: IF p_attribute = 'STATE' THEN
506: BEGIN
507: SELECT HZ_LOCATIONS.STATE
508: INTO l_matched_value
509: FROM HZ_PARTY_SITES, HZ_LOCATIONS
510: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
511: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 509: FROM HZ_PARTY_SITES, HZ_LOCATIONS

505: IF p_attribute = 'STATE' THEN
506: BEGIN
507: SELECT HZ_LOCATIONS.STATE
508: INTO l_matched_value
509: FROM HZ_PARTY_SITES, HZ_LOCATIONS
510: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
511: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
512: EXCEPTION
513: WHEN NO_DATA_FOUND THEN

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

507: SELECT HZ_LOCATIONS.STATE
508: INTO l_matched_value
509: FROM HZ_PARTY_SITES, HZ_LOCATIONS
510: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
511: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
512: EXCEPTION
513: WHEN NO_DATA_FOUND THEN
514: l_matched_value := 'Err';
515: END;

Line 520: SELECT HZ_LOCATIONS.COUNTRY

516: RETURN l_matched_value;
517: END IF;
518: IF p_attribute = 'COUNTRY' THEN
519: BEGIN
520: SELECT HZ_LOCATIONS.COUNTRY
521: INTO l_matched_value
522: FROM HZ_PARTY_SITES, HZ_LOCATIONS
523: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
524: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 522: FROM HZ_PARTY_SITES, HZ_LOCATIONS

518: IF p_attribute = 'COUNTRY' THEN
519: BEGIN
520: SELECT HZ_LOCATIONS.COUNTRY
521: INTO l_matched_value
522: FROM HZ_PARTY_SITES, HZ_LOCATIONS
523: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
524: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
525: EXCEPTION
526: WHEN NO_DATA_FOUND THEN

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

520: SELECT HZ_LOCATIONS.COUNTRY
521: INTO l_matched_value
522: FROM HZ_PARTY_SITES, HZ_LOCATIONS
523: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
524: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
525: EXCEPTION
526: WHEN NO_DATA_FOUND THEN
527: l_matched_value := 'Err';
528: END;

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

6427: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
6428: ) IS
6429: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6430: SELECT party_site_id
6431: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6432: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6433: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6434: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6435: ,translate(HZ_LOCATIONS.STATE, '%',' ')

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

6428: ) IS
6429: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6430: SELECT party_site_id
6431: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6432: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6433: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6434: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6435: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6436: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

6429: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6430: SELECT party_site_id
6431: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6432: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6433: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6434: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6435: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6436: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6437: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

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

6430: SELECT party_site_id
6431: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6432: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6433: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6434: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6435: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6436: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6437: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6438: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

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

6431: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6432: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6433: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6434: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6435: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6436: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6437: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6438: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6439:

Line 6436: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6432: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6433: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6434: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6435: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6436: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6437: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6438: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6439:
6440: I NUMBER;

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

6434: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6435: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6436: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6437: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6438: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6439:
6440: I NUMBER;
6441: J NUMBER:=1;
6442: l_party_site_id NUMBER;