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 5455: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')

5451: 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);
5452: END IF;
5453: IF l_party_type = 'ORGANIZATION' THEN
5454: SELECT
5455: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5456: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5457: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5458: INTO
5459: x_party_search_rec.DUNS_NUMBER_C

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

5453: IF l_party_type = 'ORGANIZATION' THEN
5454: SELECT
5455: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5456: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5457: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5458: INTO
5459: x_party_search_rec.DUNS_NUMBER_C
5460: ,x_party_search_rec.PARTY_TYPE
5461: ,x_party_search_rec.TAX_REFERENCE

Line 5462: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5458: INTO
5459: x_party_search_rec.DUNS_NUMBER_C
5460: ,x_party_search_rec.PARTY_TYPE
5461: ,x_party_search_rec.TAX_REFERENCE
5462: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5463: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5464: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5465: AND HZ_PARTIES.party_id = p_party_id;
5466: ELSIF l_party_type = 'PERSON' THEN

Line 5463: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5459: x_party_search_rec.DUNS_NUMBER_C
5460: ,x_party_search_rec.PARTY_TYPE
5461: ,x_party_search_rec.TAX_REFERENCE
5462: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5463: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5464: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5465: AND HZ_PARTIES.party_id = p_party_id;
5466: ELSIF l_party_type = 'PERSON' THEN
5467: SELECT

Line 5464: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5460: ,x_party_search_rec.PARTY_TYPE
5461: ,x_party_search_rec.TAX_REFERENCE
5462: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5463: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5464: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5465: AND HZ_PARTIES.party_id = p_party_id;
5466: ELSIF l_party_type = 'PERSON' THEN
5467: SELECT
5468: translate(HZ_PARTIES.PARTY_TYPE, '%',' ')