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

Line 462: SELECT HZ_LOCATIONS.CITY

458: RETURN l_matched_value;
459: END IF;
460: IF p_attribute = 'CITY' THEN
461: BEGIN
462: SELECT HZ_LOCATIONS.CITY
463: INTO l_matched_value
464: FROM HZ_PARTY_SITES, HZ_LOCATIONS
465: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
466: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 464: FROM HZ_PARTY_SITES, HZ_LOCATIONS

460: IF p_attribute = 'CITY' THEN
461: BEGIN
462: SELECT HZ_LOCATIONS.CITY
463: INTO l_matched_value
464: FROM HZ_PARTY_SITES, HZ_LOCATIONS
465: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
466: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
467: EXCEPTION
468: WHEN NO_DATA_FOUND THEN

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

462: SELECT HZ_LOCATIONS.CITY
463: INTO l_matched_value
464: FROM HZ_PARTY_SITES, HZ_LOCATIONS
465: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
466: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
467: EXCEPTION
468: WHEN NO_DATA_FOUND THEN
469: l_matched_value := 'Err';
470: END;

Line 475: SELECT HZ_LOCATIONS.POSTAL_CODE

471: RETURN l_matched_value;
472: END IF;
473: IF p_attribute = 'POSTAL_CODE' THEN
474: BEGIN
475: SELECT HZ_LOCATIONS.POSTAL_CODE
476: INTO l_matched_value
477: FROM HZ_PARTY_SITES, HZ_LOCATIONS
478: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
479: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 477: FROM HZ_PARTY_SITES, HZ_LOCATIONS

473: IF p_attribute = 'POSTAL_CODE' THEN
474: BEGIN
475: SELECT HZ_LOCATIONS.POSTAL_CODE
476: INTO l_matched_value
477: FROM HZ_PARTY_SITES, HZ_LOCATIONS
478: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
479: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
480: EXCEPTION
481: WHEN NO_DATA_FOUND THEN

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

475: SELECT HZ_LOCATIONS.POSTAL_CODE
476: INTO l_matched_value
477: FROM HZ_PARTY_SITES, HZ_LOCATIONS
478: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
479: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
480: EXCEPTION
481: WHEN NO_DATA_FOUND THEN
482: l_matched_value := 'Err';
483: END;

Line 488: SELECT HZ_LOCATIONS.STATE

484: RETURN l_matched_value;
485: END IF;
486: IF p_attribute = 'STATE' THEN
487: BEGIN
488: SELECT HZ_LOCATIONS.STATE
489: INTO l_matched_value
490: FROM HZ_PARTY_SITES, HZ_LOCATIONS
491: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
492: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 490: FROM HZ_PARTY_SITES, HZ_LOCATIONS

486: IF p_attribute = 'STATE' THEN
487: BEGIN
488: SELECT HZ_LOCATIONS.STATE
489: INTO l_matched_value
490: FROM HZ_PARTY_SITES, HZ_LOCATIONS
491: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
492: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
493: EXCEPTION
494: WHEN NO_DATA_FOUND THEN

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

488: SELECT HZ_LOCATIONS.STATE
489: INTO l_matched_value
490: FROM HZ_PARTY_SITES, HZ_LOCATIONS
491: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
492: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
493: EXCEPTION
494: WHEN NO_DATA_FOUND THEN
495: l_matched_value := 'Err';
496: END;

Line 503: FROM HZ_PARTY_SITES, HZ_LOCATIONS

499: IF p_attribute = 'PARTY_SITE_NUMBER' THEN
500: BEGIN
501: SELECT HZ_PARTY_SITES.PARTY_SITE_NUMBER
502: INTO l_matched_value
503: FROM HZ_PARTY_SITES, HZ_LOCATIONS
504: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
505: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
506: EXCEPTION
507: WHEN NO_DATA_FOUND THEN

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

501: SELECT HZ_PARTY_SITES.PARTY_SITE_NUMBER
502: INTO l_matched_value
503: FROM HZ_PARTY_SITES, HZ_LOCATIONS
504: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
505: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
506: EXCEPTION
507: WHEN NO_DATA_FOUND THEN
508: l_matched_value := 'Err';
509: END;

Line 514: SELECT HZ_LOCATIONS.COUNTRY

510: RETURN l_matched_value;
511: END IF;
512: IF p_attribute = 'COUNTRY' THEN
513: BEGIN
514: SELECT HZ_LOCATIONS.COUNTRY
515: INTO l_matched_value
516: FROM HZ_PARTY_SITES, HZ_LOCATIONS
517: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
518: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 516: FROM HZ_PARTY_SITES, HZ_LOCATIONS

512: IF p_attribute = 'COUNTRY' THEN
513: BEGIN
514: SELECT HZ_LOCATIONS.COUNTRY
515: INTO l_matched_value
516: FROM HZ_PARTY_SITES, HZ_LOCATIONS
517: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
518: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
519: EXCEPTION
520: WHEN NO_DATA_FOUND THEN

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

514: SELECT HZ_LOCATIONS.COUNTRY
515: INTO l_matched_value
516: FROM HZ_PARTY_SITES, HZ_LOCATIONS
517: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
518: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
519: EXCEPTION
520: WHEN NO_DATA_FOUND THEN
521: l_matched_value := 'Err';
522: END;

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

6392: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
6393: ) IS
6394: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6395: SELECT party_site_id
6396: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6397: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6398: ,translate(HZ_PARTY_SITES.PARTY_SITE_NUMBER, '%',' ')
6399: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6400: ,translate(HZ_LOCATIONS.STATE, '%',' ')

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

6393: ) IS
6394: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
6395: SELECT party_site_id
6396: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6397: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6398: ,translate(HZ_PARTY_SITES.PARTY_SITE_NUMBER, '%',' ')
6399: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6400: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6401: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

6395: SELECT party_site_id
6396: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6397: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6398: ,translate(HZ_PARTY_SITES.PARTY_SITE_NUMBER, '%',' ')
6399: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6400: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6401: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6402: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6403: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

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

6396: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6397: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6398: ,translate(HZ_PARTY_SITES.PARTY_SITE_NUMBER, '%',' ')
6399: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6400: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6401: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6402: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6403: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6404:

Line 6401: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6397: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6398: ,translate(HZ_PARTY_SITES.PARTY_SITE_NUMBER, '%',' ')
6399: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6400: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6401: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6402: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6403: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6404:
6405: I NUMBER;

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

6399: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6400: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6401: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6402: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6403: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6404:
6405: I NUMBER;
6406: J NUMBER:=1;
6407: l_party_site_id NUMBER;