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 495: FROM HZ_ORGANIZATION_PROFILES

491: FROM HZ_PARTIES
492: WHERE party_id = p_record_id;
493: IF l_party_type = 'ORGANIZATION' THEN
494: SELECT TAX_NAME INTO l_matched_value
495: FROM HZ_ORGANIZATION_PROFILES
496: WHERE party_id = p_record_id
497: and effective_end_date is null
498: and rownum = 1;
499: ELSIF l_party_type = 'PERSON' THEN

Line 515: FROM HZ_ORGANIZATION_PROFILES

511: FROM HZ_PARTIES
512: WHERE party_id = p_record_id;
513: IF l_party_type = 'ORGANIZATION' THEN
514: SELECT TAX_REFERENCE INTO l_matched_value
515: FROM HZ_ORGANIZATION_PROFILES
516: WHERE party_id = p_record_id
517: and effective_end_date is null
518: and rownum = 1;
519: 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 6982: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')

6978: END IF;
6979: IF l_party_type = 'ORGANIZATION' THEN
6980: SELECT
6981: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
6982: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6983: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6984: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6985: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6986: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')

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

6982: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6983: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6984: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6985: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6986: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6987: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6988: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
6989: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
6990: INTO

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

6983: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6984: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6985: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6986: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6987: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6988: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
6989: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
6990: INTO
6991: x_party_search_rec.CATEGORY_CODE

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

6984: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6985: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6986: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6987: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6988: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
6989: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
6990: INTO
6991: x_party_search_rec.CATEGORY_CODE
6992: ,x_party_search_rec.CORPORATION_CLASS

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

6985: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
6986: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6987: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6988: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
6989: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
6990: INTO
6991: x_party_search_rec.CATEGORY_CODE
6992: ,x_party_search_rec.CORPORATION_CLASS
6993: ,x_party_search_rec.PARTY_NUMBER

Line 7000: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

6996: ,x_party_search_rec.SIC_CODE
6997: ,x_party_search_rec.SIC_CODE_TYPE
6998: ,x_party_search_rec.TAX_NAME
6999: ,x_party_search_rec.TAX_REFERENCE
7000: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7001: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7002: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7003: AND HZ_PARTIES.party_id = p_party_id;
7004: ELSIF l_party_type = 'PERSON' THEN

Line 7001: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

6997: ,x_party_search_rec.SIC_CODE_TYPE
6998: ,x_party_search_rec.TAX_NAME
6999: ,x_party_search_rec.TAX_REFERENCE
7000: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7001: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7002: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7003: AND HZ_PARTIES.party_id = p_party_id;
7004: ELSIF l_party_type = 'PERSON' THEN
7005: SELECT

Line 7002: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

6998: ,x_party_search_rec.TAX_NAME
6999: ,x_party_search_rec.TAX_REFERENCE
7000: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7001: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7002: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7003: AND HZ_PARTIES.party_id = p_party_id;
7004: ELSIF l_party_type = 'PERSON' THEN
7005: SELECT
7006: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')