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

Line 654: SELECT HZ_LOCATIONS.CITY

650: END IF;
651: IF p_entity = 'PARTY_SITES' THEN
652: IF p_attribute = 'CITY' THEN
653: BEGIN
654: SELECT HZ_LOCATIONS.CITY
655: INTO l_matched_value
656: FROM HZ_PARTY_SITES, HZ_LOCATIONS
657: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
658: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 656: FROM HZ_PARTY_SITES, HZ_LOCATIONS

652: IF p_attribute = 'CITY' THEN
653: BEGIN
654: SELECT HZ_LOCATIONS.CITY
655: INTO l_matched_value
656: FROM HZ_PARTY_SITES, HZ_LOCATIONS
657: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
658: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
659: EXCEPTION
660: WHEN NO_DATA_FOUND THEN

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

654: SELECT HZ_LOCATIONS.CITY
655: INTO l_matched_value
656: FROM HZ_PARTY_SITES, HZ_LOCATIONS
657: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
658: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
659: EXCEPTION
660: WHEN NO_DATA_FOUND THEN
661: l_matched_value := 'Err';
662: END;

Line 667: SELECT HZ_LOCATIONS.POSTAL_CODE

663: RETURN l_matched_value;
664: END IF;
665: IF p_attribute = 'POSTAL_CODE' THEN
666: BEGIN
667: SELECT HZ_LOCATIONS.POSTAL_CODE
668: INTO l_matched_value
669: FROM HZ_PARTY_SITES, HZ_LOCATIONS
670: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
671: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 669: FROM HZ_PARTY_SITES, HZ_LOCATIONS

665: IF p_attribute = 'POSTAL_CODE' THEN
666: BEGIN
667: SELECT HZ_LOCATIONS.POSTAL_CODE
668: INTO l_matched_value
669: FROM HZ_PARTY_SITES, HZ_LOCATIONS
670: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
671: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
672: EXCEPTION
673: WHEN NO_DATA_FOUND THEN

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

667: SELECT HZ_LOCATIONS.POSTAL_CODE
668: INTO l_matched_value
669: FROM HZ_PARTY_SITES, HZ_LOCATIONS
670: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
671: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
672: EXCEPTION
673: WHEN NO_DATA_FOUND THEN
674: l_matched_value := 'Err';
675: END;

Line 680: SELECT HZ_LOCATIONS.PROVINCE

676: RETURN l_matched_value;
677: END IF;
678: IF p_attribute = 'PROVINCE' THEN
679: BEGIN
680: SELECT HZ_LOCATIONS.PROVINCE
681: INTO l_matched_value
682: FROM HZ_PARTY_SITES, HZ_LOCATIONS
683: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
684: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 682: FROM HZ_PARTY_SITES, HZ_LOCATIONS

678: IF p_attribute = 'PROVINCE' THEN
679: BEGIN
680: SELECT HZ_LOCATIONS.PROVINCE
681: INTO l_matched_value
682: FROM HZ_PARTY_SITES, HZ_LOCATIONS
683: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
684: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
685: EXCEPTION
686: WHEN NO_DATA_FOUND THEN

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

680: SELECT HZ_LOCATIONS.PROVINCE
681: INTO l_matched_value
682: FROM HZ_PARTY_SITES, HZ_LOCATIONS
683: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
684: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
685: EXCEPTION
686: WHEN NO_DATA_FOUND THEN
687: l_matched_value := 'Err';
688: END;

Line 693: SELECT HZ_LOCATIONS.STATE

689: RETURN l_matched_value;
690: END IF;
691: IF p_attribute = 'STATE' THEN
692: BEGIN
693: SELECT HZ_LOCATIONS.STATE
694: INTO l_matched_value
695: FROM HZ_PARTY_SITES, HZ_LOCATIONS
696: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
697: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 695: FROM HZ_PARTY_SITES, HZ_LOCATIONS

691: IF p_attribute = 'STATE' THEN
692: BEGIN
693: SELECT HZ_LOCATIONS.STATE
694: INTO l_matched_value
695: FROM HZ_PARTY_SITES, HZ_LOCATIONS
696: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
697: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
698: EXCEPTION
699: WHEN NO_DATA_FOUND THEN

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

693: SELECT HZ_LOCATIONS.STATE
694: INTO l_matched_value
695: FROM HZ_PARTY_SITES, HZ_LOCATIONS
696: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
697: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
698: EXCEPTION
699: WHEN NO_DATA_FOUND THEN
700: l_matched_value := 'Err';
701: END;

Line 706: SELECT HZ_LOCATIONS.COUNTY

702: RETURN l_matched_value;
703: END IF;
704: IF p_attribute = 'COUNTY' THEN
705: BEGIN
706: SELECT HZ_LOCATIONS.COUNTY
707: INTO l_matched_value
708: FROM HZ_PARTY_SITES, HZ_LOCATIONS
709: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
710: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 708: FROM HZ_PARTY_SITES, HZ_LOCATIONS

704: IF p_attribute = 'COUNTY' THEN
705: BEGIN
706: SELECT HZ_LOCATIONS.COUNTY
707: INTO l_matched_value
708: FROM HZ_PARTY_SITES, HZ_LOCATIONS
709: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
710: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
711: EXCEPTION
712: WHEN NO_DATA_FOUND THEN

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

706: SELECT HZ_LOCATIONS.COUNTY
707: INTO l_matched_value
708: FROM HZ_PARTY_SITES, HZ_LOCATIONS
709: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
710: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
711: EXCEPTION
712: WHEN NO_DATA_FOUND THEN
713: l_matched_value := 'Err';
714: END;

Line 719: SELECT HZ_LOCATIONS.COUNTRY

715: RETURN l_matched_value;
716: END IF;
717: IF p_attribute = 'COUNTRY' THEN
718: BEGIN
719: SELECT HZ_LOCATIONS.COUNTRY
720: INTO l_matched_value
721: FROM HZ_PARTY_SITES, HZ_LOCATIONS
722: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
723: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 721: FROM HZ_PARTY_SITES, HZ_LOCATIONS

717: IF p_attribute = 'COUNTRY' THEN
718: BEGIN
719: SELECT HZ_LOCATIONS.COUNTRY
720: INTO l_matched_value
721: FROM HZ_PARTY_SITES, HZ_LOCATIONS
722: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
723: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
724: EXCEPTION
725: WHEN NO_DATA_FOUND THEN

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

719: SELECT HZ_LOCATIONS.COUNTRY
720: INTO l_matched_value
721: FROM HZ_PARTY_SITES, HZ_LOCATIONS
722: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
723: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
724: EXCEPTION
725: WHEN NO_DATA_FOUND THEN
726: l_matched_value := 'Err';
727: END;

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

7052: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
7053: ) IS
7054: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
7055: SELECT party_site_id
7056: ,translate(HZ_LOCATIONS.CITY, '%',' ')
7057: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
7058: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7059: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7060: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')

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

7053: ) IS
7054: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
7055: SELECT party_site_id
7056: ,translate(HZ_LOCATIONS.CITY, '%',' ')
7057: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
7058: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7059: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7060: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7061: ,translate(HZ_LOCATIONS.STATE, '%',' ')

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

7054: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
7055: SELECT party_site_id
7056: ,translate(HZ_LOCATIONS.CITY, '%',' ')
7057: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
7058: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7059: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7060: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7061: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7062: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

7055: SELECT party_site_id
7056: ,translate(HZ_LOCATIONS.CITY, '%',' ')
7057: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
7058: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7059: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7060: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7061: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7062: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7063: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

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

7056: ,translate(HZ_LOCATIONS.CITY, '%',' ')
7057: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
7058: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7059: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7060: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7061: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7062: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7063: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
7064: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

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

7057: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
7058: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7059: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7060: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7061: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7062: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7063: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
7064: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
7065:

Line 7062: FROM HZ_PARTY_SITES, HZ_LOCATIONS

7058: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7059: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7060: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7061: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7062: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7063: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
7064: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
7065:
7066: I NUMBER;

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

7060: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7061: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7062: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7063: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
7064: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
7065:
7066: I NUMBER;
7067: J NUMBER:=1;
7068: l_party_site_id NUMBER;