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 339: FROM HZ_ORGANIZATION_PROFILES

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

Line 345: FROM HZ_ORGANIZATION_PROFILES

341: and effective_end_date is null
342: and rownum = 1;
343: ELSIF l_party_type = 'PERSON' THEN
344: SELECT DUNS_NUMBER_C INTO l_matched_value
345: FROM HZ_ORGANIZATION_PROFILES
346: WHERE party_id = p_record_id
347: and rownum = 1;
348: END IF;
349: RETURN l_matched_value;

Line 358: FROM HZ_ORGANIZATION_PROFILES

354: FROM HZ_PARTIES
355: WHERE party_id = p_record_id;
356: IF l_party_type = 'ORGANIZATION' THEN
357: SELECT TAX_REFERENCE INTO l_matched_value
358: FROM HZ_ORGANIZATION_PROFILES
359: WHERE party_id = p_record_id
360: and effective_end_date is null
361: and rownum = 1;
362: ELSIF l_party_type = 'PERSON' THEN

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

5359: 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);
5360: END IF;
5361: IF l_party_type = 'ORGANIZATION' THEN
5362: SELECT
5363: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5364: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5365: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5366: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5367: INTO

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

5362: SELECT
5363: translate(HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C, '%',' ')
5364: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5365: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
5366: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5367: INTO
5368: x_party_search_rec.DUNS_NUMBER_C
5369: ,x_party_search_rec.PARTY_NAME
5370: ,x_party_search_rec.PARTY_TYPE

Line 5372: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5368: x_party_search_rec.DUNS_NUMBER_C
5369: ,x_party_search_rec.PARTY_NAME
5370: ,x_party_search_rec.PARTY_TYPE
5371: ,x_party_search_rec.TAX_REFERENCE
5372: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5373: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5374: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5375: AND HZ_PARTIES.party_id = p_party_id;
5376: ELSIF l_party_type = 'PERSON' THEN

Line 5373: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5369: ,x_party_search_rec.PARTY_NAME
5370: ,x_party_search_rec.PARTY_TYPE
5371: ,x_party_search_rec.TAX_REFERENCE
5372: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5373: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5374: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5375: AND HZ_PARTIES.party_id = p_party_id;
5376: ELSIF l_party_type = 'PERSON' THEN
5377: SELECT

Line 5374: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5370: ,x_party_search_rec.PARTY_TYPE
5371: ,x_party_search_rec.TAX_REFERENCE
5372: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5373: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5374: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5375: AND HZ_PARTIES.party_id = p_party_id;
5376: ELSIF l_party_type = 'PERSON' THEN
5377: SELECT
5378: translate(HZ_PARTIES.PARTY_NAME, '%',' ')