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

Line 382: FROM HZ_ORGANIZATION_PROFILES

378: FROM HZ_PARTIES
379: WHERE party_id = p_record_id;
380: IF l_party_type = 'ORGANIZATION' THEN
381: SELECT DUNS_NUMBER_C INTO l_matched_value
382: FROM HZ_ORGANIZATION_PROFILES
383: WHERE party_id = p_record_id
384: and effective_end_date is null
385: and rownum = 1;
386: ELSIF l_party_type = 'PERSON' THEN

Line 388: FROM HZ_ORGANIZATION_PROFILES

384: and effective_end_date is null
385: and rownum = 1;
386: ELSIF l_party_type = 'PERSON' THEN
387: SELECT DUNS_NUMBER_C INTO l_matched_value
388: FROM HZ_ORGANIZATION_PROFILES
389: WHERE party_id = p_record_id
390: and rownum = 1;
391: END IF;
392: RETURN l_matched_value;

Line 419: FROM HZ_ORGANIZATION_PROFILES

415: FROM HZ_PARTIES
416: WHERE party_id = p_record_id;
417: IF l_party_type = 'ORGANIZATION' THEN
418: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
419: FROM HZ_ORGANIZATION_PROFILES
420: WHERE party_id = p_record_id
421: and effective_end_date is null
422: and rownum = 1;
423: ELSIF l_party_type = 'PERSON' THEN

Line 4765: HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C

4761: 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);
4762: END IF;
4763: IF l_party_type = 'ORGANIZATION' THEN
4764: SELECT
4765: HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C
4766: ,HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE
4767: ,HZ_PARTIES.PARTY_NAME
4768: ,HZ_PARTIES.PARTY_TYPE
4769: ,HZ_ORGANIZATION_PROFILES.SIC_CODE

Line 4766: ,HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE

4762: END IF;
4763: IF l_party_type = 'ORGANIZATION' THEN
4764: SELECT
4765: HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C
4766: ,HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE
4767: ,HZ_PARTIES.PARTY_NAME
4768: ,HZ_PARTIES.PARTY_TYPE
4769: ,HZ_ORGANIZATION_PROFILES.SIC_CODE
4770: INTO

Line 4769: ,HZ_ORGANIZATION_PROFILES.SIC_CODE

4765: HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C
4766: ,HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE
4767: ,HZ_PARTIES.PARTY_NAME
4768: ,HZ_PARTIES.PARTY_TYPE
4769: ,HZ_ORGANIZATION_PROFILES.SIC_CODE
4770: INTO
4771: x_party_search_rec.DUNS_NUMBER_C
4772: ,x_party_search_rec.JGZZ_FISCAL_CODE
4773: ,x_party_search_rec.PARTY_NAME

Line 4776: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

4772: ,x_party_search_rec.JGZZ_FISCAL_CODE
4773: ,x_party_search_rec.PARTY_NAME
4774: ,x_party_search_rec.PARTY_TYPE
4775: ,x_party_search_rec.SIC_CODE
4776: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4777: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4778: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4779: AND HZ_PARTIES.party_id = p_party_id;
4780: ELSIF l_party_type = 'PERSON' THEN

Line 4777: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

4773: ,x_party_search_rec.PARTY_NAME
4774: ,x_party_search_rec.PARTY_TYPE
4775: ,x_party_search_rec.SIC_CODE
4776: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4777: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4778: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4779: AND HZ_PARTIES.party_id = p_party_id;
4780: ELSIF l_party_type = 'PERSON' THEN
4781: SELECT

Line 4778: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

4774: ,x_party_search_rec.PARTY_TYPE
4775: ,x_party_search_rec.SIC_CODE
4776: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4777: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4778: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4779: AND HZ_PARTIES.party_id = p_party_id;
4780: ELSIF l_party_type = 'PERSON' THEN
4781: SELECT
4782: HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE