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

Line 558: SELECT HZ_LOCATIONS.CITY

554: RETURN l_matched_value;
555: END IF;
556: IF p_attribute = 'CITY' THEN
557: BEGIN
558: SELECT HZ_LOCATIONS.CITY
559: INTO l_matched_value
560: FROM HZ_PARTY_SITES, HZ_LOCATIONS
561: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
562: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 560: FROM HZ_PARTY_SITES, HZ_LOCATIONS

556: IF p_attribute = 'CITY' THEN
557: BEGIN
558: SELECT HZ_LOCATIONS.CITY
559: INTO l_matched_value
560: FROM HZ_PARTY_SITES, HZ_LOCATIONS
561: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
562: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
563: EXCEPTION
564: WHEN NO_DATA_FOUND THEN

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

558: SELECT HZ_LOCATIONS.CITY
559: INTO l_matched_value
560: FROM HZ_PARTY_SITES, HZ_LOCATIONS
561: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
562: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
563: EXCEPTION
564: WHEN NO_DATA_FOUND THEN
565: l_matched_value := 'Err';
566: END;

Line 571: SELECT HZ_LOCATIONS.POSTAL_CODE

567: RETURN l_matched_value;
568: END IF;
569: IF p_attribute = 'POSTAL_CODE' THEN
570: BEGIN
571: SELECT HZ_LOCATIONS.POSTAL_CODE
572: INTO l_matched_value
573: FROM HZ_PARTY_SITES, HZ_LOCATIONS
574: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
575: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 573: FROM HZ_PARTY_SITES, HZ_LOCATIONS

569: IF p_attribute = 'POSTAL_CODE' THEN
570: BEGIN
571: SELECT HZ_LOCATIONS.POSTAL_CODE
572: INTO l_matched_value
573: FROM HZ_PARTY_SITES, HZ_LOCATIONS
574: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
575: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
576: EXCEPTION
577: WHEN NO_DATA_FOUND THEN

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

571: SELECT HZ_LOCATIONS.POSTAL_CODE
572: INTO l_matched_value
573: FROM HZ_PARTY_SITES, HZ_LOCATIONS
574: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
575: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
576: EXCEPTION
577: WHEN NO_DATA_FOUND THEN
578: l_matched_value := 'Err';
579: END;

Line 584: SELECT HZ_LOCATIONS.STATE

580: RETURN l_matched_value;
581: END IF;
582: IF p_attribute = 'STATE' THEN
583: BEGIN
584: SELECT HZ_LOCATIONS.STATE
585: INTO l_matched_value
586: FROM HZ_PARTY_SITES, HZ_LOCATIONS
587: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
588: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 586: FROM HZ_PARTY_SITES, HZ_LOCATIONS

582: IF p_attribute = 'STATE' THEN
583: BEGIN
584: SELECT HZ_LOCATIONS.STATE
585: INTO l_matched_value
586: FROM HZ_PARTY_SITES, HZ_LOCATIONS
587: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
588: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
589: EXCEPTION
590: WHEN NO_DATA_FOUND THEN

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

584: SELECT HZ_LOCATIONS.STATE
585: INTO l_matched_value
586: FROM HZ_PARTY_SITES, HZ_LOCATIONS
587: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
588: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
589: EXCEPTION
590: WHEN NO_DATA_FOUND THEN
591: l_matched_value := 'Err';
592: END;

Line 597: SELECT HZ_LOCATIONS.COUNTRY

593: RETURN l_matched_value;
594: END IF;
595: IF p_attribute = 'COUNTRY' THEN
596: BEGIN
597: SELECT HZ_LOCATIONS.COUNTRY
598: INTO l_matched_value
599: FROM HZ_PARTY_SITES, HZ_LOCATIONS
600: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
601: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 599: FROM HZ_PARTY_SITES, HZ_LOCATIONS

595: IF p_attribute = 'COUNTRY' THEN
596: BEGIN
597: SELECT HZ_LOCATIONS.COUNTRY
598: INTO l_matched_value
599: FROM HZ_PARTY_SITES, HZ_LOCATIONS
600: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
601: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
602: EXCEPTION
603: WHEN NO_DATA_FOUND THEN

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

597: SELECT HZ_LOCATIONS.COUNTRY
598: INTO l_matched_value
599: FROM HZ_PARTY_SITES, HZ_LOCATIONS
600: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
601: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
602: EXCEPTION
603: WHEN NO_DATA_FOUND THEN
604: l_matched_value := 'Err';
605: END;

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

6613: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
6614: ) IS
6615: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6616: SELECT party_site_id
6617: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6618: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6619: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6620: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6621: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

6614: ) IS
6615: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6616: SELECT party_site_id
6617: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6618: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6619: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6620: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6621: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6622: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

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

6615: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6616: SELECT party_site_id
6617: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6618: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6619: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6620: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6621: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6622: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6623: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

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

6616: SELECT party_site_id
6617: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6618: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6619: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6620: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6621: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6622: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6623: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6624:

Line 6621: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6617: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6618: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6619: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6620: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6621: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6622: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6623: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6624:
6625: I NUMBER;

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

6619: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6620: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6621: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6622: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6623: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6624:
6625: I NUMBER;
6626: J NUMBER:=1;
6627: l_party_site_id NUMBER;