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

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

Line 5948: FROM HZ_PARTY_SITES

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

Line 5955: FROM HZ_PARTY_SITES

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

Line 5963: FROM HZ_PARTY_SITES

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

Line 6016: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

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

Line 6018: AND owner_table_name = 'HZ_PARTY_SITES'

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

Line 6153: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6149: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6150: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6151: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6152: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6153: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6154: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6155: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6156:
6157: I NUMBER;

Line 6154: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

6150: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6151: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6152: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6153: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6154: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6155: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6156:
6157: I NUMBER;
6158: J NUMBER:=1;

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

6151: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
6152: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6153: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6154: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6155: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6156:
6157: I NUMBER;
6158: J NUMBER:=1;
6159: l_party_site_id NUMBER;