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

Line 432: SELECT HZ_LOCATIONS.CITY

428: RETURN l_matched_value;
429: END IF;
430: IF p_attribute = 'CITY' THEN
431: BEGIN
432: SELECT HZ_LOCATIONS.CITY
433: INTO l_matched_value
434: FROM HZ_PARTY_SITES, HZ_LOCATIONS
435: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
436: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 434: FROM HZ_PARTY_SITES, HZ_LOCATIONS

430: IF p_attribute = 'CITY' THEN
431: BEGIN
432: SELECT HZ_LOCATIONS.CITY
433: INTO l_matched_value
434: FROM HZ_PARTY_SITES, HZ_LOCATIONS
435: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
436: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
437: EXCEPTION
438: WHEN NO_DATA_FOUND THEN

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

432: SELECT HZ_LOCATIONS.CITY
433: INTO l_matched_value
434: FROM HZ_PARTY_SITES, HZ_LOCATIONS
435: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
436: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
437: EXCEPTION
438: WHEN NO_DATA_FOUND THEN
439: l_matched_value := 'Err';
440: END;

Line 445: SELECT HZ_LOCATIONS.STATE

441: RETURN l_matched_value;
442: END IF;
443: IF p_attribute = 'STATE' THEN
444: BEGIN
445: SELECT HZ_LOCATIONS.STATE
446: INTO l_matched_value
447: FROM HZ_PARTY_SITES, HZ_LOCATIONS
448: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
449: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 447: FROM HZ_PARTY_SITES, HZ_LOCATIONS

443: IF p_attribute = 'STATE' THEN
444: BEGIN
445: SELECT HZ_LOCATIONS.STATE
446: INTO l_matched_value
447: FROM HZ_PARTY_SITES, HZ_LOCATIONS
448: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
449: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
450: EXCEPTION
451: WHEN NO_DATA_FOUND THEN

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

445: SELECT HZ_LOCATIONS.STATE
446: INTO l_matched_value
447: FROM HZ_PARTY_SITES, HZ_LOCATIONS
448: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
449: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
450: EXCEPTION
451: WHEN NO_DATA_FOUND THEN
452: l_matched_value := 'Err';
453: END;

Line 458: SELECT HZ_LOCATIONS.COUNTRY

454: RETURN l_matched_value;
455: END IF;
456: IF p_attribute = 'COUNTRY' THEN
457: BEGIN
458: SELECT HZ_LOCATIONS.COUNTRY
459: INTO l_matched_value
460: FROM HZ_PARTY_SITES, HZ_LOCATIONS
461: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
462: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 460: FROM HZ_PARTY_SITES, HZ_LOCATIONS

456: IF p_attribute = 'COUNTRY' THEN
457: BEGIN
458: SELECT HZ_LOCATIONS.COUNTRY
459: INTO l_matched_value
460: FROM HZ_PARTY_SITES, HZ_LOCATIONS
461: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
462: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
463: EXCEPTION
464: WHEN NO_DATA_FOUND THEN

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

458: SELECT HZ_LOCATIONS.COUNTRY
459: INTO l_matched_value
460: FROM HZ_PARTY_SITES, HZ_LOCATIONS
461: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
462: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
463: EXCEPTION
464: WHEN NO_DATA_FOUND THEN
465: l_matched_value := 'Err';
466: END;

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

4718: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
4719: ) IS
4720: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
4721: SELECT party_site_id
4722: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4723: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4724: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4725: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4726: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

4719: ) IS
4720: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
4721: SELECT party_site_id
4722: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4723: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4724: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4725: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4726: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4727: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

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

4720: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
4721: SELECT party_site_id
4722: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4723: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4724: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4725: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4726: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4727: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
4728: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

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

4721: SELECT party_site_id
4722: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4723: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4724: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4725: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4726: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4727: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
4728: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
4729:

Line 4726: FROM HZ_PARTY_SITES, HZ_LOCATIONS

4722: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4723: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4724: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4725: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4726: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4727: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
4728: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
4729:
4730: I NUMBER;

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

4724: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4725: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4726: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4727: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
4728: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
4729:
4730: I NUMBER;
4731: J NUMBER:=1;
4732: l_party_site_id NUMBER;