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

Line 523: FROM HZ_ORGANIZATION_PROFILES

519: FROM HZ_PARTIES
520: WHERE party_id = p_record_id;
521: IF l_party_type = 'ORGANIZATION' THEN
522: SELECT TAX_NAME INTO l_matched_value
523: FROM HZ_ORGANIZATION_PROFILES
524: WHERE party_id = p_record_id
525: and effective_end_date is null
526: and rownum = 1;
527: ELSIF l_party_type = 'PERSON' THEN

Line 543: FROM HZ_ORGANIZATION_PROFILES

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

Line 563: FROM HZ_ORGANIZATION_PROFILES

559: FROM HZ_PARTIES
560: WHERE party_id = p_record_id;
561: IF l_party_type = 'ORGANIZATION' THEN
562: SELECT SIC_CODE INTO l_matched_value
563: FROM HZ_ORGANIZATION_PROFILES
564: WHERE party_id = p_record_id
565: and effective_end_date is null
566: and rownum = 1;
567: ELSIF l_party_type = 'PERSON' THEN

Line 569: FROM HZ_ORGANIZATION_PROFILES

565: and effective_end_date is null
566: and rownum = 1;
567: ELSIF l_party_type = 'PERSON' THEN
568: SELECT SIC_CODE INTO l_matched_value
569: FROM HZ_ORGANIZATION_PROFILES
570: WHERE party_id = p_record_id
571: and rownum = 1;
572: END IF;
573: RETURN l_matched_value;

Line 582: FROM HZ_ORGANIZATION_PROFILES

578: FROM HZ_PARTIES
579: WHERE party_id = p_record_id;
580: IF l_party_type = 'ORGANIZATION' THEN
581: SELECT SIC_CODE_TYPE INTO l_matched_value
582: FROM HZ_ORGANIZATION_PROFILES
583: WHERE party_id = p_record_id
584: and effective_end_date is null
585: and rownum = 1;
586: ELSIF l_party_type = 'PERSON' THEN

Line 588: FROM HZ_ORGANIZATION_PROFILES

584: and effective_end_date is null
585: and rownum = 1;
586: ELSIF l_party_type = 'PERSON' THEN
587: SELECT SIC_CODE_TYPE INTO l_matched_value
588: FROM HZ_ORGANIZATION_PROFILES
589: WHERE party_id = p_record_id
590: and rownum = 1;
591: END IF;
592: RETURN l_matched_value;

Line 637: FROM HZ_ORGANIZATION_PROFILES

633: FROM HZ_PARTIES
634: WHERE party_id = p_record_id;
635: IF l_party_type = 'ORGANIZATION' THEN
636: SELECT CORPORATION_CLASS INTO l_matched_value
637: FROM HZ_ORGANIZATION_PROFILES
638: WHERE party_id = p_record_id
639: and effective_end_date is null
640: and rownum = 1;
641: ELSIF l_party_type = 'PERSON' THEN

Line 643: FROM HZ_ORGANIZATION_PROFILES

639: and effective_end_date is null
640: and rownum = 1;
641: ELSIF l_party_type = 'PERSON' THEN
642: SELECT CORPORATION_CLASS INTO l_matched_value
643: FROM HZ_ORGANIZATION_PROFILES
644: WHERE party_id = p_record_id
645: and rownum = 1;
646: END IF;
647: RETURN l_matched_value;

Line 6993: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')

6989: END IF;
6990: IF l_party_type = 'ORGANIZATION' THEN
6991: SELECT
6992: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
6993: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6994: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6995: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6996: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6997: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')

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

6993: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6994: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6995: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6996: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6997: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6998: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6999: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
7000: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
7001: INTO

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

6994: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6995: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6996: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6997: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6998: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6999: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
7000: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
7001: INTO
7002: x_party_search_rec.CATEGORY_CODE

Line 6999: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')

6995: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6996: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6997: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6998: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6999: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
7000: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
7001: INTO
7002: x_party_search_rec.CATEGORY_CODE
7003: ,x_party_search_rec.CORPORATION_CLASS

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

6996: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6997: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6998: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6999: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
7000: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
7001: INTO
7002: x_party_search_rec.CATEGORY_CODE
7003: ,x_party_search_rec.CORPORATION_CLASS
7004: ,x_party_search_rec.PARTY_NUMBER

Line 7011: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

7007: ,x_party_search_rec.SIC_CODE
7008: ,x_party_search_rec.SIC_CODE_TYPE
7009: ,x_party_search_rec.TAX_NAME
7010: ,x_party_search_rec.TAX_REFERENCE
7011: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7012: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7013: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7014: AND HZ_PARTIES.party_id = p_party_id;
7015: ELSIF l_party_type = 'PERSON' THEN

Line 7012: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

7008: ,x_party_search_rec.SIC_CODE_TYPE
7009: ,x_party_search_rec.TAX_NAME
7010: ,x_party_search_rec.TAX_REFERENCE
7011: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7012: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7013: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7014: AND HZ_PARTIES.party_id = p_party_id;
7015: ELSIF l_party_type = 'PERSON' THEN
7016: SELECT

Line 7013: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

7009: ,x_party_search_rec.TAX_NAME
7010: ,x_party_search_rec.TAX_REFERENCE
7011: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7012: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7013: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7014: AND HZ_PARTIES.party_id = p_party_id;
7015: ELSIF l_party_type = 'PERSON' THEN
7016: SELECT
7017: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')