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.

[Home] [Help]

APPS.HZ_MATCH_RULE_52 dependencies on HZ_LOCATIONS

Line 441: SELECT HZ_LOCATIONS.CITY

437: RETURN l_matched_value;
438: END IF;
439: IF p_attribute = 'CITY' THEN
440: BEGIN
441: SELECT HZ_LOCATIONS.CITY
442: INTO l_matched_value
443: FROM HZ_PARTY_SITES, HZ_LOCATIONS
444: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
445: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 443: FROM HZ_PARTY_SITES, HZ_LOCATIONS

439: IF p_attribute = 'CITY' THEN
440: BEGIN
441: SELECT HZ_LOCATIONS.CITY
442: INTO l_matched_value
443: FROM HZ_PARTY_SITES, HZ_LOCATIONS
444: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
445: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
446: EXCEPTION
447: WHEN NO_DATA_FOUND THEN

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

441: SELECT HZ_LOCATIONS.CITY
442: INTO l_matched_value
443: FROM HZ_PARTY_SITES, HZ_LOCATIONS
444: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
445: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
446: EXCEPTION
447: WHEN NO_DATA_FOUND THEN
448: l_matched_value := 'Err';
449: END;

Line 454: SELECT HZ_LOCATIONS.STATE

450: RETURN l_matched_value;
451: END IF;
452: IF p_attribute = 'STATE' THEN
453: BEGIN
454: SELECT HZ_LOCATIONS.STATE
455: INTO l_matched_value
456: FROM HZ_PARTY_SITES, HZ_LOCATIONS
457: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
458: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 456: FROM HZ_PARTY_SITES, HZ_LOCATIONS

452: IF p_attribute = 'STATE' THEN
453: BEGIN
454: SELECT HZ_LOCATIONS.STATE
455: INTO l_matched_value
456: FROM HZ_PARTY_SITES, HZ_LOCATIONS
457: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
458: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
459: EXCEPTION
460: WHEN NO_DATA_FOUND THEN

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

454: SELECT HZ_LOCATIONS.STATE
455: INTO l_matched_value
456: FROM HZ_PARTY_SITES, HZ_LOCATIONS
457: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
458: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
459: EXCEPTION
460: WHEN NO_DATA_FOUND THEN
461: l_matched_value := 'Err';
462: END;

Line 467: SELECT HZ_LOCATIONS.COUNTRY

463: RETURN l_matched_value;
464: END IF;
465: IF p_attribute = 'COUNTRY' THEN
466: BEGIN
467: SELECT HZ_LOCATIONS.COUNTRY
468: INTO l_matched_value
469: FROM HZ_PARTY_SITES, HZ_LOCATIONS
470: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
471: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 469: FROM HZ_PARTY_SITES, HZ_LOCATIONS

465: IF p_attribute = 'COUNTRY' THEN
466: BEGIN
467: SELECT HZ_LOCATIONS.COUNTRY
468: INTO l_matched_value
469: FROM HZ_PARTY_SITES, HZ_LOCATIONS
470: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
471: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
472: EXCEPTION
473: WHEN NO_DATA_FOUND THEN

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

467: SELECT HZ_LOCATIONS.COUNTRY
468: INTO l_matched_value
469: FROM HZ_PARTY_SITES, HZ_LOCATIONS
470: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
471: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
472: EXCEPTION
473: WHEN NO_DATA_FOUND THEN
474: l_matched_value := 'Err';
475: END;

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

4816: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
4817: ) IS
4818: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
4819: SELECT party_site_id
4820: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4821: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4822: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4823: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4824: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

4817: ) IS
4818: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
4819: SELECT party_site_id
4820: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4821: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4822: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4823: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4824: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4825: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

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

4818: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
4819: SELECT party_site_id
4820: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4821: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4822: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4823: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4824: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4825: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
4826: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

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

4819: SELECT party_site_id
4820: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4821: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4822: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4823: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4824: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4825: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
4826: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
4827:

Line 4824: FROM HZ_PARTY_SITES, HZ_LOCATIONS

4820: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4821: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4822: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4823: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4824: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4825: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
4826: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
4827:
4828: I NUMBER;

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

4822: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4823: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4824: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4825: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
4826: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
4827:
4828: I NUMBER;
4829: J NUMBER:=1;
4830: l_party_site_id NUMBER;