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

Line 646: SELECT HZ_LOCATIONS.CITY

642: RETURN l_matched_value;
643: END IF;
644: IF p_attribute = 'CITY' THEN
645: BEGIN
646: SELECT HZ_LOCATIONS.CITY
647: INTO l_matched_value
648: FROM HZ_PARTY_SITES, HZ_LOCATIONS
649: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
650: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 648: FROM HZ_PARTY_SITES, HZ_LOCATIONS

644: IF p_attribute = 'CITY' THEN
645: BEGIN
646: SELECT HZ_LOCATIONS.CITY
647: INTO l_matched_value
648: FROM HZ_PARTY_SITES, HZ_LOCATIONS
649: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
650: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
651: EXCEPTION
652: WHEN NO_DATA_FOUND THEN

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

646: SELECT HZ_LOCATIONS.CITY
647: INTO l_matched_value
648: FROM HZ_PARTY_SITES, HZ_LOCATIONS
649: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
650: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
651: EXCEPTION
652: WHEN NO_DATA_FOUND THEN
653: l_matched_value := 'Err';
654: END;

Line 659: SELECT HZ_LOCATIONS.POSTAL_CODE

655: RETURN l_matched_value;
656: END IF;
657: IF p_attribute = 'POSTAL_CODE' THEN
658: BEGIN
659: SELECT HZ_LOCATIONS.POSTAL_CODE
660: INTO l_matched_value
661: FROM HZ_PARTY_SITES, HZ_LOCATIONS
662: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
663: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 661: FROM HZ_PARTY_SITES, HZ_LOCATIONS

657: IF p_attribute = 'POSTAL_CODE' THEN
658: BEGIN
659: SELECT HZ_LOCATIONS.POSTAL_CODE
660: INTO l_matched_value
661: FROM HZ_PARTY_SITES, HZ_LOCATIONS
662: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
663: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
664: EXCEPTION
665: WHEN NO_DATA_FOUND THEN

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

659: SELECT HZ_LOCATIONS.POSTAL_CODE
660: INTO l_matched_value
661: FROM HZ_PARTY_SITES, HZ_LOCATIONS
662: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
663: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
664: EXCEPTION
665: WHEN NO_DATA_FOUND THEN
666: l_matched_value := 'Err';
667: END;

Line 672: SELECT HZ_LOCATIONS.PROVINCE

668: RETURN l_matched_value;
669: END IF;
670: IF p_attribute = 'PROVINCE' THEN
671: BEGIN
672: SELECT HZ_LOCATIONS.PROVINCE
673: INTO l_matched_value
674: FROM HZ_PARTY_SITES, HZ_LOCATIONS
675: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
676: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 674: FROM HZ_PARTY_SITES, HZ_LOCATIONS

670: IF p_attribute = 'PROVINCE' THEN
671: BEGIN
672: SELECT HZ_LOCATIONS.PROVINCE
673: INTO l_matched_value
674: FROM HZ_PARTY_SITES, HZ_LOCATIONS
675: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
676: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
677: EXCEPTION
678: WHEN NO_DATA_FOUND THEN

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

672: SELECT HZ_LOCATIONS.PROVINCE
673: INTO l_matched_value
674: FROM HZ_PARTY_SITES, HZ_LOCATIONS
675: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
676: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
677: EXCEPTION
678: WHEN NO_DATA_FOUND THEN
679: l_matched_value := 'Err';
680: END;

Line 685: SELECT HZ_LOCATIONS.STATE

681: RETURN l_matched_value;
682: END IF;
683: IF p_attribute = 'STATE' THEN
684: BEGIN
685: SELECT HZ_LOCATIONS.STATE
686: INTO l_matched_value
687: FROM HZ_PARTY_SITES, HZ_LOCATIONS
688: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
689: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 687: FROM HZ_PARTY_SITES, HZ_LOCATIONS

683: IF p_attribute = 'STATE' THEN
684: BEGIN
685: SELECT HZ_LOCATIONS.STATE
686: INTO l_matched_value
687: FROM HZ_PARTY_SITES, HZ_LOCATIONS
688: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
689: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
690: EXCEPTION
691: WHEN NO_DATA_FOUND THEN

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

685: SELECT HZ_LOCATIONS.STATE
686: INTO l_matched_value
687: FROM HZ_PARTY_SITES, HZ_LOCATIONS
688: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
689: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
690: EXCEPTION
691: WHEN NO_DATA_FOUND THEN
692: l_matched_value := 'Err';
693: END;

Line 698: SELECT HZ_LOCATIONS.COUNTY

694: RETURN l_matched_value;
695: END IF;
696: IF p_attribute = 'COUNTY' THEN
697: BEGIN
698: SELECT HZ_LOCATIONS.COUNTY
699: INTO l_matched_value
700: FROM HZ_PARTY_SITES, HZ_LOCATIONS
701: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
702: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 700: FROM HZ_PARTY_SITES, HZ_LOCATIONS

696: IF p_attribute = 'COUNTY' THEN
697: BEGIN
698: SELECT HZ_LOCATIONS.COUNTY
699: INTO l_matched_value
700: FROM HZ_PARTY_SITES, HZ_LOCATIONS
701: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
702: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
703: EXCEPTION
704: WHEN NO_DATA_FOUND THEN

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

698: SELECT HZ_LOCATIONS.COUNTY
699: INTO l_matched_value
700: FROM HZ_PARTY_SITES, HZ_LOCATIONS
701: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
702: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
703: EXCEPTION
704: WHEN NO_DATA_FOUND THEN
705: l_matched_value := 'Err';
706: END;

Line 711: SELECT HZ_LOCATIONS.COUNTRY

707: RETURN l_matched_value;
708: END IF;
709: IF p_attribute = 'COUNTRY' THEN
710: BEGIN
711: SELECT HZ_LOCATIONS.COUNTRY
712: INTO l_matched_value
713: FROM HZ_PARTY_SITES, HZ_LOCATIONS
714: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
715: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 713: FROM HZ_PARTY_SITES, HZ_LOCATIONS

709: IF p_attribute = 'COUNTRY' THEN
710: BEGIN
711: SELECT HZ_LOCATIONS.COUNTRY
712: INTO l_matched_value
713: FROM HZ_PARTY_SITES, HZ_LOCATIONS
714: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
715: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
716: EXCEPTION
717: WHEN NO_DATA_FOUND THEN

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

711: SELECT HZ_LOCATIONS.COUNTRY
712: INTO l_matched_value
713: FROM HZ_PARTY_SITES, HZ_LOCATIONS
714: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
715: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
716: EXCEPTION
717: WHEN NO_DATA_FOUND THEN
718: l_matched_value := 'Err';
719: END;

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

7068: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
7069: ) IS
7070: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
7071: SELECT party_site_id
7072: ,translate(HZ_LOCATIONS.CITY, '%',' ')
7073: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
7074: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7075: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7076: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')

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

7069: ) IS
7070: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
7071: SELECT party_site_id
7072: ,translate(HZ_LOCATIONS.CITY, '%',' ')
7073: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
7074: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7075: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7076: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7077: ,translate(HZ_LOCATIONS.STATE, '%',' ')

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

7070: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
7071: SELECT party_site_id
7072: ,translate(HZ_LOCATIONS.CITY, '%',' ')
7073: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
7074: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7075: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7076: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7077: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7078: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

7071: SELECT party_site_id
7072: ,translate(HZ_LOCATIONS.CITY, '%',' ')
7073: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
7074: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7075: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7076: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7077: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7078: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7079: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

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

7072: ,translate(HZ_LOCATIONS.CITY, '%',' ')
7073: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
7074: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7075: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7076: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7077: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7078: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7079: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
7080: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

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

7073: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
7074: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7075: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7076: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7077: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7078: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7079: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
7080: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
7081:

Line 7078: FROM HZ_PARTY_SITES, HZ_LOCATIONS

7074: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7075: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7076: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7077: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7078: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7079: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
7080: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
7081:
7082: I NUMBER;

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

7076: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7077: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7078: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7079: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
7080: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
7081:
7082: I NUMBER;
7083: J NUMBER:=1;
7084: l_party_site_id NUMBER;