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

5281: p_contact_ids HZ_PARTY_SEARCH.IDList;
5282: l_match_idx NUMBER;
5283: cursor get_cpts_for_party_sites is select contact_point_id
5284: from hz_contact_points
5285: where owner_table_name = 'HZ_PARTY_SITES'
5286: and primary_flag='Y'
5287: and owner_table_id = p_party_site_id;
5288: BEGIN
5289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6842: FROM HZ_PARTY_SITES

6838: l_party_id := p_party_id;
6839: FOR PARTY_SITES IN (
6840: SELECT party_site_id FROM (
6841: SELECT party_site_id,identifying_address_flag
6842: FROM HZ_PARTY_SITES
6843: WHERE party_id = p_party_id
6844: AND (status is null OR status = 'A')
6845: AND identifying_address_flag='Y'
6846: UNION

Line 6849: FROM HZ_PARTY_SITES

6845: AND identifying_address_flag='Y'
6846: UNION
6847:
6848: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
6849: FROM HZ_PARTY_SITES
6850: WHERE party_id = p_party_id
6851: AND (status is null OR status = 'A')
6852: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
6853: AND ROWNUM<6

Line 6857: FROM HZ_PARTY_SITES

6853: AND ROWNUM<6
6854: UNION
6855:
6856: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
6857: FROM HZ_PARTY_SITES
6858: WHERE (status is null OR status = 'A')
6859: AND party_id in (
6860: SELECT party_id
6861: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 6897: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6893: AND ROWNUM<6
6894: UNION
6895:
6896: SELECT CONTACT_POINT_ID
6897: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6898: WHERE PRIMARY_FLAG = 'Y'
6899: AND owner_table_name = 'HZ_PARTY_SITES'
6900: AND owner_table_id = party_site_id
6901: AND PARTY_ID = p_party_id

Line 6899: AND owner_table_name = 'HZ_PARTY_SITES'

6895:
6896: SELECT CONTACT_POINT_ID
6897: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6898: WHERE PRIMARY_FLAG = 'Y'
6899: AND owner_table_name = 'HZ_PARTY_SITES'
6900: AND owner_table_id = party_site_id
6901: AND PARTY_ID = p_party_id
6902: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
6903: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 7073: FROM HZ_PARTY_SITES, HZ_LOCATIONS

7069: ,translate(HZ_LOCATIONS.COUNTY, '%',' ')
7070: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7071: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7072: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7073: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7074: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
7075: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
7076:
7077: I NUMBER;

Line 7074: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

7070: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
7071: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7072: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7073: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7074: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
7075: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
7076:
7077: I NUMBER;
7078: J NUMBER:=1;

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

7071: ,translate(HZ_LOCATIONS.PROVINCE, '%',' ')
7072: ,translate(HZ_LOCATIONS.STATE, '%',' ')
7073: FROM HZ_PARTY_SITES, HZ_LOCATIONS
7074: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
7075: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
7076:
7077: I NUMBER;
7078: J NUMBER:=1;
7079: l_party_site_id NUMBER;