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

Line 373: FROM HZ_ORGANIZATION_PROFILES

369: FROM HZ_PARTIES
370: WHERE party_id = p_record_id;
371: IF l_party_type = 'ORGANIZATION' THEN
372: SELECT DUNS_NUMBER_C INTO l_matched_value
373: FROM HZ_ORGANIZATION_PROFILES
374: WHERE party_id = p_record_id
375: and effective_end_date is null
376: and rownum = 1;
377: ELSIF l_party_type = 'PERSON' THEN

Line 379: FROM HZ_ORGANIZATION_PROFILES

375: and effective_end_date is null
376: and rownum = 1;
377: ELSIF l_party_type = 'PERSON' THEN
378: SELECT DUNS_NUMBER_C INTO l_matched_value
379: FROM HZ_ORGANIZATION_PROFILES
380: WHERE party_id = p_record_id
381: and rownum = 1;
382: END IF;
383: RETURN l_matched_value;

Line 410: FROM HZ_ORGANIZATION_PROFILES

406: FROM HZ_PARTIES
407: WHERE party_id = p_record_id;
408: IF l_party_type = 'ORGANIZATION' THEN
409: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
410: FROM HZ_ORGANIZATION_PROFILES
411: WHERE party_id = p_record_id
412: and effective_end_date is null
413: and rownum = 1;
414: ELSIF l_party_type = 'PERSON' THEN

Line 4667: HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C

4663: 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);
4664: END IF;
4665: IF l_party_type = 'ORGANIZATION' THEN
4666: SELECT
4667: HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C
4668: ,HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE
4669: ,HZ_PARTIES.PARTY_NAME
4670: ,HZ_PARTIES.PARTY_TYPE
4671: ,HZ_ORGANIZATION_PROFILES.SIC_CODE

Line 4668: ,HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE

4664: END IF;
4665: IF l_party_type = 'ORGANIZATION' THEN
4666: SELECT
4667: HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C
4668: ,HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE
4669: ,HZ_PARTIES.PARTY_NAME
4670: ,HZ_PARTIES.PARTY_TYPE
4671: ,HZ_ORGANIZATION_PROFILES.SIC_CODE
4672: INTO

Line 4671: ,HZ_ORGANIZATION_PROFILES.SIC_CODE

4667: HZ_ORGANIZATION_PROFILES.DUNS_NUMBER_C
4668: ,HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE
4669: ,HZ_PARTIES.PARTY_NAME
4670: ,HZ_PARTIES.PARTY_TYPE
4671: ,HZ_ORGANIZATION_PROFILES.SIC_CODE
4672: INTO
4673: x_party_search_rec.DUNS_NUMBER_C
4674: ,x_party_search_rec.JGZZ_FISCAL_CODE
4675: ,x_party_search_rec.PARTY_NAME

Line 4678: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

4674: ,x_party_search_rec.JGZZ_FISCAL_CODE
4675: ,x_party_search_rec.PARTY_NAME
4676: ,x_party_search_rec.PARTY_TYPE
4677: ,x_party_search_rec.SIC_CODE
4678: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4679: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4680: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4681: AND HZ_PARTIES.party_id = p_party_id;
4682: ELSIF l_party_type = 'PERSON' THEN

Line 4679: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

4675: ,x_party_search_rec.PARTY_NAME
4676: ,x_party_search_rec.PARTY_TYPE
4677: ,x_party_search_rec.SIC_CODE
4678: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4679: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4680: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4681: AND HZ_PARTIES.party_id = p_party_id;
4682: ELSIF l_party_type = 'PERSON' THEN
4683: SELECT

Line 4680: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

4676: ,x_party_search_rec.PARTY_TYPE
4677: ,x_party_search_rec.SIC_CODE
4678: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
4679: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
4680: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
4681: AND HZ_PARTIES.party_id = p_party_id;
4682: ELSIF l_party_type = 'PERSON' THEN
4683: SELECT
4684: HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE