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_6 dependencies on HZ_ORG_CONTACTS

Line 130: p_person_restrict_sql := 'exists ( SELECT 1 from HZ_ORG_CONTACTS oc, hz_relationships r'

126: ELSIF instrb(p_restrict_sql, 'stage.') > 0
127: THEN
128: p_restrict1_sql := replace( p_restrict_sql, 'stage.', 'stage1.');
129: END IF;
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'

Line 1638: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc

1634: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1635: AND stage.party_id = p_party_id
1636: UNION
1637: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1638: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1639: WHERE contains( concat_col, p_contains_str)>0
1640: AND( (l_search_merged ='Y' )
1641: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1642: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1690: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage

1686: AND d.party_id = stage.party_id
1687: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1688: UNION
1689: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID, TX3, TX4, TX11
1690: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1691: WHERE contains( concat_col, p_contains_str)>0
1692: AND( (l_search_merged ='Y' )
1693: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1694: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1764: ' ( SELECT org_contact_id from HZ_ORG_CONTACTS oc, (select object_id, relationship_id, subject_id party_id from hz_relationships ' ||

1760: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1761: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1762: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1763: ' AND ORG_CONTACT_ID IN ' ||
1764: ' ( SELECT org_contact_id from HZ_ORG_CONTACTS oc, (select object_id, relationship_id, subject_id party_id from hz_relationships ' ||
1765: ' where subject_type = ''PERSON'' AND object_type = ''ORGANIZATION'') stage1 ' ||
1766: ' where stage1.relationship_id = oc.party_relationship_id ' ||
1767: ' and ('||p_restrict_sql1|| ') )' ||
1768: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

Line 2057: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc

2053: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2054: AND stage.party_id = p_party_id
2055: UNION
2056: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1
2057: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
2058: WHERE contains( concat_col, p_contains_str)>0
2059: AND r.object_id = p_party_id
2060: AND( (l_search_merged ='Y' )
2061: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 2109: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage

2105: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2106: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2107: UNION
2108: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1
2109: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2110: WHERE contains( concat_col, p_contains_str)>0
2111: AND d.search_context_id = p_search_ctx_id
2112: AND d.party_id = r.subject_id
2113: AND r.relationship_id = oc.party_relationship_id

Line 2183: ' ( SELECT org_contact_id from HZ_ORG_CONTACTS oc, (select object_id, relationship_id, subject_id party_id from hz_relationships r ' ||

2179: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2180: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2181: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2182: ' AND (stage.org_contact_id in ' ||
2183: ' ( SELECT org_contact_id from HZ_ORG_CONTACTS oc, (select object_id, relationship_id, subject_id party_id from hz_relationships r ' ||
2184: ' where subject_type = ''PERSON'' AND object_type = ''ORGANIZATION'') stage1 ' ||
2185: ' where stage1.relationship_id = oc.party_relationship_id ' ||
2186: ' and ('||p_restrict_sql1 || ') ) )' ||
2187: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

3364: ELSIF p_contact_id IS NULL THEN
3365: RETURN NULL;
3366: ELSE
3367: BEGIN
3368: SELECT subject_id INTO l_person_id FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, hz_parties p
3369: WHERE oc.org_contact_id = p_contact_id
3370: AND r.relationship_id = oc.party_relationship_id
3371: AND r.object_id = p_party_id
3372: AND p.party_id = r.subject_id

Line 3517: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc

3513: WHERE contains( concat_col, p_contains_str)>0
3514: AND ORG_CONTACT_ID in (
3515: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3516: org_contact_id
3517: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3518: where d.party_id = r.subject_id
3519: and oc.party_relationship_id = r.relationship_id
3520: and d.search_context_id = p_search_ctx_id);
3521: exception

Line 4328: from hz_org_contacts a, hz_relationships b, hz_contact_points c

4324: p_party_site_list HZ_PARTY_SEARCH.IDList;
4325: p_contact_ids HZ_PARTY_SEARCH.IDList;
4326: l_match_idx NUMBER;
4327: cursor get_cpt_for_contact_id is select contact_point_id
4328: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4329: where a.party_relationship_id = b.relationship_id
4330: and c.owner_table_name = 'HZ_PARTIES'
4331: and c.primary_flag='Y'
4332: and c.owner_table_id = b.party_id

Line 5648: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5644: FROM HZ_PARTY_SITES
5645: WHERE (status is null OR status = 'A')
5646: AND party_id in (
5647: SELECT party_id
5648: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5649: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
5650: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5651: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5652: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

Line 5652: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

5648: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5649: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
5650: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5651: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5652: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5653: and l_use_contact_info = 'Y'
5654: )
5655: AND ROWNUM<6
5656: ) order by identifying_address_flag desc

Line 5663: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5659: ps:=ps+1;
5660: END LOOP;
5661: FOR CONTACTS IN (
5662: SELECT org_contact_id
5663: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5664: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
5665: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5666: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5667: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 5668: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

5664: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
5665: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5666: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5667: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5668: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5669: AND ROWNUM<6
5670: ) LOOP
5671: l_contact_ids(ct) := CONTACTS.org_contact_id;
5672: ct := ct+1;

Line 5684: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5680:
5681: UNION
5682:
5683: SELECT CONTACT_POINT_ID
5684: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5685: WHERE PRIMARY_FLAG = 'Y'
5686: AND owner_table_name = 'HZ_PARTIES'
5687: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5688: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 5691: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

5687: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5688: AND HZ_RELATIONSHIPS.object_id = p_party_id
5689: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5690: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5691: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5692: and l_use_contact_info = 'Y'
5693: AND ROWNUM<6
5694: UNION
5695:

Line 5905: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

5901: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
5902: ) IS
5903: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5904: SELECT org_contact_id
5905: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5906: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5907: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5908: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5909: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 5906: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id

5902: ) IS
5903: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5904: SELECT org_contact_id
5905: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5906: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5907: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5908: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5909: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5910: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

Line 5910: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

5906: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5907: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5908: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5909: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5910: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5911: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5912: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5913:
5914: I NUMBER;