APPS.HZ_MATCH_RULE_50 dependencies on HZ_ORGANIZATION_PROFILES

Line 391: FROM HZ_ORGANIZATION_PROFILES

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

Line 397: FROM HZ_ORGANIZATION_PROFILES

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

Line 410: FROM HZ_ORGANIZATION_PROFILES

406: FROM HZ_PARTIES
407: WHERE party_id = p_record_id;
408: IF l_party_type = 'ORGANIZATION' THEN
409: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
410: FROM HZ_ORGANIZATION_PROFILES
411: WHERE party_id = p_record_id
412: and effective_end_date is null
413: and rownum = 1;
414: ELSIF l_party_type = 'PERSON' THEN

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

4663: 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);
4664: END IF;
4665: IF l_party_type = 'ORGANIZATION' THEN
4666: SELECT
4667: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
4668: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
4669: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
4670: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
4671: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')

Line 4668: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')

4664: END IF;
4665: IF l_party_type = 'ORGANIZATION' THEN
4666: SELECT
4667: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
4668: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
4669: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
4670: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
4671: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
4672: INTO

Line 4671: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')

4667: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
4668: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
4669: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
4670: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
4671: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
4672: INTO
4673: x_party_search_rec.DUNS_NUMBER_C
4674: ,x_party_search_rec.JGZZ_FISCAL_CODE
4675: ,x_party_search_rec.PARTY_NAME

Line 4678: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

4674: ,x_party_search_rec.JGZZ_FISCAL_CODE
4675: ,x_party_search_rec.PARTY_NAME
4676: ,x_party_search_rec.PARTY_TYPE
4677: ,x_party_search_rec.SIC_CODE
4678: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4679: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4680: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4681: AND HZ_PARTIES.party_id = p_party_id;
4682: ELSIF l_party_type = 'PERSON' THEN

Line 4679: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

4675: ,x_party_search_rec.PARTY_NAME
4676: ,x_party_search_rec.PARTY_TYPE
4677: ,x_party_search_rec.SIC_CODE
4678: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4679: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4680: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4681: AND HZ_PARTIES.party_id = p_party_id;
4682: ELSIF l_party_type = 'PERSON' THEN
4683: SELECT

Line 4680: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

4676: ,x_party_search_rec.PARTY_TYPE
4677: ,x_party_search_rec.SIC_CODE
4678: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4679: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4680: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4681: AND HZ_PARTIES.party_id = p_party_id;
4682: ELSIF l_party_type = 'PERSON' THEN
4683: SELECT
4684: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')