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

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 410: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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
414: l_matched_value := 'Err';

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 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 423: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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
427: l_matched_value := 'Err';

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 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 436: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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
440: l_matched_value := 'Err';

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 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 449: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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
453: l_matched_value := 'Err';

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 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 462: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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
466: l_matched_value := 'Err';

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 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 475: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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
479: l_matched_value := 'Err';

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 4430: where owner_table_name = 'HZ_PARTY_SITES'

4426: p_contact_ids HZ_PARTY_SEARCH.IDList;
4427: l_match_idx NUMBER;
4428: cursor get_cpts_for_party_sites is select contact_point_id
4429: from hz_contact_points
4430: where owner_table_name = 'HZ_PARTY_SITES'
4431: and primary_flag='Y'
4432: and owner_table_id = p_party_site_id;
4433: BEGIN
4434: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5828: FROM HZ_PARTY_SITES

5824: l_party_id := p_party_id;
5825: FOR PARTY_SITES IN (
5826: SELECT party_site_id FROM (
5827: SELECT party_site_id,identifying_address_flag
5828: FROM HZ_PARTY_SITES
5829: WHERE party_id = p_party_id
5830: AND (status is null OR status = 'A')
5831: AND identifying_address_flag='Y'
5832: UNION

Line 5835: FROM HZ_PARTY_SITES

5831: AND identifying_address_flag='Y'
5832: UNION
5833:
5834: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5835: FROM HZ_PARTY_SITES
5836: WHERE party_id = p_party_id
5837: AND (status is null OR status = 'A')
5838: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5839: AND ROWNUM<6

Line 5843: FROM HZ_PARTY_SITES

5839: AND ROWNUM<6
5840: UNION
5841:
5842: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5843: FROM HZ_PARTY_SITES
5844: WHERE (status is null OR status = 'A')
5845: AND party_id in (
5846: SELECT party_id
5847: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5995: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5991: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
5992: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5993: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
5994: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5995: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5996: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5997: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5998:
5999: I NUMBER;

Line 5996: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5992: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5993: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
5994: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5995: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5996: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5997: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5998:
5999: I NUMBER;
6000: J NUMBER:=1;

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

5993: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
5994: ,translate(HZ_LOCATIONS.STATE, '%',' ')
5995: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5996: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5997: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5998:
5999: I NUMBER;
6000: J NUMBER:=1;
6001: l_party_site_id NUMBER;