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

Line 418: FROM HZ_PARTY_SITES, HZ_LOCATIONS

414: IF p_attribute = 'CITY' THEN
415: BEGIN
416: SELECT HZ_LOCATIONS.CITY
417: INTO l_matched_value
418: FROM HZ_PARTY_SITES, HZ_LOCATIONS
419: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
420: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
421: EXCEPTION
422: WHEN NO_DATA_FOUND THEN

Line 419: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

415: BEGIN
416: SELECT HZ_LOCATIONS.CITY
417: INTO l_matched_value
418: FROM HZ_PARTY_SITES, HZ_LOCATIONS
419: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
420: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
421: EXCEPTION
422: WHEN NO_DATA_FOUND THEN
423: l_matched_value := 'Err';

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

416: SELECT HZ_LOCATIONS.CITY
417: INTO l_matched_value
418: FROM HZ_PARTY_SITES, HZ_LOCATIONS
419: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
420: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
421: EXCEPTION
422: WHEN NO_DATA_FOUND THEN
423: l_matched_value := 'Err';
424: END;

Line 431: FROM HZ_PARTY_SITES, HZ_LOCATIONS

427: IF p_attribute = 'POSTAL_CODE' THEN
428: BEGIN
429: SELECT HZ_LOCATIONS.POSTAL_CODE
430: INTO l_matched_value
431: FROM HZ_PARTY_SITES, HZ_LOCATIONS
432: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
433: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
434: EXCEPTION
435: WHEN NO_DATA_FOUND THEN

Line 432: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

428: BEGIN
429: SELECT HZ_LOCATIONS.POSTAL_CODE
430: INTO l_matched_value
431: FROM HZ_PARTY_SITES, HZ_LOCATIONS
432: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
433: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
434: EXCEPTION
435: WHEN NO_DATA_FOUND THEN
436: l_matched_value := 'Err';

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

429: SELECT HZ_LOCATIONS.POSTAL_CODE
430: INTO l_matched_value
431: FROM HZ_PARTY_SITES, HZ_LOCATIONS
432: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
433: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
434: EXCEPTION
435: WHEN NO_DATA_FOUND THEN
436: l_matched_value := 'Err';
437: END;

Line 444: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

Line 445: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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

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

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

Line 4491: where owner_table_name = 'HZ_PARTY_SITES'

4487: p_contact_ids HZ_PARTY_SEARCH.IDList;
4488: l_match_idx NUMBER;
4489: cursor get_cpts_for_party_sites is select contact_point_id
4490: from hz_contact_points
4491: where owner_table_name = 'HZ_PARTY_SITES'
4492: and primary_flag='Y'
4493: and owner_table_id = p_party_site_id;
4494: BEGIN
4495: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5946: FROM HZ_PARTY_SITES

5942: l_party_id := p_party_id;
5943: FOR PARTY_SITES IN (
5944: SELECT party_site_id FROM (
5945: SELECT party_site_id,identifying_address_flag
5946: FROM HZ_PARTY_SITES
5947: WHERE party_id = p_party_id
5948: AND (status is null OR status = 'A')
5949: AND identifying_address_flag='Y'
5950: UNION

Line 5953: FROM HZ_PARTY_SITES

5949: AND identifying_address_flag='Y'
5950: UNION
5951:
5952: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5953: FROM HZ_PARTY_SITES
5954: WHERE party_id = p_party_id
5955: AND (status is null OR status = 'A')
5956: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5957: AND ROWNUM<6

Line 5961: FROM HZ_PARTY_SITES

5957: AND ROWNUM<6
5958: UNION
5959:
5960: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5961: FROM HZ_PARTY_SITES
5962: WHERE (status is null OR status = 'A')
5963: AND party_id in (
5964: SELECT party_id
5965: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 6014: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6010: AND ROWNUM<6
6011: UNION
6012:
6013: SELECT CONTACT_POINT_ID
6014: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6015: WHERE PRIMARY_FLAG = 'Y'
6016: AND owner_table_name = 'HZ_PARTY_SITES'
6017: AND owner_table_id = party_site_id
6018: AND PARTY_ID = p_party_id

Line 6016: AND owner_table_name = 'HZ_PARTY_SITES'

6012:
6013: SELECT CONTACT_POINT_ID
6014: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6015: WHERE PRIMARY_FLAG = 'Y'
6016: AND owner_table_name = 'HZ_PARTY_SITES'
6017: AND owner_table_id = party_site_id
6018: AND PARTY_ID = p_party_id
6019: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
6020: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 6156: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6152: SELECT party_site_id
6153: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6154: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6155: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6156: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6157: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6158: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6159:
6160: I NUMBER;

Line 6157: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

6153: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6154: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6155: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6156: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6157: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6158: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6159:
6160: I NUMBER;
6161: J NUMBER:=1;

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

6154: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6155: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6156: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6157: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6158: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6159:
6160: I NUMBER;
6161: J NUMBER:=1;
6162: l_party_site_id NUMBER;