eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MATCH_RULE_40 dependencies on HZ_ORGANIZATION_PROFILES

Line 349: FROM HZ_ORGANIZATION_PROFILES

345: FROM HZ_PARTIES
346: WHERE party_id = p_record_id;
347: IF l_party_type = 'ORGANIZATION' THEN
348: SELECT DUNS_NUMBER_C INTO l_matched_value
349: FROM HZ_ORGANIZATION_PROFILES
350: WHERE party_id = p_record_id
351: and effective_end_date is null
352: and rownum = 1;
353: ELSIF l_party_type = 'PERSON' THEN

Line 355: FROM HZ_ORGANIZATION_PROFILES

351: and effective_end_date is null
352: and rownum = 1;
353: ELSIF l_party_type = 'PERSON' THEN
354: SELECT DUNS_NUMBER_C INTO l_matched_value
355: FROM HZ_ORGANIZATION_PROFILES
356: WHERE party_id = p_record_id
357: and rownum = 1;
358: END IF;
359: RETURN l_matched_value;

Line 368: FROM HZ_ORGANIZATION_PROFILES

364: FROM HZ_PARTIES
365: WHERE party_id = p_record_id;
366: IF l_party_type = 'ORGANIZATION' THEN
367: SELECT TAX_REFERENCE INTO l_matched_value
368: FROM HZ_ORGANIZATION_PROFILES
369: WHERE party_id = p_record_id
370: and effective_end_date is null
371: and rownum = 1;
372: ELSIF l_party_type = 'PERSON' THEN

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

5839: 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);
5840: END IF;
5841: IF l_party_type = 'ORGANIZATION' THEN
5842: SELECT
5843: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5844: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5845: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5846: INTO
5847: x_party_search_rec.DUNS_NUMBER_C

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

5841: IF l_party_type = 'ORGANIZATION' THEN
5842: SELECT
5843: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5844: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5845: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5846: INTO
5847: x_party_search_rec.DUNS_NUMBER_C
5848: ,x_party_search_rec.PARTY_TYPE
5849: ,x_party_search_rec.TAX_REFERENCE

Line 5850: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5846: INTO
5847: x_party_search_rec.DUNS_NUMBER_C
5848: ,x_party_search_rec.PARTY_TYPE
5849: ,x_party_search_rec.TAX_REFERENCE
5850: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5851: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5852: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5853: AND HZ_PARTIES.party_id = p_party_id;
5854: ELSIF l_party_type = 'PERSON' THEN

Line 5851: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5847: x_party_search_rec.DUNS_NUMBER_C
5848: ,x_party_search_rec.PARTY_TYPE
5849: ,x_party_search_rec.TAX_REFERENCE
5850: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5851: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5852: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5853: AND HZ_PARTIES.party_id = p_party_id;
5854: ELSIF l_party_type = 'PERSON' THEN
5855: SELECT

Line 5852: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5848: ,x_party_search_rec.PARTY_TYPE
5849: ,x_party_search_rec.TAX_REFERENCE
5850: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5851: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5852: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5853: AND HZ_PARTIES.party_id = p_party_id;
5854: ELSIF l_party_type = 'PERSON' THEN
5855: SELECT
5856: translate(HZ_PARTIES.PARTY_TYPE, '%',' ')