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_PARTIES

Line 134: || ' and exists ( SELECT 1 FROM HZ_PARTIES stage1 where stage1.party_id = r.subject_id'

130: p_person_restrict_sql := 'exists ( SELECT 1 from HZ_ORG_CONTACTS oc, hz_relationships r'
131: || ' where oc.org_contact_id = stage.org_contact_id and'
132: || ' r.relationship_id = oc.party_relationship_id'
133: || ' and r.subject_type = ''PERSON'' AND r.object_type = ''ORGANIZATION'' '
134: || ' and exists ( SELECT 1 FROM HZ_PARTIES stage1 where stage1.party_id = r.subject_id'
135: || ' and ' || p_restrict1_sql || ' ) )' ;
136: p_final_restrict_sql := '((stage.org_contact_id is null and ' || p_restrict_sql || ') or (stage.org_contact_id is not null and '
137: || p_person_restrict_sql || ' ))';
138: END IF;

Line 459: FROM HZ_PARTIES

455: IF p_entity = 'PARTY' THEN
456: IF p_attribute = 'PARTY_NAME' THEN
457:
458: SELECT party_type INTO l_party_type
459: FROM HZ_PARTIES
460: WHERE party_id = p_record_id;
461: IF l_party_type = 'ORGANIZATION' THEN
462: SELECT PARTY_NAME INTO l_matched_value
463: FROM HZ_PARTIES

Line 463: FROM HZ_PARTIES

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

Line 468: FROM HZ_PARTIES

464: WHERE party_id = p_record_id
465: and rownum = 1;
466: ELSIF l_party_type = 'PERSON' THEN
467: SELECT PARTY_NAME INTO l_matched_value
468: FROM HZ_PARTIES
469: WHERE party_id = p_record_id
470: and rownum = 1;
471: END IF;
472: RETURN l_matched_value;

Line 487: FROM HZ_PARTIES

483: END IF;
484: IF p_attribute = 'TAX_NAME' THEN
485:
486: SELECT party_type INTO l_party_type
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

Line 507: FROM HZ_PARTIES

503: END IF;
504: IF p_attribute = 'TAX_REFERENCE' THEN
505:
506: SELECT party_type INTO l_party_type
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

Line 527: FROM HZ_PARTIES

523: END IF;
524: IF p_attribute = 'JGZZ_FISCAL_CODE' THEN
525:
526: SELECT party_type INTO l_party_type
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

Line 547: FROM HZ_PARTIES

543: END IF;
544: IF p_attribute = 'SIC_CODE' THEN
545:
546: SELECT party_type INTO l_party_type
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

Line 566: FROM HZ_PARTIES

562: END IF;
563: IF p_attribute = 'SIC_CODE_TYPE' THEN
564:
565: SELECT party_type INTO l_party_type
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

Line 585: FROM HZ_PARTIES

581: END IF;
582: IF p_attribute = 'CATEGORY_CODE' THEN
583:
584: SELECT party_type INTO l_party_type
585: FROM HZ_PARTIES
586: WHERE party_id = p_record_id;
587: IF l_party_type = 'ORGANIZATION' THEN
588: SELECT CATEGORY_CODE INTO l_matched_value
589: FROM HZ_PARTIES

Line 589: FROM HZ_PARTIES

585: FROM HZ_PARTIES
586: WHERE party_id = p_record_id;
587: IF l_party_type = 'ORGANIZATION' THEN
588: SELECT CATEGORY_CODE INTO l_matched_value
589: FROM HZ_PARTIES
590: WHERE party_id = p_record_id
591: and rownum = 1;
592: ELSIF l_party_type = 'PERSON' THEN
593: SELECT CATEGORY_CODE INTO l_matched_value

Line 594: FROM HZ_PARTIES

590: WHERE party_id = p_record_id
591: and rownum = 1;
592: ELSIF l_party_type = 'PERSON' THEN
593: SELECT CATEGORY_CODE INTO l_matched_value
594: FROM HZ_PARTIES
595: WHERE party_id = p_record_id
596: and rownum = 1;
597: END IF;
598: RETURN l_matched_value;

Line 603: FROM HZ_PARTIES

599: END IF;
600: IF p_attribute = 'REFERENCE_USE_FLAG' THEN
601:
602: SELECT party_type INTO l_party_type
603: FROM HZ_PARTIES
604: WHERE party_id = p_record_id;
605: IF l_party_type = 'ORGANIZATION' THEN
606: SELECT REFERENCE_USE_FLAG INTO l_matched_value
607: FROM HZ_PARTIES

Line 607: FROM HZ_PARTIES

603: FROM HZ_PARTIES
604: WHERE party_id = p_record_id;
605: IF l_party_type = 'ORGANIZATION' THEN
606: SELECT REFERENCE_USE_FLAG INTO l_matched_value
607: FROM HZ_PARTIES
608: WHERE party_id = p_record_id
609: and rownum = 1;
610: ELSIF l_party_type = 'PERSON' THEN
611: SELECT REFERENCE_USE_FLAG INTO l_matched_value

Line 612: FROM HZ_PARTIES

608: WHERE party_id = p_record_id
609: and rownum = 1;
610: ELSIF l_party_type = 'PERSON' THEN
611: SELECT REFERENCE_USE_FLAG INTO l_matched_value
612: FROM HZ_PARTIES
613: WHERE party_id = p_record_id
614: and rownum = 1;
615: END IF;
616: RETURN l_matched_value;

Line 621: FROM HZ_PARTIES

617: END IF;
618: IF p_attribute = 'CORPORATION_CLASS' THEN
619:
620: SELECT party_type INTO l_party_type
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

Line 2556: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2552: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2553: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2554: AND r.object_id = p_party_id
2555: AND r.subject_id = stage.party_id
2556: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2557: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2558: AND r.relationship_id = oc.party_relationship_id
2559: AND oc.org_contact_id = stage.org_contact_id;
2560: END IF;

Line 2557: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2553: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2554: AND r.object_id = p_party_id
2555: AND r.subject_id = stage.party_id
2556: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2557: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2558: AND r.relationship_id = oc.party_relationship_id
2559: AND oc.org_contact_id = stage.org_contact_id;
2560: END IF;
2561: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN

Line 2975: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2971: AND( (l_search_merged ='Y' )
2972: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2973: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2974: AND r.subject_id = stage.party_id
2975: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2976: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2977: AND r.relationship_id = oc.party_relationship_id
2978: AND oc.org_contact_id = stage.org_contact_id;
2979: END IF;

Line 2976: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2972: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2973: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2974: AND r.subject_id = stage.party_id
2975: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2976: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2977: AND r.relationship_id = oc.party_relationship_id
2978: AND oc.org_contact_id = stage.org_contact_id;
2979: END IF;
2980: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN

Line 4335: SELECT party_type INTO l_party_type from hz_parties where party_id = p_party_id;

4331: RETURN NUMBER IS
4332: l_party_type VARCHAR2(255);
4333: l_person_id NUMBER(15);
4334: BEGIN
4335: SELECT party_type INTO l_party_type from hz_parties where party_id = p_party_id;
4336: IF l_party_type = 'PERSON' THEN
4337: RETURN p_party_id;
4338: ELSIF p_contact_id IS NULL THEN
4339: RETURN NULL;

Line 4342: SELECT subject_id INTO l_person_id FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, hz_parties p

4338: ELSIF p_contact_id IS NULL THEN
4339: RETURN NULL;
4340: ELSE
4341: BEGIN
4342: SELECT subject_id INTO l_person_id FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, hz_parties p
4343: WHERE oc.org_contact_id = p_contact_id
4344: AND r.relationship_id = oc.party_relationship_id
4345: AND r.object_id = p_party_id
4346: AND p.party_id = r.subject_id

Line 5376: and c.owner_table_name = 'HZ_PARTIES'

5372: l_match_idx NUMBER;
5373: cursor get_cpt_for_contact_id is select contact_point_id
5374: from hz_org_contacts a, hz_relationships b, hz_contact_points c
5375: where a.party_relationship_id = b.relationship_id
5376: and c.owner_table_name = 'HZ_PARTIES'
5377: and c.primary_flag='Y'
5378: and c.owner_table_id = b.party_id
5379: and b.directional_flag = 'F'
5380: and a.org_contact_id = p_org_contact_id;

Line 6847: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

6843: AND party_id in (
6844: SELECT party_id
6845: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6846: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6847: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6848: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6849: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6850: and l_use_contact_info = 'Y'
6851: )

Line 6848: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

6844: SELECT party_id
6845: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6846: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6847: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6848: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6849: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6850: and l_use_contact_info = 'Y'
6851: )
6852: AND ROWNUM<6

Line 6862: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

6858: FOR CONTACTS IN (
6859: SELECT org_contact_id
6860: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6861: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6862: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6863: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6864: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6865: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6866: AND ROWNUM<6

Line 6863: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

6859: SELECT org_contact_id
6860: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6861: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6862: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6863: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6864: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6865: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6866: AND ROWNUM<6
6867: ) LOOP

Line 6875: AND owner_table_name = 'HZ_PARTIES'

6871: FOR CONTACT_POINTS IN (
6872: SELECT CONTACT_POINT_ID
6873: FROM HZ_CONTACT_POINTS
6874: WHERE PRIMARY_FLAG = 'Y'
6875: AND owner_table_name = 'HZ_PARTIES'
6876: AND owner_table_id = p_party_id
6877:
6878: UNION
6879:

Line 6883: AND owner_table_name = 'HZ_PARTIES'

6879:
6880: SELECT CONTACT_POINT_ID
6881: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6882: WHERE PRIMARY_FLAG = 'Y'
6883: AND owner_table_name = 'HZ_PARTIES'
6884: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6885: AND HZ_RELATIONSHIPS.object_id = p_party_id
6886: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6887: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 6886: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

6882: WHERE PRIMARY_FLAG = 'Y'
6883: AND owner_table_name = 'HZ_PARTIES'
6884: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6885: AND HZ_RELATIONSHIPS.object_id = p_party_id
6886: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6887: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6888: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6889: and l_use_contact_info = 'Y'
6890: AND ROWNUM<6

Line 6887: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

6883: AND owner_table_name = 'HZ_PARTIES'
6884: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6885: AND HZ_RELATIONSHIPS.object_id = p_party_id
6886: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6887: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6888: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6889: and l_use_contact_info = 'Y'
6890: AND ROWNUM<6
6891: UNION

Line 6987: FROM HZ_PARTIES

6983: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6984: hz_utility_v2pub.debug(p_message=>'Inside calling procedure - get_party_rec',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
6985: END IF;
6986: SELECT PARTY_TYPE INTO l_party_type
6987: FROM HZ_PARTIES
6988: WHERE PARTY_ID = p_party_id;
6989:
6990: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6991: 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);

Line 6995: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')

6991: 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);
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, '%',' ')

Line 6998: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')

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, '%',' ')
7002: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')

Line 6999: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')

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, '%',' ')
7002: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
7003: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')

Line 7000: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')

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, '%',' ')
7002: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
7003: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
7004: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')

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 7019: AND HZ_PARTIES.party_id = p_party_id;

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, '%',' ')
7023: ,translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')

Line 7022: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')

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, '%',' ')
7023: ,translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
7024: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
7025: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7026: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')

Line 7024: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')

7020: ELSIF l_party_type = 'PERSON' THEN
7021: SELECT
7022: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
7023: ,translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
7024: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
7025: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7026: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7027: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7028: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')

Line 7025: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')

7021: SELECT
7022: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
7023: ,translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
7024: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
7025: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7026: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7027: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7028: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7029: INTO

Line 7026: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')

7022: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
7023: ,translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
7024: ,translate(HZ_PARTIES.PARTY_NAME, '%',' ')
7025: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7026: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7027: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7028: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7029: INTO
7030: x_party_search_rec.CATEGORY_CODE

Line 7037: FROM HZ_PARTIES, HZ_PERSON_PROFILES

7033: ,x_party_search_rec.PARTY_TYPE
7034: ,x_party_search_rec.REFERENCE_USE_FLAG
7035: ,x_party_search_rec.TAX_NAME
7036: ,x_party_search_rec.TAX_REFERENCE
7037: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7038: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7039: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7040: AND HZ_PARTIES.party_id = p_party_id;
7041: END IF;

Line 7038: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

7034: ,x_party_search_rec.REFERENCE_USE_FLAG
7035: ,x_party_search_rec.TAX_NAME
7036: ,x_party_search_rec.TAX_REFERENCE
7037: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7038: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7039: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7040: AND HZ_PARTIES.party_id = p_party_id;
7041: END IF;
7042: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 7040: AND HZ_PARTIES.party_id = p_party_id;

7036: ,x_party_search_rec.TAX_REFERENCE
7037: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7038: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7039: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7040: AND HZ_PARTIES.party_id = p_party_id;
7041: END IF;
7042: x_party_search_rec.PARTY_TYPE := l_party_type;
7043: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7044: hz_utility_v2pub.debug(p_message=>'Inside calling procedure - generate_custom_code',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);

Line 7140: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

7136: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
7137: SELECT org_contact_id
7138: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
7139: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
7140: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7141: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7142: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
7143: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
7144: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

Line 7141: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

7137: SELECT org_contact_id
7138: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
7139: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
7140: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7141: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7142: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
7143: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
7144: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
7145: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;