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

Line 321: FROM HZ_ORGANIZATION_PROFILES

317: FROM HZ_PARTIES
318: WHERE party_id = p_record_id;
319: IF l_party_type = 'ORGANIZATION' THEN
320: SELECT DUNS_NUMBER_C INTO l_matched_value
321: FROM HZ_ORGANIZATION_PROFILES
322: WHERE party_id = p_record_id
323: and effective_end_date is null
324: and rownum = 1;
325: ELSIF l_party_type = 'PERSON' THEN

Line 327: FROM HZ_ORGANIZATION_PROFILES

323: and effective_end_date is null
324: and rownum = 1;
325: ELSIF l_party_type = 'PERSON' THEN
326: SELECT DUNS_NUMBER_C INTO l_matched_value
327: FROM HZ_ORGANIZATION_PROFILES
328: WHERE party_id = p_record_id
329: and rownum = 1;
330: END IF;
331: RETURN l_matched_value;

Line 340: FROM HZ_ORGANIZATION_PROFILES

336: FROM HZ_PARTIES
337: WHERE party_id = p_record_id;
338: IF l_party_type = 'ORGANIZATION' THEN
339: SELECT TAX_REFERENCE INTO l_matched_value
340: FROM HZ_ORGANIZATION_PROFILES
341: WHERE party_id = p_record_id
342: and effective_end_date is null
343: and rownum = 1;
344: ELSIF l_party_type = 'PERSON' THEN

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

5354: 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);
5355: END IF;
5356: IF l_party_type = 'ORGANIZATION' THEN
5357: SELECT
5358: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5359: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5360: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5361: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5362: INTO

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

5357: SELECT
5358: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5359: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5360: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5361: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5362: INTO
5363: x_party_search_rec.DUNS_NUMBER_C
5364: ,x_party_search_rec.PARTY_NAME
5365: ,x_party_search_rec.PARTY_TYPE

Line 5367: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5363: x_party_search_rec.DUNS_NUMBER_C
5364: ,x_party_search_rec.PARTY_NAME
5365: ,x_party_search_rec.PARTY_TYPE
5366: ,x_party_search_rec.TAX_REFERENCE
5367: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5368: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5369: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5370: AND HZ_PARTIES.party_id = p_party_id;
5371: ELSIF l_party_type = 'PERSON' THEN

Line 5368: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5364: ,x_party_search_rec.PARTY_NAME
5365: ,x_party_search_rec.PARTY_TYPE
5366: ,x_party_search_rec.TAX_REFERENCE
5367: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5368: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5369: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5370: AND HZ_PARTIES.party_id = p_party_id;
5371: ELSIF l_party_type = 'PERSON' THEN
5372: SELECT

Line 5369: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5365: ,x_party_search_rec.PARTY_TYPE
5366: ,x_party_search_rec.TAX_REFERENCE
5367: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5368: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5369: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5370: AND HZ_PARTIES.party_id = p_party_id;
5371: ELSIF l_party_type = 'PERSON' THEN
5372: SELECT
5373: translate(HZ_PARTIES.PARTY_NAME, '%',' ')