APPS.HZ_MATCH_RULE_52 dependencies on HZ_ORGANIZATION_PROFILES

Line 400: FROM HZ_ORGANIZATION_PROFILES

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

Line 406: FROM HZ_ORGANIZATION_PROFILES

402: and effective_end_date is null
403: and rownum = 1;
404: ELSIF l_party_type = 'PERSON' THEN
405: SELECT DUNS_NUMBER_C INTO l_matched_value
406: FROM HZ_ORGANIZATION_PROFILES
407: WHERE party_id = p_record_id
408: and rownum = 1;
409: END IF;
410: RETURN l_matched_value;

Line 419: FROM HZ_ORGANIZATION_PROFILES

415: FROM HZ_PARTIES
416: WHERE party_id = p_record_id;
417: IF l_party_type = 'ORGANIZATION' THEN
418: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
419: FROM HZ_ORGANIZATION_PROFILES
420: WHERE party_id = p_record_id
421: and effective_end_date is null
422: and rownum = 1;
423: ELSIF l_party_type = 'PERSON' THEN

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

4761: 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);
4762: END IF;
4763: IF l_party_type = 'ORGANIZATION' THEN
4764: SELECT
4765: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
4766: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
4767: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
4768: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
4769: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')

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

4762: END IF;
4763: IF l_party_type = 'ORGANIZATION' THEN
4764: SELECT
4765: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
4766: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
4767: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
4768: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
4769: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
4770: INTO

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

4765: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
4766: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
4767: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
4768: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
4769: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
4770: INTO
4771: x_party_search_rec.DUNS_NUMBER_C
4772: ,x_party_search_rec.JGZZ_FISCAL_CODE
4773: ,x_party_search_rec.PARTY_NAME

Line 4776: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

4772: ,x_party_search_rec.JGZZ_FISCAL_CODE
4773: ,x_party_search_rec.PARTY_NAME
4774: ,x_party_search_rec.PARTY_TYPE
4775: ,x_party_search_rec.SIC_CODE
4776: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4777: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4778: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4779: AND HZ_PARTIES.party_id = p_party_id;
4780: ELSIF l_party_type = 'PERSON' THEN

Line 4777: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

4773: ,x_party_search_rec.PARTY_NAME
4774: ,x_party_search_rec.PARTY_TYPE
4775: ,x_party_search_rec.SIC_CODE
4776: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4777: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4778: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4779: AND HZ_PARTIES.party_id = p_party_id;
4780: ELSIF l_party_type = 'PERSON' THEN
4781: SELECT

Line 4778: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

4774: ,x_party_search_rec.PARTY_TYPE
4775: ,x_party_search_rec.SIC_CODE
4776: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4777: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4778: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4779: AND HZ_PARTIES.party_id = p_party_id;
4780: ELSIF l_party_type = 'PERSON' THEN
4781: SELECT
4782: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')