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

Line 478: FROM HZ_ORGANIZATION_PROFILES

474: FROM HZ_PARTIES
475: WHERE party_id = p_record_id;
476: IF l_party_type = 'ORGANIZATION' THEN
477: SELECT TAX_REFERENCE INTO l_matched_value
478: FROM HZ_ORGANIZATION_PROFILES
479: WHERE party_id = p_record_id
480: and effective_end_date is null
481: and rownum = 1;
482: ELSIF l_party_type = 'PERSON' THEN

Line 498: FROM HZ_ORGANIZATION_PROFILES

494: FROM HZ_PARTIES
495: WHERE party_id = p_record_id;
496: IF l_party_type = 'ORGANIZATION' THEN
497: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
498: FROM HZ_ORGANIZATION_PROFILES
499: WHERE party_id = p_record_id
500: and effective_end_date is null
501: and rownum = 1;
502: ELSIF l_party_type = 'PERSON' THEN

Line 518: FROM HZ_ORGANIZATION_PROFILES

514: FROM HZ_PARTIES
515: WHERE party_id = p_record_id;
516: IF l_party_type = 'ORGANIZATION' THEN
517: SELECT SIC_CODE INTO l_matched_value
518: FROM HZ_ORGANIZATION_PROFILES
519: WHERE party_id = p_record_id
520: and effective_end_date is null
521: and rownum = 1;
522: ELSIF l_party_type = 'PERSON' THEN

Line 524: FROM HZ_ORGANIZATION_PROFILES

520: and effective_end_date is null
521: and rownum = 1;
522: ELSIF l_party_type = 'PERSON' THEN
523: SELECT SIC_CODE INTO l_matched_value
524: FROM HZ_ORGANIZATION_PROFILES
525: WHERE party_id = p_record_id
526: and rownum = 1;
527: END IF;
528: RETURN l_matched_value;

Line 537: FROM HZ_ORGANIZATION_PROFILES

533: FROM HZ_PARTIES
534: WHERE party_id = p_record_id;
535: IF l_party_type = 'ORGANIZATION' THEN
536: SELECT SIC_CODE_TYPE INTO l_matched_value
537: FROM HZ_ORGANIZATION_PROFILES
538: WHERE party_id = p_record_id
539: and effective_end_date is null
540: and rownum = 1;
541: ELSIF l_party_type = 'PERSON' THEN

Line 543: FROM HZ_ORGANIZATION_PROFILES

539: and effective_end_date is null
540: and rownum = 1;
541: ELSIF l_party_type = 'PERSON' THEN
542: SELECT SIC_CODE_TYPE INTO l_matched_value
543: FROM HZ_ORGANIZATION_PROFILES
544: WHERE party_id = p_record_id
545: and rownum = 1;
546: END IF;
547: RETURN l_matched_value;

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

6552: 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);
6553: END IF;
6554: IF l_party_type = 'ORGANIZATION' THEN
6555: SELECT
6556: translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6557: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6558: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6559: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6560: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')

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

6555: SELECT
6556: translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6557: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6558: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6559: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6560: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6561: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
6562: INTO
6563: x_party_search_rec.JGZZ_FISCAL_CODE

Line 6560: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')

6556: translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6557: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6558: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6559: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6560: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6561: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
6562: INTO
6563: x_party_search_rec.JGZZ_FISCAL_CODE
6564: ,x_party_search_rec.PARTY_NUMBER

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

6557: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6558: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6559: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6560: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6561: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
6562: INTO
6563: x_party_search_rec.JGZZ_FISCAL_CODE
6564: ,x_party_search_rec.PARTY_NUMBER
6565: ,x_party_search_rec.PARTY_TYPE

Line 6569: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

6565: ,x_party_search_rec.PARTY_TYPE
6566: ,x_party_search_rec.SIC_CODE
6567: ,x_party_search_rec.SIC_CODE_TYPE
6568: ,x_party_search_rec.TAX_REFERENCE
6569: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6570: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6571: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6572: AND HZ_PARTIES.party_id = p_party_id;
6573: ELSIF l_party_type = 'PERSON' THEN

Line 6570: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

6566: ,x_party_search_rec.SIC_CODE
6567: ,x_party_search_rec.SIC_CODE_TYPE
6568: ,x_party_search_rec.TAX_REFERENCE
6569: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6570: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6571: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6572: AND HZ_PARTIES.party_id = p_party_id;
6573: ELSIF l_party_type = 'PERSON' THEN
6574: SELECT

Line 6571: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

6567: ,x_party_search_rec.SIC_CODE_TYPE
6568: ,x_party_search_rec.TAX_REFERENCE
6569: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6570: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6571: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6572: AND HZ_PARTIES.party_id = p_party_id;
6573: ELSIF l_party_type = 'PERSON' THEN
6574: SELECT
6575: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')