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

Line 353: FROM HZ_ORGANIZATION_PROFILES

349: FROM HZ_PARTIES
350: WHERE party_id = p_record_id;
351: IF l_party_type = 'ORGANIZATION' THEN
352: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
353: FROM HZ_ORGANIZATION_PROFILES
354: WHERE party_id = p_record_id
355: and effective_end_date is null
356: and rownum = 1;
357: ELSIF l_party_type = 'PERSON' THEN

Line 4335: translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')

4331: 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);
4332: END IF;
4333: IF l_party_type = 'ORGANIZATION' THEN
4334: SELECT
4335: translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
4336: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
4337: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
4338: INTO
4339: x_party_search_rec.JGZZ_FISCAL_CODE

Line 4342: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

4338: INTO
4339: x_party_search_rec.JGZZ_FISCAL_CODE
4340: ,x_party_search_rec.PARTY_NAME
4341: ,x_party_search_rec.PARTY_TYPE
4342: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4343: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4344: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4345: AND HZ_PARTIES.party_id = p_party_id;
4346: ELSIF l_party_type = 'PERSON' THEN

Line 4343: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

4339: x_party_search_rec.JGZZ_FISCAL_CODE
4340: ,x_party_search_rec.PARTY_NAME
4341: ,x_party_search_rec.PARTY_TYPE
4342: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4343: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4344: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4345: AND HZ_PARTIES.party_id = p_party_id;
4346: ELSIF l_party_type = 'PERSON' THEN
4347: SELECT

Line 4344: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

4340: ,x_party_search_rec.PARTY_NAME
4341: ,x_party_search_rec.PARTY_TYPE
4342: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4343: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4344: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4345: AND HZ_PARTIES.party_id = p_party_id;
4346: ELSIF l_party_type = 'PERSON' THEN
4347: SELECT
4348: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')