APPS.HZ_MATCH_RULE_53 dependencies on HZ_ORGANIZATION_PROFILES

Line 394: FROM HZ_ORGANIZATION_PROFILES

390: FROM HZ_PARTIES
391: WHERE party_id = p_record_id;
392: IF l_party_type = 'ORGANIZATION' THEN
393: SELECT DUNS_NUMBER_C INTO l_matched_value
394: FROM HZ_ORGANIZATION_PROFILES
395: WHERE party_id = p_record_id
396: and effective_end_date is null
397: and rownum = 1;
398: ELSIF l_party_type = 'PERSON' THEN

Line 400: FROM HZ_ORGANIZATION_PROFILES

396: and effective_end_date is null
397: and rownum = 1;
398: ELSIF l_party_type = 'PERSON' THEN
399: SELECT DUNS_NUMBER_C INTO l_matched_value
400: FROM HZ_ORGANIZATION_PROFILES
401: WHERE party_id = p_record_id
402: and rownum = 1;
403: END IF;
404: RETURN l_matched_value;

Line 5998: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')

5994: hz_utility_v2pub.debug(p_message=>'l_party_type is - '||l_party_type,p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
5995: END IF;
5996: IF l_party_type = 'ORGANIZATION' THEN
5997: SELECT
5998: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5999: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6000: INTO
6001: x_party_search_rec.DUNS_NUMBER_C
6002: ,x_party_search_rec.PARTY_NUMBER

Line 6003: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5999: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6000: INTO
6001: x_party_search_rec.DUNS_NUMBER_C
6002: ,x_party_search_rec.PARTY_NUMBER
6003: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6004: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6005: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6006: AND HZ_PARTIES.party_id = p_party_id;
6007: ELSIF l_party_type = 'PERSON' THEN

Line 6004: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

6000: INTO
6001: x_party_search_rec.DUNS_NUMBER_C
6002: ,x_party_search_rec.PARTY_NUMBER
6003: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6004: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6005: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6006: AND HZ_PARTIES.party_id = p_party_id;
6007: ELSIF l_party_type = 'PERSON' THEN
6008: SELECT

Line 6005: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

6001: x_party_search_rec.DUNS_NUMBER_C
6002: ,x_party_search_rec.PARTY_NUMBER
6003: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6004: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6005: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6006: AND HZ_PARTIES.party_id = p_party_id;
6007: ELSIF l_party_type = 'PERSON' THEN
6008: SELECT
6009: translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')