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

Line 463: FROM HZ_ORGANIZATION_PROFILES

459: FROM HZ_PARTIES
460: WHERE party_id = p_record_id;
461: IF l_party_type = 'ORGANIZATION' THEN
462: SELECT TAX_NAME INTO l_matched_value
463: FROM HZ_ORGANIZATION_PROFILES
464: WHERE party_id = p_record_id
465: and effective_end_date is null
466: and rownum = 1;
467: ELSIF l_party_type = 'PERSON' THEN

Line 483: FROM HZ_ORGANIZATION_PROFILES

479: FROM HZ_PARTIES
480: WHERE party_id = p_record_id;
481: IF l_party_type = 'ORGANIZATION' THEN
482: SELECT TAX_REFERENCE INTO l_matched_value
483: FROM HZ_ORGANIZATION_PROFILES
484: WHERE party_id = p_record_id
485: and effective_end_date is null
486: and rownum = 1;
487: ELSIF l_party_type = 'PERSON' THEN

Line 531: FROM HZ_ORGANIZATION_PROFILES

527: FROM HZ_PARTIES
528: WHERE party_id = p_record_id;
529: IF l_party_type = 'ORGANIZATION' THEN
530: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
531: FROM HZ_ORGANIZATION_PROFILES
532: WHERE party_id = p_record_id
533: and effective_end_date is null
534: and rownum = 1;
535: ELSIF l_party_type = 'PERSON' THEN

Line 551: FROM HZ_ORGANIZATION_PROFILES

547: FROM HZ_PARTIES
548: WHERE party_id = p_record_id;
549: IF l_party_type = 'ORGANIZATION' THEN
550: SELECT SIC_CODE INTO l_matched_value
551: FROM HZ_ORGANIZATION_PROFILES
552: WHERE party_id = p_record_id
553: and effective_end_date is null
554: and rownum = 1;
555: ELSIF l_party_type = 'PERSON' THEN

Line 557: FROM HZ_ORGANIZATION_PROFILES

553: and effective_end_date is null
554: and rownum = 1;
555: ELSIF l_party_type = 'PERSON' THEN
556: SELECT SIC_CODE INTO l_matched_value
557: FROM HZ_ORGANIZATION_PROFILES
558: WHERE party_id = p_record_id
559: and rownum = 1;
560: END IF;
561: RETURN l_matched_value;

Line 570: FROM HZ_ORGANIZATION_PROFILES

566: FROM HZ_PARTIES
567: WHERE party_id = p_record_id;
568: IF l_party_type = 'ORGANIZATION' THEN
569: SELECT SIC_CODE_TYPE INTO l_matched_value
570: FROM HZ_ORGANIZATION_PROFILES
571: WHERE party_id = p_record_id
572: and effective_end_date is null
573: and rownum = 1;
574: ELSIF l_party_type = 'PERSON' THEN

Line 576: FROM HZ_ORGANIZATION_PROFILES

572: and effective_end_date is null
573: and rownum = 1;
574: ELSIF l_party_type = 'PERSON' THEN
575: SELECT SIC_CODE_TYPE INTO l_matched_value
576: FROM HZ_ORGANIZATION_PROFILES
577: WHERE party_id = p_record_id
578: and rownum = 1;
579: END IF;
580: RETURN l_matched_value;

Line 625: FROM HZ_ORGANIZATION_PROFILES

621: FROM HZ_PARTIES
622: WHERE party_id = p_record_id;
623: IF l_party_type = 'ORGANIZATION' THEN
624: SELECT CORPORATION_CLASS INTO l_matched_value
625: FROM HZ_ORGANIZATION_PROFILES
626: WHERE party_id = p_record_id
627: and effective_end_date is null
628: and rownum = 1;
629: ELSIF l_party_type = 'PERSON' THEN

Line 631: FROM HZ_ORGANIZATION_PROFILES

627: and effective_end_date is null
628: and rownum = 1;
629: ELSIF l_party_type = 'PERSON' THEN
630: SELECT CORPORATION_CLASS INTO l_matched_value
631: FROM HZ_ORGANIZATION_PROFILES
632: WHERE party_id = p_record_id
633: and rownum = 1;
634: END IF;
635: RETURN l_matched_value;

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

6981: END IF;
6982: IF l_party_type = 'ORGANIZATION' THEN
6983: SELECT
6984: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
6985: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6986: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6987: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
6988: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6989: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')

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

6982: IF l_party_type = 'ORGANIZATION' THEN
6983: SELECT
6984: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
6985: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6986: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6987: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
6988: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6989: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6990: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')

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

6986: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6987: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
6988: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6989: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6990: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6991: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6992: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
6993: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
6994: INTO

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

6987: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
6988: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6989: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6990: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6991: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6992: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
6993: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
6994: INTO
6995: x_party_search_rec.CATEGORY_CODE

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

6988: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6989: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6990: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6991: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6992: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
6993: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
6994: INTO
6995: x_party_search_rec.CATEGORY_CODE
6996: ,x_party_search_rec.CORPORATION_CLASS

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

6989: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6990: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6991: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6992: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
6993: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
6994: INTO
6995: x_party_search_rec.CATEGORY_CODE
6996: ,x_party_search_rec.CORPORATION_CLASS
6997: ,x_party_search_rec.JGZZ_FISCAL_CODE

Line 7005: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

7001: ,x_party_search_rec.SIC_CODE
7002: ,x_party_search_rec.SIC_CODE_TYPE
7003: ,x_party_search_rec.TAX_NAME
7004: ,x_party_search_rec.TAX_REFERENCE
7005: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7006: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7007: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7008: AND HZ_PARTIES.party_id = p_party_id;
7009: ELSIF l_party_type = 'PERSON' THEN

Line 7006: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

7002: ,x_party_search_rec.SIC_CODE_TYPE
7003: ,x_party_search_rec.TAX_NAME
7004: ,x_party_search_rec.TAX_REFERENCE
7005: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7006: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7007: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7008: AND HZ_PARTIES.party_id = p_party_id;
7009: ELSIF l_party_type = 'PERSON' THEN
7010: SELECT

Line 7007: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

7003: ,x_party_search_rec.TAX_NAME
7004: ,x_party_search_rec.TAX_REFERENCE
7005: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7006: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7007: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7008: AND HZ_PARTIES.party_id = p_party_id;
7009: ELSIF l_party_type = 'PERSON' THEN
7010: SELECT
7011: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')