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

Line 560: FROM HZ_PARTY_SITES, HZ_LOCATIONS

556: IF p_attribute = 'CITY' THEN
557: BEGIN
558: SELECT HZ_LOCATIONS.CITY
559: INTO l_matched_value
560: FROM HZ_PARTY_SITES, HZ_LOCATIONS
561: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
562: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
563: EXCEPTION
564: WHEN NO_DATA_FOUND THEN

Line 561: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

557: BEGIN
558: SELECT HZ_LOCATIONS.CITY
559: INTO l_matched_value
560: FROM HZ_PARTY_SITES, HZ_LOCATIONS
561: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
562: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
563: EXCEPTION
564: WHEN NO_DATA_FOUND THEN
565: l_matched_value := 'Err';

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

558: SELECT HZ_LOCATIONS.CITY
559: INTO l_matched_value
560: FROM HZ_PARTY_SITES, HZ_LOCATIONS
561: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
562: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
563: EXCEPTION
564: WHEN NO_DATA_FOUND THEN
565: l_matched_value := 'Err';
566: END;

Line 573: FROM HZ_PARTY_SITES, HZ_LOCATIONS

569: IF p_attribute = 'POSTAL_CODE' THEN
570: BEGIN
571: SELECT HZ_LOCATIONS.POSTAL_CODE
572: INTO l_matched_value
573: FROM HZ_PARTY_SITES, HZ_LOCATIONS
574: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
575: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
576: EXCEPTION
577: WHEN NO_DATA_FOUND THEN

Line 574: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

570: BEGIN
571: SELECT HZ_LOCATIONS.POSTAL_CODE
572: INTO l_matched_value
573: FROM HZ_PARTY_SITES, HZ_LOCATIONS
574: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
575: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
576: EXCEPTION
577: WHEN NO_DATA_FOUND THEN
578: l_matched_value := 'Err';

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

571: SELECT HZ_LOCATIONS.POSTAL_CODE
572: INTO l_matched_value
573: FROM HZ_PARTY_SITES, HZ_LOCATIONS
574: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
575: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
576: EXCEPTION
577: WHEN NO_DATA_FOUND THEN
578: l_matched_value := 'Err';
579: END;

Line 586: FROM HZ_PARTY_SITES, HZ_LOCATIONS

582: IF p_attribute = 'STATE' THEN
583: BEGIN
584: SELECT HZ_LOCATIONS.STATE
585: INTO l_matched_value
586: FROM HZ_PARTY_SITES, HZ_LOCATIONS
587: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
588: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
589: EXCEPTION
590: WHEN NO_DATA_FOUND THEN

Line 587: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

583: BEGIN
584: SELECT HZ_LOCATIONS.STATE
585: INTO l_matched_value
586: FROM HZ_PARTY_SITES, HZ_LOCATIONS
587: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
588: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
589: EXCEPTION
590: WHEN NO_DATA_FOUND THEN
591: l_matched_value := 'Err';

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

584: SELECT HZ_LOCATIONS.STATE
585: INTO l_matched_value
586: FROM HZ_PARTY_SITES, HZ_LOCATIONS
587: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
588: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
589: EXCEPTION
590: WHEN NO_DATA_FOUND THEN
591: l_matched_value := 'Err';
592: END;

Line 599: FROM HZ_PARTY_SITES, HZ_LOCATIONS

595: IF p_attribute = 'COUNTRY' THEN
596: BEGIN
597: SELECT HZ_LOCATIONS.COUNTRY
598: INTO l_matched_value
599: FROM HZ_PARTY_SITES, HZ_LOCATIONS
600: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
601: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
602: EXCEPTION
603: WHEN NO_DATA_FOUND THEN

Line 600: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

596: BEGIN
597: SELECT HZ_LOCATIONS.COUNTRY
598: INTO l_matched_value
599: FROM HZ_PARTY_SITES, HZ_LOCATIONS
600: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
601: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
602: EXCEPTION
603: WHEN NO_DATA_FOUND THEN
604: l_matched_value := 'Err';

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

597: SELECT HZ_LOCATIONS.COUNTRY
598: INTO l_matched_value
599: FROM HZ_PARTY_SITES, HZ_LOCATIONS
600: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
601: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
602: EXCEPTION
603: WHEN NO_DATA_FOUND THEN
604: l_matched_value := 'Err';
605: END;

Line 4893: where owner_table_name = 'HZ_PARTY_SITES'

4889: p_contact_ids HZ_PARTY_SEARCH.IDList;
4890: l_match_idx NUMBER;
4891: cursor get_cpts_for_party_sites is select contact_point_id
4892: from hz_contact_points
4893: where owner_table_name = 'HZ_PARTY_SITES'
4894: and primary_flag='Y'
4895: and owner_table_id = p_party_site_id;
4896: BEGIN
4897: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6382: FROM HZ_PARTY_SITES

6378: l_party_id := p_party_id;
6379: FOR PARTY_SITES IN (
6380: SELECT party_site_id FROM (
6381: SELECT party_site_id,identifying_address_flag
6382: FROM HZ_PARTY_SITES
6383: WHERE party_id = p_party_id
6384: AND (status is null OR status = 'A')
6385: AND identifying_address_flag='Y'
6386: UNION

Line 6389: FROM HZ_PARTY_SITES

6385: AND identifying_address_flag='Y'
6386: UNION
6387:
6388: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
6389: FROM HZ_PARTY_SITES
6390: WHERE party_id = p_party_id
6391: AND (status is null OR status = 'A')
6392: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
6393: AND ROWNUM<6

Line 6397: FROM HZ_PARTY_SITES

6393: AND ROWNUM<6
6394: UNION
6395:
6396: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
6397: FROM HZ_PARTY_SITES
6398: WHERE (status is null OR status = 'A')
6399: AND party_id in (
6400: SELECT party_id
6401: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 6450: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6446: AND ROWNUM<6
6447: UNION
6448:
6449: SELECT CONTACT_POINT_ID
6450: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6451: WHERE PRIMARY_FLAG = 'Y'
6452: AND owner_table_name = 'HZ_PARTY_SITES'
6453: AND owner_table_id = party_site_id
6454: AND PARTY_ID = p_party_id

Line 6452: AND owner_table_name = 'HZ_PARTY_SITES'

6448:
6449: SELECT CONTACT_POINT_ID
6450: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6451: WHERE PRIMARY_FLAG = 'Y'
6452: AND owner_table_name = 'HZ_PARTY_SITES'
6453: AND owner_table_id = party_site_id
6454: AND PARTY_ID = p_party_id
6455: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
6456: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 6616: FROM HZ_PARTY_SITES, HZ_LOCATIONS

6612: ,translate(HZ_LOCATIONS.CITY, '%',' ')
6613: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6614: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6615: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6616: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6617: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6618: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6619:
6620: I NUMBER;

Line 6617: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

6613: ,translate(HZ_LOCATIONS.COUNTRY, '%',' ')
6614: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6615: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6616: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6617: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6618: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6619:
6620: I NUMBER;
6621: J NUMBER:=1;

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

6614: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
6615: ,translate(HZ_LOCATIONS.STATE, '%',' ')
6616: FROM HZ_PARTY_SITES, HZ_LOCATIONS
6617: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
6618: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
6619:
6620: I NUMBER;
6621: J NUMBER:=1;
6622: l_party_site_id NUMBER;