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_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 491: FROM HZ_PARTIES

487: END IF;
488: IF p_attribute = 'TAX_NAME' THEN
489:
490: SELECT party_type INTO l_party_type
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

Line 511: FROM HZ_PARTIES

507: END IF;
508: IF p_attribute = 'TAX_REFERENCE' THEN
509:
510: SELECT party_type INTO l_party_type
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

Line 536: FROM HZ_PARTIES

532: END IF;
533: IF p_attribute = 'PARTY_NUMBER' THEN
534:
535: SELECT party_type INTO l_party_type
536: FROM HZ_PARTIES
537: WHERE party_id = p_record_id;
538: IF l_party_type = 'ORGANIZATION' THEN
539: SELECT PARTY_NUMBER INTO l_matched_value
540: FROM HZ_PARTIES

Line 540: FROM HZ_PARTIES

536: FROM HZ_PARTIES
537: WHERE party_id = p_record_id;
538: IF l_party_type = 'ORGANIZATION' THEN
539: SELECT PARTY_NUMBER INTO l_matched_value
540: FROM HZ_PARTIES
541: WHERE party_id = p_record_id
542: and rownum = 1;
543: ELSIF l_party_type = 'PERSON' THEN
544: SELECT PARTY_NUMBER INTO l_matched_value

Line 545: FROM HZ_PARTIES

541: WHERE party_id = p_record_id
542: and rownum = 1;
543: ELSIF l_party_type = 'PERSON' THEN
544: SELECT PARTY_NUMBER INTO l_matched_value
545: FROM HZ_PARTIES
546: WHERE party_id = p_record_id
547: and rownum = 1;
548: END IF;
549: RETURN l_matched_value;

Line 559: FROM HZ_PARTIES

555: END IF;
556: IF p_attribute = 'SIC_CODE' THEN
557:
558: SELECT party_type INTO l_party_type
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

Line 578: FROM HZ_PARTIES

574: END IF;
575: IF p_attribute = 'SIC_CODE_TYPE' THEN
576:
577: SELECT party_type INTO l_party_type
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

Line 597: FROM HZ_PARTIES

593: END IF;
594: IF p_attribute = 'CATEGORY_CODE' THEN
595:
596: SELECT party_type INTO l_party_type
597: FROM HZ_PARTIES
598: WHERE party_id = p_record_id;
599: IF l_party_type = 'ORGANIZATION' THEN
600: SELECT CATEGORY_CODE INTO l_matched_value
601: FROM HZ_PARTIES

Line 601: FROM HZ_PARTIES

597: FROM HZ_PARTIES
598: WHERE party_id = p_record_id;
599: IF l_party_type = 'ORGANIZATION' THEN
600: SELECT CATEGORY_CODE INTO l_matched_value
601: FROM HZ_PARTIES
602: WHERE party_id = p_record_id
603: and rownum = 1;
604: ELSIF l_party_type = 'PERSON' THEN
605: SELECT CATEGORY_CODE INTO l_matched_value

Line 606: FROM HZ_PARTIES

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

Line 615: FROM HZ_PARTIES

611: END IF;
612: IF p_attribute = 'REFERENCE_USE_FLAG' THEN
613:
614: SELECT party_type INTO l_party_type
615: FROM HZ_PARTIES
616: WHERE party_id = p_record_id;
617: IF l_party_type = 'ORGANIZATION' THEN
618: SELECT REFERENCE_USE_FLAG INTO l_matched_value
619: FROM HZ_PARTIES

Line 619: FROM HZ_PARTIES

615: FROM HZ_PARTIES
616: WHERE party_id = p_record_id;
617: IF l_party_type = 'ORGANIZATION' THEN
618: SELECT REFERENCE_USE_FLAG INTO l_matched_value
619: FROM HZ_PARTIES
620: WHERE party_id = p_record_id
621: and rownum = 1;
622: ELSIF l_party_type = 'PERSON' THEN
623: SELECT REFERENCE_USE_FLAG INTO l_matched_value

Line 624: FROM HZ_PARTIES

620: WHERE party_id = p_record_id
621: and rownum = 1;
622: ELSIF l_party_type = 'PERSON' THEN
623: SELECT REFERENCE_USE_FLAG INTO l_matched_value
624: FROM HZ_PARTIES
625: WHERE party_id = p_record_id
626: and rownum = 1;
627: END IF;
628: RETURN l_matched_value;

Line 633: FROM HZ_PARTIES

629: END IF;
630: IF p_attribute = 'CORPORATION_CLASS' THEN
631:
632: SELECT party_type INTO l_party_type
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

Line 2541: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2537: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2538: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2539: AND r.object_id = p_party_id
2540: AND r.subject_id = stage.party_id
2541: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2542: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2543: AND r.relationship_id = oc.party_relationship_id
2544: AND oc.org_contact_id = stage.org_contact_id;
2545: END IF;

Line 2542: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2538: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2539: AND r.object_id = p_party_id
2540: AND r.subject_id = stage.party_id
2541: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2542: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2543: AND r.relationship_id = oc.party_relationship_id
2544: AND oc.org_contact_id = stage.org_contact_id;
2545: END IF;
2546: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN

Line 2960: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2956: AND( (l_search_merged ='Y' )
2957: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2958: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2959: AND r.subject_id = stage.party_id
2960: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2961: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2962: AND r.relationship_id = oc.party_relationship_id
2963: AND oc.org_contact_id = stage.org_contact_id;
2964: END IF;

Line 2961: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2957: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2958: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2959: AND r.subject_id = stage.party_id
2960: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2961: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2962: AND r.relationship_id = oc.party_relationship_id
2963: AND oc.org_contact_id = stage.org_contact_id;
2964: END IF;
2965: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN

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

4321: RETURN NUMBER IS
4322: l_party_type VARCHAR2(255);
4323: l_person_id NUMBER(15);
4324: BEGIN
4325: SELECT party_type INTO l_party_type from hz_parties where party_id = p_party_id;
4326: IF l_party_type = 'PERSON' THEN
4327: RETURN p_party_id;
4328: ELSIF p_contact_id IS NULL THEN
4329: RETURN NULL;

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

4328: ELSIF p_contact_id IS NULL THEN
4329: RETURN NULL;
4330: ELSE
4331: BEGIN
4332: SELECT subject_id INTO l_person_id FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, hz_parties p
4333: WHERE oc.org_contact_id = p_contact_id
4334: AND r.relationship_id = oc.party_relationship_id
4335: AND r.object_id = p_party_id
4336: AND p.party_id = r.subject_id

Line 5363: and c.owner_table_name = 'HZ_PARTIES'

5359: l_match_idx NUMBER;
5360: cursor get_cpt_for_contact_id is select contact_point_id
5361: from hz_org_contacts a, hz_relationships b, hz_contact_points c
5362: where a.party_relationship_id = b.relationship_id
5363: and c.owner_table_name = 'HZ_PARTIES'
5364: and c.primary_flag='Y'
5365: and c.owner_table_id = b.party_id
5366: and b.directional_flag = 'F'
5367: and a.org_contact_id = p_org_contact_id;

Line 6852: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

6848: AND party_id in (
6849: SELECT party_id
6850: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6851: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6852: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6853: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6854: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6855: and l_use_contact_info = 'Y'
6856: )

Line 6853: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

6849: SELECT party_id
6850: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6851: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6852: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6853: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6854: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6855: and l_use_contact_info = 'Y'
6856: )
6857: AND ROWNUM<6

Line 6867: AND owner_table_name = 'HZ_PARTIES'

6863: FOR CONTACT_POINTS IN (
6864: SELECT CONTACT_POINT_ID
6865: FROM HZ_CONTACT_POINTS
6866: WHERE PRIMARY_FLAG = 'Y'
6867: AND owner_table_name = 'HZ_PARTIES'
6868: AND owner_table_id = p_party_id
6869:
6870: UNION
6871:

Line 6875: AND owner_table_name = 'HZ_PARTIES'

6871:
6872: SELECT CONTACT_POINT_ID
6873: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6874: WHERE PRIMARY_FLAG = 'Y'
6875: AND owner_table_name = 'HZ_PARTIES'
6876: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6877: AND HZ_RELATIONSHIPS.object_id = p_party_id
6878: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6879: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 6878: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

6874: WHERE PRIMARY_FLAG = 'Y'
6875: AND owner_table_name = 'HZ_PARTIES'
6876: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6877: AND HZ_RELATIONSHIPS.object_id = p_party_id
6878: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6879: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6880: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6881: and l_use_contact_info = 'Y'
6882: AND ROWNUM<6

Line 6879: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

6875: AND owner_table_name = 'HZ_PARTIES'
6876: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6877: AND HZ_RELATIONSHIPS.object_id = p_party_id
6878: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6879: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6880: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6881: and l_use_contact_info = 'Y'
6882: AND ROWNUM<6
6883: UNION

Line 6973: FROM HZ_PARTIES

6969: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6970: 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);
6971: END IF;
6972: SELECT PARTY_TYPE INTO l_party_type
6973: FROM HZ_PARTIES
6974: WHERE PARTY_ID = p_party_id;
6975:
6976: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6977: 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 6981: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')

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

Line 6983: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')

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

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

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

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

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, '%',' ')
6987: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6988: ,translate(HZ_ORGANIZATION_PROFILES.TAX_NAME, '%',' ')
6989: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')

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

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, '%',' ')
7007: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')

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

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, '%',' ')
7007: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
7008: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7009: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7010: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')

Line 7007: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')

7003: AND HZ_PARTIES.party_id = p_party_id;
7004: ELSIF l_party_type = 'PERSON' THEN
7005: SELECT
7006: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
7007: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
7008: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7009: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7010: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7011: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')

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

7004: ELSIF l_party_type = 'PERSON' THEN
7005: SELECT
7006: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
7007: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
7008: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7009: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7010: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7011: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7012: INTO

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

7005: SELECT
7006: translate(HZ_PARTIES.CATEGORY_CODE, '%',' ')
7007: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
7008: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
7009: ,translate(HZ_PARTIES.REFERENCE_USE_FLAG, '%',' ')
7010: ,translate(HZ_PERSON_PROFILES.TAX_NAME, '%',' ')
7011: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
7012: INTO
7013: x_party_search_rec.CATEGORY_CODE

Line 7019: FROM HZ_PARTIES, HZ_PERSON_PROFILES

7015: ,x_party_search_rec.PARTY_TYPE
7016: ,x_party_search_rec.REFERENCE_USE_FLAG
7017: ,x_party_search_rec.TAX_NAME
7018: ,x_party_search_rec.TAX_REFERENCE
7019: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7020: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7021: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7022: AND HZ_PARTIES.party_id = p_party_id;
7023: END IF;

Line 7020: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

7016: ,x_party_search_rec.REFERENCE_USE_FLAG
7017: ,x_party_search_rec.TAX_NAME
7018: ,x_party_search_rec.TAX_REFERENCE
7019: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7020: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7021: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7022: AND HZ_PARTIES.party_id = p_party_id;
7023: END IF;
7024: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 7022: AND HZ_PARTIES.party_id = p_party_id;

7018: ,x_party_search_rec.TAX_REFERENCE
7019: FROM HZ_PARTIES, HZ_PERSON_PROFILES
7020: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
7021: AND HZ_PERSON_PROFILES.effective_end_date is NULL
7022: AND HZ_PARTIES.party_id = p_party_id;
7023: END IF;
7024: x_party_search_rec.PARTY_TYPE := l_party_type;
7025: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7026: 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 7122: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

7118: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
7119: SELECT org_contact_id
7120: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
7121: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
7122: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7123: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7124: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
7125: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
7126: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

Line 7123: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

7119: SELECT org_contact_id
7120: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
7121: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
7122: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7123: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7124: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
7125: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
7126: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
7127: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;