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

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

Line 5951: FROM HZ_PARTY_SITES

5947: l_party_id := p_party_id;
5948: FOR PARTY_SITES IN (
5949: SELECT party_site_id FROM (
5950: SELECT party_site_id,identifying_address_flag
5951: FROM HZ_PARTY_SITES
5952: WHERE party_id = p_party_id
5953: AND (status is null OR status = 'A')
5954: AND identifying_address_flag='Y'
5955: UNION

Line 5958: FROM HZ_PARTY_SITES

5954: AND identifying_address_flag='Y'
5955: UNION
5956:
5957: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5958: FROM HZ_PARTY_SITES
5959: WHERE party_id = p_party_id
5960: AND (status is null OR status = 'A')
5961: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5962: AND ROWNUM<6

Line 5966: FROM HZ_PARTY_SITES

5962: AND ROWNUM<6
5963: UNION
5964:
5965: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5966: FROM HZ_PARTY_SITES
5967: WHERE (status is null OR status = 'A')
5968: AND party_id in (
5969: SELECT party_id
5970: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 6019: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6015: AND ROWNUM<6
6016: UNION
6017:
6018: SELECT CONTACT_POINT_ID
6019: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6020: WHERE PRIMARY_FLAG = 'Y'
6021: AND owner_table_name = 'HZ_PARTY_SITES'
6022: AND owner_table_id = party_site_id
6023: AND PARTY_ID = p_party_id

Line 6021: AND owner_table_name = 'HZ_PARTY_SITES'

6017:
6018: SELECT CONTACT_POINT_ID
6019: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6020: WHERE PRIMARY_FLAG = 'Y'
6021: AND owner_table_name = 'HZ_PARTY_SITES'
6022: AND owner_table_id = party_site_id
6023: AND PARTY_ID = p_party_id
6024: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
6025: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 6161: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6157: SELECT party_site_id
6158: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6159: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6160: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6161: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6162: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6163: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6164:
6165: I NUMBER;

Line 6162: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

6158: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6159: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6160: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6161: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6162: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6163: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6164:
6165: I NUMBER;
6166: J NUMBER:=1;

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

6159: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6160: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6161: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6162: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6163: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6164:
6165: I NUMBER;
6166: J NUMBER:=1;
6167: l_party_site_id NUMBER;