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

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

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

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

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

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

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

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

3111: p_contact_ids HZ_PARTY_SEARCH.IDList;
3112: l_match_idx NUMBER;
3113: cursor get_cpts_for_party_sites is select contact_point_id
3114: from hz_contact_points
3115: where owner_table_name = 'HZ_PARTY_SITES'
3116: and primary_flag='Y'
3117: and owner_table_id = p_party_site_id;
3118: BEGIN
3119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4600: FROM HZ_PARTY_SITES

4596: l_party_id := p_party_id;
4597: FOR PARTY_SITES IN (
4598: SELECT party_site_id FROM (
4599: SELECT party_site_id,identifying_address_flag
4600: FROM HZ_PARTY_SITES
4601: WHERE party_id = p_party_id
4602: AND (status is null OR status = 'A')
4603: AND identifying_address_flag='Y'
4604: UNION

Line 4607: FROM HZ_PARTY_SITES

4603: AND identifying_address_flag='Y'
4604: UNION
4605:
4606: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
4607: FROM HZ_PARTY_SITES
4608: WHERE party_id = p_party_id
4609: AND (status is null OR status = 'A')
4610: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
4611: UNION

Line 4614: FROM HZ_PARTY_SITES

4610: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
4611: UNION
4612:
4613: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
4614: FROM HZ_PARTY_SITES
4615: WHERE (status is null OR status = 'A')
4616: AND party_id in (
4617: SELECT party_id
4618: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 4664: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

4660: and l_use_contact_info = 'Y'
4661: UNION
4662:
4663: SELECT CONTACT_POINT_ID
4664: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
4665: WHERE PRIMARY_FLAG = 'Y'
4666: AND owner_table_name = 'HZ_PARTY_SITES'
4667: AND owner_table_id = party_site_id
4668: AND PARTY_ID = p_party_id

Line 4666: AND owner_table_name = 'HZ_PARTY_SITES'

4662:
4663: SELECT CONTACT_POINT_ID
4664: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
4665: WHERE PRIMARY_FLAG = 'Y'
4666: AND owner_table_name = 'HZ_PARTY_SITES'
4667: AND owner_table_id = party_site_id
4668: AND PARTY_ID = p_party_id
4669: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
4670: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

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 4825: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

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;
4829: J NUMBER:=1;

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;