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

Line 656: FROM HZ_PARTY_SITES, HZ_LOCATIONS

652: IF p_attribute = 'CITY' THEN
653: BEGIN
654: SELECT HZ_LOCATIONS.CITY
655: INTO l_matched_value
656: FROM HZ_PARTY_SITES, HZ_LOCATIONS
657: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
658: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
659: EXCEPTION
660: WHEN NO_DATA_FOUND THEN

Line 657: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

653: BEGIN
654: SELECT HZ_LOCATIONS.CITY
655: INTO l_matched_value
656: FROM HZ_PARTY_SITES, HZ_LOCATIONS
657: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
658: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
659: EXCEPTION
660: WHEN NO_DATA_FOUND THEN
661: l_matched_value := 'Err';

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

654: SELECT HZ_LOCATIONS.CITY
655: INTO l_matched_value
656: FROM HZ_PARTY_SITES, HZ_LOCATIONS
657: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
658: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
659: EXCEPTION
660: WHEN NO_DATA_FOUND THEN
661: l_matched_value := 'Err';
662: END;

Line 669: FROM HZ_PARTY_SITES, HZ_LOCATIONS

665: IF p_attribute = 'POSTAL_CODE' THEN
666: BEGIN
667: SELECT HZ_LOCATIONS.POSTAL_CODE
668: INTO l_matched_value
669: FROM HZ_PARTY_SITES, HZ_LOCATIONS
670: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
671: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
672: EXCEPTION
673: WHEN NO_DATA_FOUND THEN

Line 670: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

666: BEGIN
667: SELECT HZ_LOCATIONS.POSTAL_CODE
668: INTO l_matched_value
669: FROM HZ_PARTY_SITES, HZ_LOCATIONS
670: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
671: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
672: EXCEPTION
673: WHEN NO_DATA_FOUND THEN
674: l_matched_value := 'Err';

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

667: SELECT HZ_LOCATIONS.POSTAL_CODE
668: INTO l_matched_value
669: FROM HZ_PARTY_SITES, HZ_LOCATIONS
670: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
671: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
672: EXCEPTION
673: WHEN NO_DATA_FOUND THEN
674: l_matched_value := 'Err';
675: END;

Line 682: FROM HZ_PARTY_SITES, HZ_LOCATIONS

678: IF p_attribute = 'PROVINCE' THEN
679: BEGIN
680: SELECT HZ_LOCATIONS.PROVINCE
681: INTO l_matched_value
682: FROM HZ_PARTY_SITES, HZ_LOCATIONS
683: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
684: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
685: EXCEPTION
686: WHEN NO_DATA_FOUND THEN

Line 683: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

679: BEGIN
680: SELECT HZ_LOCATIONS.PROVINCE
681: INTO l_matched_value
682: FROM HZ_PARTY_SITES, HZ_LOCATIONS
683: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
684: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
685: EXCEPTION
686: WHEN NO_DATA_FOUND THEN
687: l_matched_value := 'Err';

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

680: SELECT HZ_LOCATIONS.PROVINCE
681: INTO l_matched_value
682: FROM HZ_PARTY_SITES, HZ_LOCATIONS
683: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
684: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
685: EXCEPTION
686: WHEN NO_DATA_FOUND THEN
687: l_matched_value := 'Err';
688: END;

Line 695: FROM HZ_PARTY_SITES, HZ_LOCATIONS

691: IF p_attribute = 'STATE' THEN
692: BEGIN
693: SELECT HZ_LOCATIONS.STATE
694: INTO l_matched_value
695: FROM HZ_PARTY_SITES, HZ_LOCATIONS
696: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
697: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
698: EXCEPTION
699: WHEN NO_DATA_FOUND THEN

Line 696: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

692: BEGIN
693: SELECT HZ_LOCATIONS.STATE
694: INTO l_matched_value
695: FROM HZ_PARTY_SITES, HZ_LOCATIONS
696: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
697: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
698: EXCEPTION
699: WHEN NO_DATA_FOUND THEN
700: l_matched_value := 'Err';

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

693: SELECT HZ_LOCATIONS.STATE
694: INTO l_matched_value
695: FROM HZ_PARTY_SITES, HZ_LOCATIONS
696: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
697: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
698: EXCEPTION
699: WHEN NO_DATA_FOUND THEN
700: l_matched_value := 'Err';
701: END;

Line 708: FROM HZ_PARTY_SITES, HZ_LOCATIONS

704: IF p_attribute = 'COUNTY' THEN
705: BEGIN
706: SELECT HZ_LOCATIONS.COUNTY
707: INTO l_matched_value
708: FROM HZ_PARTY_SITES, HZ_LOCATIONS
709: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
710: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
711: EXCEPTION
712: WHEN NO_DATA_FOUND THEN

Line 709: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

705: BEGIN
706: SELECT HZ_LOCATIONS.COUNTY
707: INTO l_matched_value
708: FROM HZ_PARTY_SITES, HZ_LOCATIONS
709: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
710: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
711: EXCEPTION
712: WHEN NO_DATA_FOUND THEN
713: l_matched_value := 'Err';

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

706: SELECT HZ_LOCATIONS.COUNTY
707: INTO l_matched_value
708: FROM HZ_PARTY_SITES, HZ_LOCATIONS
709: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
710: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
711: EXCEPTION
712: WHEN NO_DATA_FOUND THEN
713: l_matched_value := 'Err';
714: END;

Line 721: FROM HZ_PARTY_SITES, HZ_LOCATIONS

717: IF p_attribute = 'COUNTRY' THEN
718: BEGIN
719: SELECT HZ_LOCATIONS.COUNTRY
720: INTO l_matched_value
721: FROM HZ_PARTY_SITES, HZ_LOCATIONS
722: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
723: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
724: EXCEPTION
725: WHEN NO_DATA_FOUND THEN

Line 722: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

718: BEGIN
719: SELECT HZ_LOCATIONS.COUNTRY
720: INTO l_matched_value
721: FROM HZ_PARTY_SITES, HZ_LOCATIONS
722: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
723: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
724: EXCEPTION
725: WHEN NO_DATA_FOUND THEN
726: l_matched_value := 'Err';

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

719: SELECT HZ_LOCATIONS.COUNTRY
720: INTO l_matched_value
721: FROM HZ_PARTY_SITES, HZ_LOCATIONS
722: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
723: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
724: EXCEPTION
725: WHEN NO_DATA_FOUND THEN
726: l_matched_value := 'Err';
727: END;

Line 5277: where owner_table_name = 'HZ_PARTY_SITES'

5273: p_contact_ids HZ_PARTY_SEARCH.IDList;
5274: l_match_idx NUMBER;
5275: cursor get_cpts_for_party_sites is select contact_point_id
5276: from hz_contact_points
5277: where owner_table_name = 'HZ_PARTY_SITES'
5278: and primary_flag='Y'
5279: and owner_table_id = p_party_site_id;
5280: BEGIN
5281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6831: FROM HZ_PARTY_SITES

6827: l_party_id := p_party_id;
6828: FOR PARTY_SITES IN (
6829: SELECT party_site_id FROM (
6830: SELECT party_site_id,identifying_address_flag
6831: FROM HZ_PARTY_SITES
6832: WHERE party_id = p_party_id
6833: AND (status is null OR status = 'A')
6834: AND identifying_address_flag='Y'
6835: UNION

Line 6838: FROM HZ_PARTY_SITES

6834: AND identifying_address_flag='Y'
6835: UNION
6836:
6837: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
6838: FROM HZ_PARTY_SITES
6839: WHERE party_id = p_party_id
6840: AND (status is null OR status = 'A')
6841: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
6842: AND ROWNUM<6

Line 6846: FROM HZ_PARTY_SITES

6842: AND ROWNUM<6
6843: UNION
6844:
6845: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
6846: FROM HZ_PARTY_SITES
6847: WHERE (status is null OR status = 'A')
6848: AND party_id in (
6849: SELECT party_id
6850: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 6886: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6882: AND ROWNUM<6
6883: UNION
6884:
6885: SELECT CONTACT_POINT_ID
6886: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6887: WHERE PRIMARY_FLAG = 'Y'
6888: AND owner_table_name = 'HZ_PARTY_SITES'
6889: AND owner_table_id = party_site_id
6890: AND PARTY_ID = p_party_id

Line 6888: AND owner_table_name = 'HZ_PARTY_SITES'

6884:
6885: SELECT CONTACT_POINT_ID
6886: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6887: WHERE PRIMARY_FLAG = 'Y'
6888: AND owner_table_name = 'HZ_PARTY_SITES'
6889: AND owner_table_id = party_site_id
6890: AND PARTY_ID = p_party_id
6891: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
6892: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 7062: FROM HZ_PARTY_SITES, HZ_LOCATIONS

7058: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7059: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7060: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7061: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7062: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7063: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
7064: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
7065:
7066: I NUMBER;

Line 7063: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

7059: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7060: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7061: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7062: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7063: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
7064: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
7065:
7066: I NUMBER;
7067: J NUMBER:=1;

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

7060: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7061: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7062: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7063: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
7064: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
7065:
7066: I NUMBER;
7067: J NUMBER:=1;
7068: l_party_site_id NUMBER;