APPS.HZ_MATCH_RULE_7 dependencies on HZ_PARTY_SITES

Line 385: FROM HZ_PARTY_SITES, HZ_LOCATIONS

381: IF p_attribute = 'POSTAL_CODE' THEN
382: BEGIN
383: SELECT HZ_LOCATIONS.POSTAL_CODE
384: INTO l_matched_value
385: FROM HZ_PARTY_SITES, HZ_LOCATIONS
386: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
387: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
388: EXCEPTION
389: WHEN NO_DATA_FOUND THEN

Line 386: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

382: BEGIN
383: SELECT HZ_LOCATIONS.POSTAL_CODE
384: INTO l_matched_value
385: FROM HZ_PARTY_SITES, HZ_LOCATIONS
386: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
387: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
388: EXCEPTION
389: WHEN NO_DATA_FOUND THEN
390: l_matched_value := 'Err';

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

383: SELECT HZ_LOCATIONS.POSTAL_CODE
384: INTO l_matched_value
385: FROM HZ_PARTY_SITES, HZ_LOCATIONS
386: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
387: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
388: EXCEPTION
389: WHEN NO_DATA_FOUND THEN
390: l_matched_value := 'Err';
391: END;

Line 4064: where owner_table_name = 'HZ_PARTY_SITES'

4060: p_contact_ids HZ_PARTY_SEARCH.IDList;
4061: l_match_idx NUMBER;
4062: cursor get_cpts_for_party_sites is select contact_point_id
4063: from hz_contact_points
4064: where owner_table_name = 'HZ_PARTY_SITES'
4065: and primary_flag='Y'
4066: and owner_table_id = p_party_site_id;
4067: BEGIN
4068: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5450: FROM HZ_PARTY_SITES

5446: l_party_id := p_party_id;
5447: FOR PARTY_SITES IN (
5448: SELECT party_site_id FROM (
5449: SELECT party_site_id,identifying_address_flag
5450: FROM HZ_PARTY_SITES
5451: WHERE party_id = p_party_id
5452: AND (status is null OR status = 'A')
5453: AND identifying_address_flag='Y'
5454: UNION

Line 5457: FROM HZ_PARTY_SITES

5453: AND identifying_address_flag='Y'
5454: UNION
5455:
5456: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5457: FROM HZ_PARTY_SITES
5458: WHERE party_id = p_party_id
5459: AND (status is null OR status = 'A')
5460: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5461: AND ROWNUM<6

Line 5465: FROM HZ_PARTY_SITES

5461: AND ROWNUM<6
5462: UNION
5463:
5464: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5465: FROM HZ_PARTY_SITES
5466: WHERE (status is null OR status = 'A')
5467: AND party_id in (
5468: SELECT party_id
5469: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5505: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5501: AND ROWNUM<6
5502: UNION
5503:
5504: SELECT CONTACT_POINT_ID
5505: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5506: WHERE PRIMARY_FLAG = 'Y'
5507: AND owner_table_name = 'HZ_PARTY_SITES'
5508: AND owner_table_id = party_site_id
5509: AND PARTY_ID = p_party_id

Line 5507: AND owner_table_name = 'HZ_PARTY_SITES'

5503:
5504: SELECT CONTACT_POINT_ID
5505: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5506: WHERE PRIMARY_FLAG = 'Y'
5507: AND owner_table_name = 'HZ_PARTY_SITES'
5508: AND owner_table_id = party_site_id
5509: AND PARTY_ID = p_party_id
5510: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
5511: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 5648: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5644: ) IS
5645: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5646: SELECT party_site_id
5647: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5648: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5649: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5650: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5651:
5652: I NUMBER;

Line 5649: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5645: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5646: SELECT party_site_id
5647: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5648: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5649: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5650: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5651:
5652: I NUMBER;
5653: J NUMBER:=1;

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

5646: SELECT party_site_id
5647: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5648: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5649: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5650: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5651:
5652: I NUMBER;
5653: J NUMBER:=1;
5654: l_party_site_id NUMBER;