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

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

2057: ELSIF p_contact_id IS NULL THEN
2058: RETURN NULL;
2059: ELSE
2060: BEGIN
2061: SELECT subject_id INTO l_person_id FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, hz_parties p
2062: WHERE oc.org_contact_id = p_contact_id
2063: AND r.relationship_id = oc.party_relationship_id
2064: AND r.object_id = p_party_id
2065: AND p.party_id = r.subject_id

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

2164: WHERE contains( concat_col, p_contains_str)>0
2165: AND ORG_CONTACT_ID in (
2166: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
2167: org_contact_id
2168: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
2169: where d.party_id = r.subject_id
2170: and oc.party_relationship_id = r.relationship_id
2171: and d.search_context_id = p_search_ctx_id);
2172: exception

Line 2201: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,

2197: FORALL I in 1..H_PARTY_ID.COUNT
2198: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2199: l_search_ctx_id,H_PARTY_ID(I));
2200: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2201: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2202: HZ_RELATIONSHIPS r
2203: WHERE oc.party_relationship_id = r.relationship_id
2204: AND r.object_id = d.party_id
2205: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

Line 2214: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,

2210: FORALL I in 1..H_PARTY_ID.COUNT
2211: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2212: l_search_ctx_id,H_PARTY_ID(I));
2213: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2214: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2215: HZ_RELATIONSHIPS r
2216: WHERE oc.party_relationship_id = r.relationship_id
2217: AND r.object_id = d.party_id
2218: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

Line 2338: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,

2334: FORALL I in 1..H_PARTY_ID.COUNT
2335: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2336: l_search_ctx_id,H_PARTY_ID(I));
2337: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2338: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2339: HZ_RELATIONSHIPS r
2340: WHERE oc.party_relationship_id = r.relationship_id
2341: AND r.object_id = d.party_id
2342: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

Line 2351: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,

2347: FORALL I in 1..H_PARTY_ID.COUNT
2348: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2349: l_search_ctx_id,H_PARTY_ID(I));
2350: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2351: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2352: HZ_RELATIONSHIPS r
2353: WHERE oc.party_relationship_id = r.relationship_id
2354: AND r.object_id = d.party_id
2355: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

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

2854: p_party_site_list HZ_PARTY_SEARCH.IDList;
2855: p_contact_ids HZ_PARTY_SEARCH.IDList;
2856: l_match_idx NUMBER;
2857: cursor get_cpt_for_contact_id is select contact_point_id
2858: from hz_org_contacts a, hz_relationships b, hz_contact_points c
2859: where a.party_relationship_id = b.relationship_id
2860: and c.owner_table_name = 'HZ_PARTIES'
2861: and c.primary_flag='Y'
2862: and c.owner_table_id = b.party_id

Line 4206: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

4202: FROM HZ_PARTY_SITES
4203: WHERE (status is null OR status = 'A')
4204: AND party_id in (
4205: SELECT party_id
4206: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4207: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
4208: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4209: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4210: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

Line 4210: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

4206: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4207: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
4208: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4209: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4210: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4211: and l_use_contact_info = 'Y'
4212: )
4213: ) order by identifying_address_flag desc
4214: ) LOOP

Line 4228: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

4224:
4225: UNION
4226:
4227: SELECT CONTACT_POINT_ID
4228: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4229: WHERE PRIMARY_FLAG = 'Y'
4230: AND owner_table_name = 'HZ_PARTIES'
4231: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
4232: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 4235: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

4231: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
4232: AND HZ_RELATIONSHIPS.object_id = p_party_id
4233: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4234: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4235: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4236: and l_use_contact_info = 'Y'
4237: UNION
4238:
4239: SELECT CONTACT_POINT_ID

Line 4448: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

4444: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
4445: ) IS
4446: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
4447: SELECT org_contact_id
4448: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
4449: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
4450: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4451: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4452: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 4449: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id

4445: ) IS
4446: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
4447: SELECT org_contact_id
4448: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
4449: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
4450: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4451: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4452: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
4453: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

Line 4453: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

4449: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
4450: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4451: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4452: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
4453: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4454: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
4455: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
4456:
4457: I NUMBER;