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

Line 487: SELECT HZ_ORG_CONTACTS.JOB_TITLE

483: RETURN l_matched_value;
484: END IF;
485: IF p_attribute = 'JOB_TITLE' THEN
486: BEGIN
487: SELECT HZ_ORG_CONTACTS.JOB_TITLE
488: INTO l_matched_value
489: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
490: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
491: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 489: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

485: IF p_attribute = 'JOB_TITLE' THEN
486: BEGIN
487: SELECT HZ_ORG_CONTACTS.JOB_TITLE
488: INTO l_matched_value
489: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
490: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
491: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
492: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
493: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 490: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id

486: BEGIN
487: SELECT HZ_ORG_CONTACTS.JOB_TITLE
488: INTO l_matched_value
489: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
490: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
491: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
492: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
493: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
494: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

Line 494: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

490: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
491: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
492: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
493: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
494: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
495: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
496: AND HZ_PERSON_PROFILES.effective_end_date IS NULL and rownum=1;
497: EXCEPTION
498: WHEN NO_DATA_FOUND THEN

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

2401: ELSIF p_contact_id IS NULL THEN
2402: RETURN NULL;
2403: ELSE
2404: BEGIN
2405: SELECT subject_id INTO l_person_id FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, hz_parties p
2406: WHERE oc.org_contact_id = p_contact_id
2407: AND r.relationship_id = oc.party_relationship_id
2408: AND r.object_id = p_party_id
2409: AND p.party_id = r.subject_id

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

2508: WHERE contains( concat_col, p_contains_str)>0
2509: AND ORG_CONTACT_ID in (
2510: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
2511: org_contact_id
2512: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
2513: where d.party_id = r.subject_id
2514: and oc.party_relationship_id = r.relationship_id
2515: and d.search_context_id = p_search_ctx_id);
2516: exception

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

2541: FORALL I in 1..H_PARTY_ID.COUNT
2542: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2543: l_search_ctx_id,H_PARTY_ID(I));
2544: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2545: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2546: HZ_RELATIONSHIPS r
2547: WHERE oc.party_relationship_id = r.relationship_id
2548: AND r.object_id = d.party_id
2549: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

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

2554: FORALL I in 1..H_PARTY_ID.COUNT
2555: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2556: l_search_ctx_id,H_PARTY_ID(I));
2557: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2558: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2559: HZ_RELATIONSHIPS r
2560: WHERE oc.party_relationship_id = r.relationship_id
2561: AND r.object_id = d.party_id
2562: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

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

2678: FORALL I in 1..H_PARTY_ID.COUNT
2679: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2680: l_search_ctx_id,H_PARTY_ID(I));
2681: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2682: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2683: HZ_RELATIONSHIPS r
2684: WHERE oc.party_relationship_id = r.relationship_id
2685: AND r.object_id = d.party_id
2686: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

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

2691: FORALL I in 1..H_PARTY_ID.COUNT
2692: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2693: l_search_ctx_id,H_PARTY_ID(I));
2694: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2695: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2696: HZ_RELATIONSHIPS r
2697: WHERE oc.party_relationship_id = r.relationship_id
2698: AND r.object_id = d.party_id
2699: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

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

3198: p_party_site_list HZ_PARTY_SEARCH.IDList;
3199: p_contact_ids HZ_PARTY_SEARCH.IDList;
3200: l_match_idx NUMBER;
3201: cursor get_cpt_for_contact_id is select contact_point_id
3202: from hz_org_contacts a, hz_relationships b, hz_contact_points c
3203: where a.party_relationship_id = b.relationship_id
3204: and c.owner_table_name = 'HZ_PARTIES'
3205: and c.primary_flag='Y'
3206: and c.owner_table_id = b.party_id

Line 4618: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

4614: FROM HZ_PARTY_SITES
4615: WHERE (status is null OR status = 'A')
4616: AND party_id in (
4617: SELECT party_id
4618: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4619: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
4620: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4621: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4622: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

Line 4622: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

4618: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4619: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
4620: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4621: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4622: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4623: and l_use_contact_info = 'Y'
4624: )
4625: ) order by identifying_address_flag desc
4626: ) LOOP

Line 4632: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

4628: ps:=ps+1;
4629: END LOOP;
4630: FOR CONTACTS IN (
4631: SELECT org_contact_id
4632: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4633: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
4634: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4635: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4636: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 4637: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

4633: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
4634: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4635: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4636: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
4637: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4638: ) LOOP
4639: l_contact_ids(ct) := CONTACTS.org_contact_id;
4640: ct := ct+1;
4641: END LOOP;

Line 4652: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

4648:
4649: UNION
4650:
4651: SELECT CONTACT_POINT_ID
4652: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4653: WHERE PRIMARY_FLAG = 'Y'
4654: AND owner_table_name = 'HZ_PARTIES'
4655: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
4656: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 4659: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

4655: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
4656: AND HZ_RELATIONSHIPS.object_id = p_party_id
4657: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4658: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4659: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4660: and l_use_contact_info = 'Y'
4661: UNION
4662:
4663: SELECT CONTACT_POINT_ID

Line 4882: ,HZ_ORG_CONTACTS.JOB_TITLE

4878: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
4879: ) IS
4880: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
4881: SELECT org_contact_id
4882: ,HZ_ORG_CONTACTS.JOB_TITLE
4883: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
4884: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
4885: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4886: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 4883: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

4879: ) IS
4880: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
4881: SELECT org_contact_id
4882: ,HZ_ORG_CONTACTS.JOB_TITLE
4883: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
4884: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
4885: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4886: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4887: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 4884: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id

4880: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
4881: SELECT org_contact_id
4882: ,HZ_ORG_CONTACTS.JOB_TITLE
4883: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
4884: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
4885: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4886: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4887: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
4888: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

Line 4888: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

4884: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
4885: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4886: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4887: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
4888: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4889: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
4890: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
4891:
4892: I NUMBER;