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

487: FROM HZ_PARTIES
488: WHERE party_id = p_record_id;
489: IF l_party_type = 'ORGANIZATION' THEN
490: SELECT TAX_NAME INTO l_matched_value
491: FROM HZ_ORGANIZATION_PROFILES
492: WHERE party_id = p_record_id
493: and effective_end_date is null
494: and rownum = 1;
495: ELSIF l_party_type = 'PERSON' THEN

Line 511: FROM HZ_ORGANIZATION_PROFILES

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

6992: END IF;
6993: IF l_party_type = 'ORGANIZATION' THEN
6994: SELECT
6995: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
6996: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6997: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6998: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
6999: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7000: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')

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

6993: IF l_party_type = 'ORGANIZATION' THEN
6994: SELECT
6995: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
6996: ,translate(HZ_ORGANIZATION_PROFILES.CORPORATION_CLASS, '%',' ')
6997: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6998: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
6999: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7000: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7001: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')

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

6997: ,translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6998: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
6999: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7000: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7001: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
7002: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
7003: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
7004: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
7005: INTO

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

6998: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
6999: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7000: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7001: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
7002: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
7003: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
7004: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
7005: INTO
7006: x_party_search_rec.CATEGORY_CODE

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

6999: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7000: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7001: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
7002: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
7003: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
7004: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
7005: INTO
7006: x_party_search_rec.CATEGORY_CODE
7007: ,x_party_search_rec.CORPORATION_CLASS

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

7000: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7001: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
7002: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
7003: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
7004: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
7005: INTO
7006: x_party_search_rec.CATEGORY_CODE
7007: ,x_party_search_rec.CORPORATION_CLASS
7008: ,x_party_search_rec.JGZZ_FISCAL_CODE

Line 7016: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

7012: ,x_party_search_rec.SIC_CODE
7013: ,x_party_search_rec.SIC_CODE_TYPE
7014: ,x_party_search_rec.TAX_NAME
7015: ,x_party_search_rec.TAX_REFERENCE
7016: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7017: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7018: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7019: AND HZ_PARTIES.party_id = p_party_id;
7020: ELSIF l_party_type = 'PERSON' THEN

Line 7017: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

7013: ,x_party_search_rec.SIC_CODE_TYPE
7014: ,x_party_search_rec.TAX_NAME
7015: ,x_party_search_rec.TAX_REFERENCE
7016: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7017: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7018: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7019: AND HZ_PARTIES.party_id = p_party_id;
7020: ELSIF l_party_type = 'PERSON' THEN
7021: SELECT

Line 7018: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

7014: ,x_party_search_rec.TAX_NAME
7015: ,x_party_search_rec.TAX_REFERENCE
7016: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
7017: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
7018: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
7019: AND HZ_PARTIES.party_id = p_party_id;
7020: ELSIF l_party_type = 'PERSON' THEN
7021: SELECT
7022: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')