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

Line 397: FROM HZ_PARTY_SITES, HZ_LOCATIONS

393: IF p_attribute = 'CITY' THEN
394: BEGIN
395: SELECT HZ_LOCATIONS.CITY
396: INTO l_matched_value
397: FROM HZ_PARTY_SITES, HZ_LOCATIONS
398: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
399: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
400: EXCEPTION
401: WHEN NO_DATA_FOUND THEN

Line 398: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

394: BEGIN
395: SELECT HZ_LOCATIONS.CITY
396: INTO l_matched_value
397: FROM HZ_PARTY_SITES, HZ_LOCATIONS
398: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
399: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
400: EXCEPTION
401: WHEN NO_DATA_FOUND THEN
402: l_matched_value := 'Err';

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

395: SELECT HZ_LOCATIONS.CITY
396: INTO l_matched_value
397: FROM HZ_PARTY_SITES, HZ_LOCATIONS
398: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
399: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
400: EXCEPTION
401: WHEN NO_DATA_FOUND THEN
402: l_matched_value := 'Err';
403: END;

Line 410: FROM HZ_PARTY_SITES, HZ_LOCATIONS

406: IF p_attribute = 'POSTAL_CODE' THEN
407: BEGIN
408: SELECT HZ_LOCATIONS.POSTAL_CODE
409: INTO l_matched_value
410: FROM HZ_PARTY_SITES, HZ_LOCATIONS
411: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
412: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
413: EXCEPTION
414: WHEN NO_DATA_FOUND THEN

Line 411: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

407: BEGIN
408: SELECT HZ_LOCATIONS.POSTAL_CODE
409: INTO l_matched_value
410: FROM HZ_PARTY_SITES, HZ_LOCATIONS
411: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
412: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
413: EXCEPTION
414: WHEN NO_DATA_FOUND THEN
415: l_matched_value := 'Err';

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

408: SELECT HZ_LOCATIONS.POSTAL_CODE
409: INTO l_matched_value
410: FROM HZ_PARTY_SITES, HZ_LOCATIONS
411: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
412: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
413: EXCEPTION
414: WHEN NO_DATA_FOUND THEN
415: l_matched_value := 'Err';
416: END;

Line 423: FROM HZ_PARTY_SITES, HZ_LOCATIONS

419: IF p_attribute = 'PROVINCE' THEN
420: BEGIN
421: SELECT HZ_LOCATIONS.PROVINCE
422: INTO l_matched_value
423: FROM HZ_PARTY_SITES, HZ_LOCATIONS
424: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
425: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
426: EXCEPTION
427: WHEN NO_DATA_FOUND THEN

Line 424: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

420: BEGIN
421: SELECT HZ_LOCATIONS.PROVINCE
422: INTO l_matched_value
423: FROM HZ_PARTY_SITES, HZ_LOCATIONS
424: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
425: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
426: EXCEPTION
427: WHEN NO_DATA_FOUND THEN
428: l_matched_value := 'Err';

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

421: SELECT HZ_LOCATIONS.PROVINCE
422: INTO l_matched_value
423: FROM HZ_PARTY_SITES, HZ_LOCATIONS
424: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
425: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
426: EXCEPTION
427: WHEN NO_DATA_FOUND THEN
428: l_matched_value := 'Err';
429: END;

Line 436: FROM HZ_PARTY_SITES, HZ_LOCATIONS

432: IF p_attribute = 'STATE' THEN
433: BEGIN
434: SELECT HZ_LOCATIONS.STATE
435: INTO l_matched_value
436: FROM HZ_PARTY_SITES, HZ_LOCATIONS
437: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
438: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
439: EXCEPTION
440: WHEN NO_DATA_FOUND THEN

Line 437: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

433: BEGIN
434: SELECT HZ_LOCATIONS.STATE
435: INTO l_matched_value
436: FROM HZ_PARTY_SITES, HZ_LOCATIONS
437: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
438: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
439: EXCEPTION
440: WHEN NO_DATA_FOUND THEN
441: l_matched_value := 'Err';

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

434: SELECT HZ_LOCATIONS.STATE
435: INTO l_matched_value
436: FROM HZ_PARTY_SITES, HZ_LOCATIONS
437: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
438: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
439: EXCEPTION
440: WHEN NO_DATA_FOUND THEN
441: l_matched_value := 'Err';
442: END;

Line 449: FROM HZ_PARTY_SITES, HZ_LOCATIONS

445: IF p_attribute = 'COUNTRY' THEN
446: BEGIN
447: SELECT HZ_LOCATIONS.COUNTRY
448: INTO l_matched_value
449: FROM HZ_PARTY_SITES, HZ_LOCATIONS
450: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
451: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
452: EXCEPTION
453: WHEN NO_DATA_FOUND THEN

Line 450: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

446: BEGIN
447: SELECT HZ_LOCATIONS.COUNTRY
448: INTO l_matched_value
449: FROM HZ_PARTY_SITES, HZ_LOCATIONS
450: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
451: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
452: EXCEPTION
453: WHEN NO_DATA_FOUND THEN
454: l_matched_value := 'Err';

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

447: SELECT HZ_LOCATIONS.COUNTRY
448: INTO l_matched_value
449: FROM HZ_PARTY_SITES, HZ_LOCATIONS
450: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
451: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
452: EXCEPTION
453: WHEN NO_DATA_FOUND THEN
454: l_matched_value := 'Err';
455: END;

Line 4510: where owner_table_name = 'HZ_PARTY_SITES'

4506: p_contact_ids HZ_PARTY_SEARCH.IDList;
4507: l_match_idx NUMBER;
4508: cursor get_cpts_for_party_sites is select contact_point_id
4509: from hz_contact_points
4510: where owner_table_name = 'HZ_PARTY_SITES'
4511: and primary_flag='Y'
4512: and owner_table_id = p_party_site_id;
4513: BEGIN
4514: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5953: FROM HZ_PARTY_SITES

5949: l_party_id := p_party_id;
5950: FOR PARTY_SITES IN (
5951: SELECT party_site_id FROM (
5952: SELECT party_site_id,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='Y'
5957: UNION

Line 5960: FROM HZ_PARTY_SITES

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

Line 5968: FROM HZ_PARTY_SITES

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

Line 6021: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

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

Line 6023: AND owner_table_name = 'HZ_PARTY_SITES'

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

Line 6158: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

Line 6159: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

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

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

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