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_39 dependencies on HZ_ORGANIZATION_PROFILES

Line 317: FROM HZ_ORGANIZATION_PROFILES

313: FROM HZ_PARTIES
314: WHERE party_id = p_record_id;
315: IF l_party_type = 'ORGANIZATION' THEN
316: SELECT DUNS_NUMBER_C INTO l_matched_value
317: FROM HZ_ORGANIZATION_PROFILES
318: WHERE party_id = p_record_id
319: and effective_end_date is null
320: and rownum = 1;
321: ELSIF l_party_type = 'PERSON' THEN

Line 323: FROM HZ_ORGANIZATION_PROFILES

319: and effective_end_date is null
320: and rownum = 1;
321: ELSIF l_party_type = 'PERSON' THEN
322: SELECT DUNS_NUMBER_C INTO l_matched_value
323: FROM HZ_ORGANIZATION_PROFILES
324: WHERE party_id = p_record_id
325: and rownum = 1;
326: END IF;
327: RETURN l_matched_value;

Line 336: FROM HZ_ORGANIZATION_PROFILES

332: FROM HZ_PARTIES
333: WHERE party_id = p_record_id;
334: IF l_party_type = 'ORGANIZATION' THEN
335: SELECT TAX_REFERENCE INTO l_matched_value
336: FROM HZ_ORGANIZATION_PROFILES
337: WHERE party_id = p_record_id
338: and effective_end_date is null
339: and rownum = 1;
340: ELSIF l_party_type = 'PERSON' THEN

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

5446: 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);
5447: END IF;
5448: IF l_party_type = 'ORGANIZATION' THEN
5449: SELECT
5450: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5451: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5452: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5453: INTO
5454: x_party_search_rec.DUNS_NUMBER_C

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

5448: IF l_party_type = 'ORGANIZATION' THEN
5449: SELECT
5450: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5451: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5452: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5453: INTO
5454: x_party_search_rec.DUNS_NUMBER_C
5455: ,x_party_search_rec.PARTY_TYPE
5456: ,x_party_search_rec.TAX_REFERENCE

Line 5457: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5453: INTO
5454: x_party_search_rec.DUNS_NUMBER_C
5455: ,x_party_search_rec.PARTY_TYPE
5456: ,x_party_search_rec.TAX_REFERENCE
5457: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5458: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5459: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5460: AND HZ_PARTIES.party_id = p_party_id;
5461: ELSIF l_party_type = 'PERSON' THEN

Line 5458: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5454: x_party_search_rec.DUNS_NUMBER_C
5455: ,x_party_search_rec.PARTY_TYPE
5456: ,x_party_search_rec.TAX_REFERENCE
5457: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5458: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5459: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5460: AND HZ_PARTIES.party_id = p_party_id;
5461: ELSIF l_party_type = 'PERSON' THEN
5462: SELECT

Line 5459: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5455: ,x_party_search_rec.PARTY_TYPE
5456: ,x_party_search_rec.TAX_REFERENCE
5457: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5458: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5459: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5460: AND HZ_PARTIES.party_id = p_party_id;
5461: ELSIF l_party_type = 'PERSON' THEN
5462: SELECT
5463: translate(HZ_PARTIES.PARTY_TYPE, '%',' ')