APPS.HZ_MATCH_RULE_40 dependencies on HZ_PARTY_SITES

Line 392: FROM HZ_PARTY_SITES, HZ_LOCATIONS

388: IF p_attribute = 'POSTAL_CODE' THEN
389: BEGIN
390: SELECT HZ_LOCATIONS.POSTAL_CODE
391: INTO l_matched_value
392: FROM HZ_PARTY_SITES, HZ_LOCATIONS
393: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
394: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
395: EXCEPTION
396: WHEN NO_DATA_FOUND THEN

Line 393: WHERE HZ_PARTY_SITES.party_site_id = p_record_id

389: BEGIN
390: SELECT HZ_LOCATIONS.POSTAL_CODE
391: INTO l_matched_value
392: FROM HZ_PARTY_SITES, HZ_LOCATIONS
393: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
394: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
395: EXCEPTION
396: WHEN NO_DATA_FOUND THEN
397: l_matched_value := 'Err';

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

390: SELECT HZ_LOCATIONS.POSTAL_CODE
391: INTO l_matched_value
392: FROM HZ_PARTY_SITES, HZ_LOCATIONS
393: WHERE HZ_PARTY_SITES.party_site_id = p_record_id
394: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id and rownum=1;
395: EXCEPTION
396: WHEN NO_DATA_FOUND THEN
397: l_matched_value := 'Err';
398: END;

Line 4297: where owner_table_name = 'HZ_PARTY_SITES'

4293: p_contact_ids HZ_PARTY_SEARCH.IDList;
4294: l_match_idx NUMBER;
4295: cursor get_cpts_for_party_sites is select contact_point_id
4296: from hz_contact_points
4297: where owner_table_name = 'HZ_PARTY_SITES'
4298: and primary_flag='Y'
4299: and owner_table_id = p_party_site_id;
4300: BEGIN
4301: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5679: FROM HZ_PARTY_SITES

5675: l_party_id := p_party_id;
5676: FOR PARTY_SITES IN (
5677: SELECT party_site_id FROM (
5678: SELECT party_site_id,identifying_address_flag
5679: FROM HZ_PARTY_SITES
5680: WHERE party_id = p_party_id
5681: AND (status is null OR status = 'A')
5682: AND identifying_address_flag='Y'
5683: UNION

Line 5686: FROM HZ_PARTY_SITES

5682: AND identifying_address_flag='Y'
5683: UNION
5684:
5685: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5686: FROM HZ_PARTY_SITES
5687: WHERE party_id = p_party_id
5688: AND (status is null OR status = 'A')
5689: AND (identifying_address_flag IS NULL OR identifying_address_flag = 'N')
5690: AND ROWNUM<6

Line 5694: FROM HZ_PARTY_SITES

5690: AND ROWNUM<6
5691: UNION
5692:
5693: SELECT party_site_id,NVL(identifying_address_flag,'N') identifying_address_flag
5694: FROM HZ_PARTY_SITES
5695: WHERE (status is null OR status = 'A')
5696: AND party_id in (
5697: SELECT party_id
5698: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

Line 5747: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5743: AND ROWNUM<6
5744: UNION
5745:
5746: SELECT CONTACT_POINT_ID
5747: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5748: WHERE PRIMARY_FLAG = 'Y'
5749: AND owner_table_name = 'HZ_PARTY_SITES'
5750: AND owner_table_id = party_site_id
5751: AND PARTY_ID = p_party_id

Line 5749: AND owner_table_name = 'HZ_PARTY_SITES'

5745:
5746: SELECT CONTACT_POINT_ID
5747: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5748: WHERE PRIMARY_FLAG = 'Y'
5749: AND owner_table_name = 'HZ_PARTY_SITES'
5750: AND owner_table_id = party_site_id
5751: AND PARTY_ID = p_party_id
5752: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
5753: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 5900: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5896: ) IS
5897: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5898: SELECT party_site_id
5899: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5900: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5901: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5902: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5903:
5904: I NUMBER;

Line 5901: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5897: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5898: SELECT party_site_id
5899: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5900: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5901: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5902: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5903:
5904: I NUMBER;
5905: J NUMBER:=1;

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

5898: SELECT party_site_id
5899: ,translate(HZ_LOCATIONS.POSTAL_CODE, '%',' ')
5900: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5901: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5902: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5903:
5904: I NUMBER;
5905: J NUMBER:=1;
5906: l_party_site_id NUMBER;