APPS.HZ_MATCH_RULE_6 dependencies on HZ_ORGANIZATION_PROFILES

Line 371: FROM HZ_ORGANIZATION_PROFILES

367: FROM HZ_PARTIES
368: WHERE party_id = p_record_id;
369: IF l_party_type = 'ORGANIZATION' THEN
370: SELECT DUNS_NUMBER_C INTO l_matched_value
371: FROM HZ_ORGANIZATION_PROFILES
372: WHERE party_id = p_record_id
373: and effective_end_date is null
374: and rownum = 1;
375: ELSIF l_party_type = 'PERSON' THEN

Line 377: FROM HZ_ORGANIZATION_PROFILES

373: and effective_end_date is null
374: and rownum = 1;
375: ELSIF l_party_type = 'PERSON' THEN
376: SELECT DUNS_NUMBER_C INTO l_matched_value
377: FROM HZ_ORGANIZATION_PROFILES
378: WHERE party_id = p_record_id
379: and rownum = 1;
380: END IF;
381: RETURN l_matched_value;

Line 390: FROM HZ_ORGANIZATION_PROFILES

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

Line 428: FROM HZ_ORGANIZATION_PROFILES

424: FROM HZ_PARTIES
425: WHERE party_id = p_record_id;
426: IF l_party_type = 'ORGANIZATION' THEN
427: SELECT SIC_CODE INTO l_matched_value
428: FROM HZ_ORGANIZATION_PROFILES
429: WHERE party_id = p_record_id
430: and effective_end_date is null
431: and rownum = 1;
432: ELSIF l_party_type = 'PERSON' THEN

Line 434: FROM HZ_ORGANIZATION_PROFILES

430: and effective_end_date is null
431: and rownum = 1;
432: ELSIF l_party_type = 'PERSON' THEN
433: SELECT SIC_CODE INTO l_matched_value
434: FROM HZ_ORGANIZATION_PROFILES
435: WHERE party_id = p_record_id
436: and rownum = 1;
437: END IF;
438: RETURN l_matched_value;

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

5794: 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);
5795: END IF;
5796: IF l_party_type = 'ORGANIZATION' THEN
5797: SELECT
5798: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5799: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5800: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
5801: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5802: INTO

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

5796: IF l_party_type = 'ORGANIZATION' THEN
5797: SELECT
5798: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5799: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5800: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
5801: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5802: INTO
5803: x_party_search_rec.DUNS_NUMBER_C
5804: ,x_party_search_rec.PARTY_NAME

Line 5801: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')

5797: SELECT
5798: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5799: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5800: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
5801: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5802: INTO
5803: x_party_search_rec.DUNS_NUMBER_C
5804: ,x_party_search_rec.PARTY_NAME
5805: ,x_party_search_rec.SIC_CODE

Line 5807: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5803: x_party_search_rec.DUNS_NUMBER_C
5804: ,x_party_search_rec.PARTY_NAME
5805: ,x_party_search_rec.SIC_CODE
5806: ,x_party_search_rec.TAX_REFERENCE
5807: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5808: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5809: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5810: AND HZ_PARTIES.party_id = p_party_id;
5811: ELSIF l_party_type = 'PERSON' THEN

Line 5808: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5804: ,x_party_search_rec.PARTY_NAME
5805: ,x_party_search_rec.SIC_CODE
5806: ,x_party_search_rec.TAX_REFERENCE
5807: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5808: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5809: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5810: AND HZ_PARTIES.party_id = p_party_id;
5811: ELSIF l_party_type = 'PERSON' THEN
5812: SELECT

Line 5809: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5805: ,x_party_search_rec.SIC_CODE
5806: ,x_party_search_rec.TAX_REFERENCE
5807: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5808: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5809: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5810: AND HZ_PARTIES.party_id = p_party_id;
5811: ELSIF l_party_type = 'PERSON' THEN
5812: SELECT
5813: translate(HZ_PARTIES.PARTY_NAME, '%',' ')