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

Line 489: SELECT HZ_LOCATIONS.CITY

485: RETURN l_matched_value;
486: END IF;
487: IF p_attribute = 'CITY' THEN
488: BEGIN
489: SELECT HZ_LOCATIONS.CITY
490: INTO l_matched_value
491: FROM HZ_PARTY_SITES, HZ_LOCATIONS
492: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
493: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 491: FROM HZ_PARTY_SITES, HZ_LOCATIONS

487: IF p_attribute = 'CITY' THEN
488: BEGIN
489: SELECT HZ_LOCATIONS.CITY
490: INTO l_matched_value
491: FROM HZ_PARTY_SITES, HZ_LOCATIONS
492: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
493: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
494: EXCEPTION
495: WHEN NO_DATA_FOUND THEN

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

489: SELECT HZ_LOCATIONS.CITY
490: INTO l_matched_value
491: FROM HZ_PARTY_SITES, HZ_LOCATIONS
492: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
493: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
494: EXCEPTION
495: WHEN NO_DATA_FOUND THEN
496: l_matched_value := 'Err';
497: END;

Line 502: SELECT HZ_LOCATIONS.POSTAL_CODE

498: RETURN l_matched_value;
499: END IF;
500: IF p_attribute = 'POSTAL_CODE' THEN
501: BEGIN
502: SELECT HZ_LOCATIONS.POSTAL_CODE
503: INTO l_matched_value
504: FROM HZ_PARTY_SITES, HZ_LOCATIONS
505: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
506: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 504: FROM HZ_PARTY_SITES, HZ_LOCATIONS

500: IF p_attribute = 'POSTAL_CODE' THEN
501: BEGIN
502: SELECT HZ_LOCATIONS.POSTAL_CODE
503: INTO l_matched_value
504: FROM HZ_PARTY_SITES, HZ_LOCATIONS
505: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
506: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
507: EXCEPTION
508: WHEN NO_DATA_FOUND THEN

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

502: SELECT HZ_LOCATIONS.POSTAL_CODE
503: INTO l_matched_value
504: FROM HZ_PARTY_SITES, HZ_LOCATIONS
505: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
506: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
507: EXCEPTION
508: WHEN NO_DATA_FOUND THEN
509: l_matched_value := 'Err';
510: END;

Line 515: SELECT HZ_LOCATIONS.PROVINCE

511: RETURN l_matched_value;
512: END IF;
513: IF p_attribute = 'PROVINCE' THEN
514: BEGIN
515: SELECT HZ_LOCATIONS.PROVINCE
516: INTO l_matched_value
517: FROM HZ_PARTY_SITES, HZ_LOCATIONS
518: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
519: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 517: FROM HZ_PARTY_SITES, HZ_LOCATIONS

513: IF p_attribute = 'PROVINCE' THEN
514: BEGIN
515: SELECT HZ_LOCATIONS.PROVINCE
516: INTO l_matched_value
517: FROM HZ_PARTY_SITES, HZ_LOCATIONS
518: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
519: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
520: EXCEPTION
521: WHEN NO_DATA_FOUND THEN

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

515: SELECT HZ_LOCATIONS.PROVINCE
516: INTO l_matched_value
517: FROM HZ_PARTY_SITES, HZ_LOCATIONS
518: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
519: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
520: EXCEPTION
521: WHEN NO_DATA_FOUND THEN
522: l_matched_value := 'Err';
523: END;

Line 528: SELECT HZ_LOCATIONS.STATE

524: RETURN l_matched_value;
525: END IF;
526: IF p_attribute = 'STATE' THEN
527: BEGIN
528: SELECT HZ_LOCATIONS.STATE
529: INTO l_matched_value
530: FROM HZ_PARTY_SITES, HZ_LOCATIONS
531: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
532: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 530: FROM HZ_PARTY_SITES, HZ_LOCATIONS

526: IF p_attribute = 'STATE' THEN
527: BEGIN
528: SELECT HZ_LOCATIONS.STATE
529: INTO l_matched_value
530: FROM HZ_PARTY_SITES, HZ_LOCATIONS
531: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
532: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
533: EXCEPTION
534: WHEN NO_DATA_FOUND THEN

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

528: SELECT HZ_LOCATIONS.STATE
529: INTO l_matched_value
530: FROM HZ_PARTY_SITES, HZ_LOCATIONS
531: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
532: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
533: EXCEPTION
534: WHEN NO_DATA_FOUND THEN
535: l_matched_value := 'Err';
536: END;

Line 541: SELECT HZ_LOCATIONS.COUNTRY

537: RETURN l_matched_value;
538: END IF;
539: IF p_attribute = 'COUNTRY' THEN
540: BEGIN
541: SELECT HZ_LOCATIONS.COUNTRY
542: INTO l_matched_value
543: FROM HZ_PARTY_SITES, HZ_LOCATIONS
544: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
545: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 543: FROM HZ_PARTY_SITES, HZ_LOCATIONS

539: IF p_attribute = 'COUNTRY' THEN
540: BEGIN
541: SELECT HZ_LOCATIONS.COUNTRY
542: INTO l_matched_value
543: FROM HZ_PARTY_SITES, HZ_LOCATIONS
544: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
545: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
546: EXCEPTION
547: WHEN NO_DATA_FOUND THEN

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

541: SELECT HZ_LOCATIONS.COUNTRY
542: INTO l_matched_value
543: FROM HZ_PARTY_SITES, HZ_LOCATIONS
544: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
545: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
546: EXCEPTION
547: WHEN NO_DATA_FOUND THEN
548: l_matched_value := 'Err';
549: END;

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

6418: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
6419: ) IS
6420: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6421: SELECT party_site_id
6422: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6423: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6424: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6425: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6426: ,translate(HZ_LOCATIONS.STATE, '%',' ')

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

6419: ) IS
6420: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6421: SELECT party_site_id
6422: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6423: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6424: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6425: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6426: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6427: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

6420: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6421: SELECT party_site_id
6422: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6423: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6424: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6425: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6426: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6427: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6428: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

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

6421: SELECT party_site_id
6422: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6423: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6424: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6425: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6426: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6427: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6428: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6429: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

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

6422: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6423: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6424: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6425: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6426: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6427: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6428: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6429: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6430:

Line 6427: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6423: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6424: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6425: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6426: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6427: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6428: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6429: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6430:
6431: I NUMBER;

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

6425: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6426: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6427: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6428: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6429: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6430:
6431: I NUMBER;
6432: J NUMBER:=1;
6433: l_party_site_id NUMBER;