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

Line 445: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

Line 446: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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

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

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

Line 458: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

Line 459: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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

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

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

Line 471: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

Line 472: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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

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

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

Line 484: FROM HZ_PARTY_SITES, HZ_LOCATIONS

480: IF p_attribute = 'COUNTRY' THEN
481: BEGIN
482: SELECT HZ_LOCATIONS.COUNTRY
483: INTO l_matched_value
484: FROM HZ_PARTY_SITES, HZ_LOCATIONS
485: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
486: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
487: EXCEPTION
488: WHEN NO_DATA_FOUND THEN

Line 485: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

481: BEGIN
482: SELECT HZ_LOCATIONS.COUNTRY
483: INTO l_matched_value
484: FROM HZ_PARTY_SITES, HZ_LOCATIONS
485: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
486: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
487: EXCEPTION
488: WHEN NO_DATA_FOUND THEN
489: l_matched_value := 'Err';

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

482: SELECT HZ_LOCATIONS.COUNTRY
483: INTO l_matched_value
484: FROM HZ_PARTY_SITES, HZ_LOCATIONS
485: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
486: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
487: EXCEPTION
488: WHEN NO_DATA_FOUND THEN
489: l_matched_value := 'Err';
490: END;

Line 4504: where owner_table_name = 'HZ_PARTY_SITES'

4500: p_contact_ids HZ_PARTY_SEARCH.IDList;
4501: l_match_idx NUMBER;
4502: cursor get_cpts_for_party_sites is select contact_point_id
4503: from hz_contact_points
4504: where owner_table_name = 'HZ_PARTY_SITES'
4505: and primary_flag='Y'
4506: and owner_table_id = p_party_site_id;
4507: BEGIN
4508: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5897: FROM HZ_PARTY_SITES

5893: l_party_id := p_party_id;
5894: FOR PARTY_SITES IN (
5895: SELECT party_site_id FROM (
5896: SELECT party_site_id,identifying_address_flag
5897: FROM HZ_PARTY_SITES
5898: WHERE party_id = p_party_id
5899: AND (status is null OR status = 'A')
5900: AND identifying_address_flag='Y'
5901: UNION

Line 5904: FROM HZ_PARTY_SITES

5900: AND identifying_address_flag='Y'
5901: UNION
5902:
5903: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5904: FROM HZ_PARTY_SITES
5905: WHERE party_id = p_party_id
5906: AND (status is null OR status = 'A')
5907: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5908: AND ROWNUM<6

Line 5912: FROM HZ_PARTY_SITES

5908: AND ROWNUM<6
5909: UNION
5910:
5911: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5912: FROM HZ_PARTY_SITES
5913: WHERE (status is null OR status = 'A')
5914: AND party_id in (
5915: SELECT party_id
5916: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 6064: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6060: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6061: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6062: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6063: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6064: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6065: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6066: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6067:
6068: I NUMBER;

Line 6065: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

6061: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6062: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6063: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6064: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6065: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6066: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6067:
6068: I NUMBER;
6069: J NUMBER:=1;

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

6062: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6063: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6064: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6065: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6066: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6067:
6068: I NUMBER;
6069: J NUMBER:=1;
6070: l_party_site_id NUMBER;