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_32 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 451: FROM HZ_PARTIES

447: IF p_entity = 'PARTY' THEN
448: IF p_attribute = 'PARTY_NUMBER' THEN
449:
450: SELECT party_type INTO l_party_type
451: FROM HZ_PARTIES
452: WHERE party_id = p_record_id;
453: IF l_party_type = 'ORGANIZATION' THEN
454: SELECT PARTY_NUMBER INTO l_matched_value
455: FROM HZ_PARTIES

Line 455: FROM HZ_PARTIES

451: FROM HZ_PARTIES
452: WHERE party_id = p_record_id;
453: IF l_party_type = 'ORGANIZATION' THEN
454: SELECT PARTY_NUMBER INTO l_matched_value
455: FROM HZ_PARTIES
456: WHERE party_id = p_record_id
457: and rownum = 1;
458: ELSIF l_party_type = 'PERSON' THEN
459: SELECT PARTY_NUMBER INTO l_matched_value

Line 460: FROM HZ_PARTIES

456: WHERE party_id = p_record_id
457: and rownum = 1;
458: ELSIF l_party_type = 'PERSON' THEN
459: SELECT PARTY_NUMBER INTO l_matched_value
460: FROM HZ_PARTIES
461: WHERE party_id = p_record_id
462: and rownum = 1;
463: END IF;
464: RETURN l_matched_value;

Line 474: FROM HZ_PARTIES

470: END IF;
471: IF p_attribute = 'TAX_REFERENCE' THEN
472:
473: SELECT party_type INTO l_party_type
474: FROM HZ_PARTIES
475: WHERE party_id = p_record_id;
476: IF l_party_type = 'ORGANIZATION' THEN
477: SELECT TAX_REFERENCE INTO l_matched_value
478: FROM HZ_ORGANIZATION_PROFILES

Line 494: FROM HZ_PARTIES

490: END IF;
491: IF p_attribute = 'JGZZ_FISCAL_CODE' THEN
492:
493: SELECT party_type INTO l_party_type
494: FROM HZ_PARTIES
495: WHERE party_id = p_record_id;
496: IF l_party_type = 'ORGANIZATION' THEN
497: SELECT JGZZ_FISCAL_CODE INTO l_matched_value
498: FROM HZ_ORGANIZATION_PROFILES

Line 514: FROM HZ_PARTIES

510: END IF;
511: IF p_attribute = 'SIC_CODE' THEN
512:
513: SELECT party_type INTO l_party_type
514: FROM HZ_PARTIES
515: WHERE party_id = p_record_id;
516: IF l_party_type = 'ORGANIZATION' THEN
517: SELECT SIC_CODE INTO l_matched_value
518: FROM HZ_ORGANIZATION_PROFILES

Line 533: FROM HZ_PARTIES

529: END IF;
530: IF p_attribute = 'SIC_CODE_TYPE' THEN
531:
532: SELECT party_type INTO l_party_type
533: FROM HZ_PARTIES
534: WHERE party_id = p_record_id;
535: IF l_party_type = 'ORGANIZATION' THEN
536: SELECT SIC_CODE_TYPE INTO l_matched_value
537: FROM HZ_ORGANIZATION_PROFILES

Line 2169: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2165: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2166: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2167: AND r.object_id = p_party_id
2168: AND r.subject_id = stage.party_id
2169: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2170: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2171: AND r.relationship_id = oc.party_relationship_id
2172: AND oc.org_contact_id = stage.org_contact_id;
2173: END IF;

Line 2170: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2166: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2167: AND r.object_id = p_party_id
2168: AND r.subject_id = stage.party_id
2169: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2170: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2171: AND r.relationship_id = oc.party_relationship_id
2172: AND oc.org_contact_id = stage.org_contact_id;
2173: END IF;
2174: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN

Line 2588: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2584: AND( (l_search_merged ='Y' )
2585: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2586: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2587: AND r.subject_id = stage.party_id
2588: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2589: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2590: AND r.relationship_id = oc.party_relationship_id
2591: AND oc.org_contact_id = stage.org_contact_id;
2592: END IF;

Line 2589: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2585: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2586: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2587: AND r.subject_id = stage.party_id
2588: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2589: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2590: AND r.relationship_id = oc.party_relationship_id
2591: AND oc.org_contact_id = stage.org_contact_id;
2592: END IF;
2593: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN

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

3940: RETURN NUMBER IS
3941: l_party_type VARCHAR2(255);
3942: l_person_id NUMBER(15);
3943: BEGIN
3944: SELECT party_type INTO l_party_type from hz_parties where party_id = p_party_id;
3945: IF l_party_type = 'PERSON' THEN
3946: RETURN p_party_id;
3947: ELSIF p_contact_id IS NULL THEN
3948: RETURN NULL;

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

3947: ELSIF p_contact_id IS NULL THEN
3948: RETURN NULL;
3949: ELSE
3950: BEGIN
3951: SELECT subject_id INTO l_person_id FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, hz_parties p
3952: WHERE oc.org_contact_id = p_contact_id
3953: AND r.relationship_id = oc.party_relationship_id
3954: AND r.object_id = p_party_id
3955: AND p.party_id = r.subject_id

Line 4983: and c.owner_table_name = 'HZ_PARTIES'

4979: l_match_idx NUMBER;
4980: cursor get_cpt_for_contact_id is select contact_point_id
4981: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4982: where a.party_relationship_id = b.relationship_id
4983: and c.owner_table_name = 'HZ_PARTIES'
4984: and c.primary_flag='Y'
4985: and c.owner_table_id = b.party_id
4986: and b.directional_flag = 'F'
4987: and a.org_contact_id = p_org_contact_id;

Line 6408: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

6404: AND party_id in (
6405: SELECT party_id
6406: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6407: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6408: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6409: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6410: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6411: and l_use_contact_info = 'Y'
6412: )

Line 6409: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

6405: SELECT party_id
6406: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6407: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6408: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6409: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6410: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6411: and l_use_contact_info = 'Y'
6412: )
6413: AND ROWNUM<6

Line 6423: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

6419: FOR CONTACTS IN (
6420: SELECT org_contact_id
6421: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6422: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6423: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6424: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6425: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6426: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6427: AND ROWNUM<6

Line 6424: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

6420: SELECT org_contact_id
6421: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6422: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
6423: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6424: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6425: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6426: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6427: AND ROWNUM<6
6428: ) LOOP

Line 6436: AND owner_table_name = 'HZ_PARTIES'

6432: FOR CONTACT_POINTS IN (
6433: SELECT CONTACT_POINT_ID
6434: FROM HZ_CONTACT_POINTS
6435: WHERE PRIMARY_FLAG = 'Y'
6436: AND owner_table_name = 'HZ_PARTIES'
6437: AND owner_table_id = p_party_id
6438:
6439: UNION
6440:

Line 6444: AND owner_table_name = 'HZ_PARTIES'

6440:
6441: SELECT CONTACT_POINT_ID
6442: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6443: WHERE PRIMARY_FLAG = 'Y'
6444: AND owner_table_name = 'HZ_PARTIES'
6445: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6446: AND HZ_RELATIONSHIPS.object_id = p_party_id
6447: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6448: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 6447: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

6443: WHERE PRIMARY_FLAG = 'Y'
6444: AND owner_table_name = 'HZ_PARTIES'
6445: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6446: AND HZ_RELATIONSHIPS.object_id = p_party_id
6447: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6448: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6449: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6450: and l_use_contact_info = 'Y'
6451: AND ROWNUM<6

Line 6448: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

6444: AND owner_table_name = 'HZ_PARTIES'
6445: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6446: AND HZ_RELATIONSHIPS.object_id = p_party_id
6447: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6448: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6449: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6450: and l_use_contact_info = 'Y'
6451: AND ROWNUM<6
6452: UNION

Line 6548: FROM HZ_PARTIES

6544: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6545: 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);
6546: END IF;
6547: SELECT PARTY_TYPE INTO l_party_type
6548: FROM HZ_PARTIES
6549: WHERE PARTY_ID = p_party_id;
6550:
6551: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6552: 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 6557: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')

6553: END IF;
6554: IF l_party_type = 'ORGANIZATION' THEN
6555: SELECT
6556: translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6557: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6558: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6559: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6560: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6561: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')

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

6554: IF l_party_type = 'ORGANIZATION' THEN
6555: SELECT
6556: translate(HZ_ORGANIZATION_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6557: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6558: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6559: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE, '%',' ')
6560: ,translate(HZ_ORGANIZATION_PROFILES.SIC_CODE_TYPE, '%',' ')
6561: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
6562: INTO

Line 6569: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

6565: ,x_party_search_rec.PARTY_TYPE
6566: ,x_party_search_rec.SIC_CODE
6567: ,x_party_search_rec.SIC_CODE_TYPE
6568: ,x_party_search_rec.TAX_REFERENCE
6569: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6570: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6571: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6572: AND HZ_PARTIES.party_id = p_party_id;
6573: ELSIF l_party_type = 'PERSON' THEN

Line 6570: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

6566: ,x_party_search_rec.SIC_CODE
6567: ,x_party_search_rec.SIC_CODE_TYPE
6568: ,x_party_search_rec.TAX_REFERENCE
6569: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6570: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6571: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6572: AND HZ_PARTIES.party_id = p_party_id;
6573: ELSIF l_party_type = 'PERSON' THEN
6574: SELECT

Line 6572: AND HZ_PARTIES.party_id = p_party_id;

6568: ,x_party_search_rec.TAX_REFERENCE
6569: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
6570: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
6571: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
6572: AND HZ_PARTIES.party_id = p_party_id;
6573: ELSIF l_party_type = 'PERSON' THEN
6574: SELECT
6575: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6576: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')

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

6572: AND HZ_PARTIES.party_id = p_party_id;
6573: ELSIF l_party_type = 'PERSON' THEN
6574: SELECT
6575: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6576: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6577: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6578: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
6579: INTO
6580: x_party_search_rec.JGZZ_FISCAL_CODE

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

6573: ELSIF l_party_type = 'PERSON' THEN
6574: SELECT
6575: translate(HZ_PERSON_PROFILES.JGZZ_FISCAL_CODE, '%',' ')
6576: ,translate(HZ_PARTIES.PARTY_NUMBER, '%',' ')
6577: ,translate(HZ_PARTIES.PARTY_TYPE, '%',' ')
6578: ,translate(HZ_PERSON_PROFILES.TAX_REFERENCE, '%',' ')
6579: INTO
6580: x_party_search_rec.JGZZ_FISCAL_CODE
6581: ,x_party_search_rec.PARTY_NUMBER

Line 6584: FROM HZ_PARTIES, HZ_PERSON_PROFILES

6580: x_party_search_rec.JGZZ_FISCAL_CODE
6581: ,x_party_search_rec.PARTY_NUMBER
6582: ,x_party_search_rec.PARTY_TYPE
6583: ,x_party_search_rec.TAX_REFERENCE
6584: FROM HZ_PARTIES, HZ_PERSON_PROFILES
6585: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
6586: AND HZ_PERSON_PROFILES.effective_end_date is NULL
6587: AND HZ_PARTIES.party_id = p_party_id;
6588: END IF;

Line 6585: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id

6581: ,x_party_search_rec.PARTY_NUMBER
6582: ,x_party_search_rec.PARTY_TYPE
6583: ,x_party_search_rec.TAX_REFERENCE
6584: FROM HZ_PARTIES, HZ_PERSON_PROFILES
6585: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
6586: AND HZ_PERSON_PROFILES.effective_end_date is NULL
6587: AND HZ_PARTIES.party_id = p_party_id;
6588: END IF;
6589: x_party_search_rec.PARTY_TYPE := l_party_type;

Line 6587: AND HZ_PARTIES.party_id = p_party_id;

6583: ,x_party_search_rec.TAX_REFERENCE
6584: FROM HZ_PARTIES, HZ_PERSON_PROFILES
6585: WHERE HZ_PARTIES.party_id = HZ_PERSON_PROFILES.party_id
6586: AND HZ_PERSON_PROFILES.effective_end_date is NULL
6587: AND HZ_PARTIES.party_id = p_party_id;
6588: END IF;
6589: x_party_search_rec.PARTY_TYPE := l_party_type;
6590: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6591: 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 6681: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

6677: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
6678: SELECT org_contact_id
6679: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
6680: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
6681: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6682: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6683: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6684: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6685: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

Line 6682: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

6678: SELECT org_contact_id
6679: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
6680: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
6681: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
6682: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
6683: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
6684: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
6685: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
6686: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;