APPS.HZ_MATCH_RULE_6 dependencies on HZ_PARTY_SITES

Line 451: FROM HZ_PARTY_SITES, HZ_LOCATIONS

447: IF p_attribute = 'POSTAL_CODE' THEN
448: BEGIN
449: SELECT HZ_LOCATIONS.POSTAL_CODE
450: INTO l_matched_value
451: FROM HZ_PARTY_SITES, HZ_LOCATIONS
452: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
453: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN

Line 452: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

448: BEGIN
449: SELECT HZ_LOCATIONS.POSTAL_CODE
450: INTO l_matched_value
451: FROM HZ_PARTY_SITES, HZ_LOCATIONS
452: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
453: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN
456: l_matched_value := 'Err';

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

449: SELECT HZ_LOCATIONS.POSTAL_CODE
450: INTO l_matched_value
451: FROM HZ_PARTY_SITES, HZ_LOCATIONS
452: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
453: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN
456: l_matched_value := 'Err';
457: END;

Line 4244: where owner_table_name = 'HZ_PARTY_SITES'

4240: p_contact_ids HZ_PARTY_SEARCH.IDList;
4241: l_match_idx NUMBER;
4242: cursor get_cpts_for_party_sites is select contact_point_id
4243: from hz_contact_points
4244: where owner_table_name = 'HZ_PARTY_SITES'
4245: and primary_flag='Y'
4246: and owner_table_id = p_party_site_id;
4247: BEGIN
4248: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5629: FROM HZ_PARTY_SITES

5625: l_party_id := p_party_id;
5626: FOR PARTY_SITES IN (
5627: SELECT party_site_id FROM (
5628: SELECT party_site_id,identifying_address_flag
5629: FROM HZ_PARTY_SITES
5630: WHERE party_id = p_party_id
5631: AND (status is null OR status = 'A')
5632: AND identifying_address_flag='Y'
5633: UNION

Line 5636: FROM HZ_PARTY_SITES

5632: AND identifying_address_flag='Y'
5633: UNION
5634:
5635: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5636: FROM HZ_PARTY_SITES
5637: WHERE party_id = p_party_id
5638: AND (status is null OR status = 'A')
5639: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5640: AND ROWNUM<6

Line 5644: FROM HZ_PARTY_SITES

5640: AND ROWNUM<6
5641: UNION
5642:
5643: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5644: FROM HZ_PARTY_SITES
5645: WHERE (status is null OR status = 'A')
5646: AND party_id in (
5647: SELECT party_id
5648: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5697: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5693: AND ROWNUM<6
5694: UNION
5695:
5696: SELECT CONTACT_POINT_ID
5697: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5698: WHERE PRIMARY_FLAG = 'Y'
5699: AND owner_table_name = 'HZ_PARTY_SITES'
5700: AND owner_table_id = party_site_id
5701: AND PARTY_ID = p_party_id

Line 5699: AND owner_table_name = 'HZ_PARTY_SITES'

5695:
5696: SELECT CONTACT_POINT_ID
5697: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5698: WHERE PRIMARY_FLAG = 'Y'
5699: AND owner_table_name = 'HZ_PARTY_SITES'
5700: AND owner_table_id = party_site_id
5701: AND PARTY_ID = p_party_id
5702: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
5703: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 5850: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5846: ) IS
5847: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5848: SELECT party_site_id
5849: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5850: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5851: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5852: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5853:
5854: I NUMBER;

Line 5851: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5847: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5848: SELECT party_site_id
5849: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5850: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5851: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5852: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5853:
5854: I NUMBER;
5855: J NUMBER:=1;

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

5848: SELECT party_site_id
5849: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5850: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5851: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5852: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5853:
5854: I NUMBER;
5855: J NUMBER:=1;
5856: l_party_site_id NUMBER;