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

Line 329: FROM HZ_ORGANIZATION_PROFILES

325: FROM HZ_PARTIES
326: WHERE party_id = p_record_id;
327: IF l_party_type = 'ORGANIZATION' THEN
328: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
329: FROM HZ_ORGANIZATION_PROFILES
330: WHERE party_id = p_record_id
331: and effective_end_date is null
332: and rownum = 1;
333: ELSIF l_party_type = 'PERSON' THEN

Line 349: FROM HZ_ORGANIZATION_PROFILES

345: FROM HZ_PARTIES
346: WHERE party_id = p_record_id;
347: IF l_party_type = 'ORGANIZATION' THEN
348: SELECT SIC_CODE INTO l_matched_value
349: FROM HZ_ORGANIZATION_PROFILES
350: WHERE party_id = p_record_id
351: and effective_end_date is null
352: and rownum = 1;
353: ELSIF l_party_type = 'PERSON' THEN

Line 355: FROM HZ_ORGANIZATION_PROFILES

351: and effective_end_date is null
352: and rownum = 1;
353: ELSIF l_party_type = 'PERSON' THEN
354: SELECT SIC_CODE INTO l_matched_value
355: FROM HZ_ORGANIZATION_PROFILES
356: WHERE party_id = p_record_id
357: and rownum = 1;
358: END IF;
359: RETURN l_matched_value;

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

5673: 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);
5674: END IF;
5675: IF l_party_type = 'ORGANIZATION' THEN
5676: SELECT
5677: translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
5678: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5679: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
5680: INTO
5681: x_party_search_rec.JGZZ_FISCAL_CODE

Line 5679: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')

5675: IF l_party_type = 'ORGANIZATION' THEN
5676: SELECT
5677: translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
5678: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5679: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
5680: INTO
5681: x_party_search_rec.JGZZ_FISCAL_CODE
5682: ,x_party_search_rec.PARTY_NAME
5683: ,x_party_search_rec.SIC_CODE

Line 5684: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5680: INTO
5681: x_party_search_rec.JGZZ_FISCAL_CODE
5682: ,x_party_search_rec.PARTY_NAME
5683: ,x_party_search_rec.SIC_CODE
5684: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5685: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5686: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5687: AND HZ_PARTIES.party_id = p_party_id;
5688: ELSIF l_party_type = 'PERSON' THEN

Line 5685: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5681: x_party_search_rec.JGZZ_FISCAL_CODE
5682: ,x_party_search_rec.PARTY_NAME
5683: ,x_party_search_rec.SIC_CODE
5684: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5685: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5686: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5687: AND HZ_PARTIES.party_id = p_party_id;
5688: ELSIF l_party_type = 'PERSON' THEN
5689: SELECT

Line 5686: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5682: ,x_party_search_rec.PARTY_NAME
5683: ,x_party_search_rec.SIC_CODE
5684: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5685: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5686: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5687: AND HZ_PARTIES.party_id = p_party_id;
5688: ELSIF l_party_type = 'PERSON' THEN
5689: SELECT
5690: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')