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

Line 407: SELECT HZ_LOCATIONS.CITY

403: RETURN l_matched_value;
404: END IF;
405: IF p_attribute = 'CITY' THEN
406: BEGIN
407: SELECT HZ_LOCATIONS.CITY
408: INTO l_matched_value
409: FROM HZ_PARTY_SITES, HZ_LOCATIONS
410: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
411: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 409: FROM HZ_PARTY_SITES, HZ_LOCATIONS

405: IF p_attribute = 'CITY' THEN
406: BEGIN
407: SELECT HZ_LOCATIONS.CITY
408: INTO l_matched_value
409: FROM HZ_PARTY_SITES, HZ_LOCATIONS
410: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
411: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
412: EXCEPTION
413: WHEN NO_DATA_FOUND THEN

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

407: SELECT HZ_LOCATIONS.CITY
408: INTO l_matched_value
409: FROM HZ_PARTY_SITES, HZ_LOCATIONS
410: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
411: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
412: EXCEPTION
413: WHEN NO_DATA_FOUND THEN
414: l_matched_value := 'Err';
415: END;

Line 420: SELECT HZ_LOCATIONS.POSTAL_CODE

416: RETURN l_matched_value;
417: END IF;
418: IF p_attribute = 'POSTAL_CODE' THEN
419: BEGIN
420: SELECT HZ_LOCATIONS.POSTAL_CODE
421: INTO l_matched_value
422: FROM HZ_PARTY_SITES, HZ_LOCATIONS
423: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
424: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;

Line 422: FROM HZ_PARTY_SITES, HZ_LOCATIONS

418: IF p_attribute = 'POSTAL_CODE' THEN
419: BEGIN
420: SELECT HZ_LOCATIONS.POSTAL_CODE
421: INTO l_matched_value
422: FROM HZ_PARTY_SITES, HZ_LOCATIONS
423: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
424: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
425: EXCEPTION
426: WHEN NO_DATA_FOUND THEN

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

420: SELECT HZ_LOCATIONS.POSTAL_CODE
421: INTO l_matched_value
422: FROM HZ_PARTY_SITES, HZ_LOCATIONS
423: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
424: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
425: EXCEPTION
426: WHEN NO_DATA_FOUND THEN
427: l_matched_value := 'Err';
428: END;

Line 433: SELECT HZ_LOCATIONS.PROVINCE

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

Line 435: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

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

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

Line 446: SELECT HZ_LOCATIONS.STATE

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

Line 448: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

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

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

Line 459: SELECT HZ_LOCATIONS.COUNTY

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

Line 461: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

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

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

Line 472: SELECT HZ_LOCATIONS.COUNTRY

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

Line 474: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

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

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

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

5990: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5991: ) IS
5992: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5993: SELECT party_site_id
5994: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5995: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5996: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
5997: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5998: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')

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

5991: ) IS
5992: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5993: SELECT party_site_id
5994: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5995: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5996: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
5997: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5998: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
5999: ,translate(HZ_LOCATIONS.STATE, '%',' ')

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

5992: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5993: SELECT party_site_id
5994: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5995: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5996: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
5997: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5998: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
5999: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6000: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

5993: SELECT party_site_id
5994: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5995: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5996: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
5997: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5998: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
5999: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6000: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6001: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

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

5994: ,translate(HZ_LOCATIONS.CITY, '%',' ')
5995: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5996: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
5997: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5998: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
5999: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6000: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6001: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6002: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

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

5995: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
5996: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
5997: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5998: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
5999: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6000: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6001: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6002: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6003:

Line 6000: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5996: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
5997: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5998: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
5999: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6000: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6001: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6002: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6003:
6004: I NUMBER;

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

5998: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
5999: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6000: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6001: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6002: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6003:
6004: I NUMBER;
6005: J NUMBER:=1;
6006: l_party_site_id NUMBER;