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

Line 434: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

Line 435: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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

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

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

Line 447: FROM HZ_PARTY_SITES, HZ_LOCATIONS

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

Line 448: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

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

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

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

Line 460: FROM HZ_PARTY_SITES, HZ_LOCATIONS

456: IF p_attribute = 'COUNTRY' THEN
457: BEGIN
458: SELECT HZ_LOCATIONS.COUNTRY
459: INTO l_matched_value
460: FROM HZ_PARTY_SITES, HZ_LOCATIONS
461: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
462: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
463: EXCEPTION
464: WHEN NO_DATA_FOUND THEN

Line 461: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

457: BEGIN
458: SELECT HZ_LOCATIONS.COUNTRY
459: INTO l_matched_value
460: FROM HZ_PARTY_SITES, HZ_LOCATIONS
461: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
462: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
463: EXCEPTION
464: WHEN NO_DATA_FOUND THEN
465: l_matched_value := 'Err';

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

458: SELECT HZ_LOCATIONS.COUNTRY
459: INTO l_matched_value
460: FROM HZ_PARTY_SITES, HZ_LOCATIONS
461: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
462: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
463: EXCEPTION
464: WHEN NO_DATA_FOUND THEN
465: l_matched_value := 'Err';
466: END;

Line 3047: where owner_table_name = 'HZ_PARTY_SITES'

3043: p_contact_ids HZ_PARTY_SEARCH.IDList;
3044: l_match_idx NUMBER;
3045: cursor get_cpts_for_party_sites is select contact_point_id
3046: from hz_contact_points
3047: where owner_table_name = 'HZ_PARTY_SITES'
3048: and primary_flag='Y'
3049: and owner_table_id = p_party_site_id;
3050: BEGIN
3051: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4502: FROM HZ_PARTY_SITES

4498: l_party_id := p_party_id;
4499: FOR PARTY_SITES IN (
4500: SELECT party_site_id FROM (
4501: SELECT party_site_id,identifying_address_flag
4502: FROM HZ_PARTY_SITES
4503: WHERE party_id = p_party_id
4504: AND (status is null OR status = 'A')
4505: AND identifying_address_flag='Y'
4506: UNION

Line 4509: FROM HZ_PARTY_SITES

4505: AND identifying_address_flag='Y'
4506: UNION
4507:
4508: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
4509: FROM HZ_PARTY_SITES
4510: WHERE party_id = p_party_id
4511: AND (status is null OR status = 'A')
4512: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
4513: UNION

Line 4516: FROM HZ_PARTY_SITES

4512: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
4513: UNION
4514:
4515: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
4516: FROM HZ_PARTY_SITES
4517: WHERE (status is null OR status = 'A')
4518: AND party_id in (
4519: SELECT party_id
4520: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 4566: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

4562: and l_use_contact_info = 'Y'
4563: UNION
4564:
4565: SELECT CONTACT_POINT_ID
4566: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
4567: WHERE PRIMARY_FLAG = 'Y'
4568: AND owner_table_name = 'HZ_PARTY_SITES'
4569: AND owner_table_id = party_site_id
4570: AND PARTY_ID = p_party_id

Line 4568: AND owner_table_name = 'HZ_PARTY_SITES'

4564:
4565: SELECT CONTACT_POINT_ID
4566: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
4567: WHERE PRIMARY_FLAG = 'Y'
4568: AND owner_table_name = 'HZ_PARTY_SITES'
4569: AND owner_table_id = party_site_id
4570: AND PARTY_ID = p_party_id
4571: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
4572: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 4726: FROM HZ_PARTY_SITES, HZ_LOCATIONS

4722: ,translate(HZ_LOCATIONS.CITY, '%',' ')
4723: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4724: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4725: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4726: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4727: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
4728: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
4729:
4730: I NUMBER;

Line 4727: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

4723: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
4724: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4725: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4726: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4727: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
4728: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
4729:
4730: I NUMBER;
4731: J NUMBER:=1;

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

4724: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
4725: ,translate(HZ_LOCATIONS.STATE, '%',' ')
4726: FROM HZ_PARTY_SITES, HZ_LOCATIONS
4727: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
4728: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
4729:
4730: I NUMBER;
4731: J NUMBER:=1;
4732: l_party_site_id NUMBER;