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

Line 478: SELECT HZ_ORG_CONTACTS.JOB_TITLE

474: RETURN l_matched_value;
475: END IF;
476: IF p_attribute = 'JOB_TITLE' THEN
477: BEGIN
478: SELECT HZ_ORG_CONTACTS.JOB_TITLE
479: INTO l_matched_value
480: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
481: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
482: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 480: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

476: IF p_attribute = 'JOB_TITLE' THEN
477: BEGIN
478: SELECT HZ_ORG_CONTACTS.JOB_TITLE
479: INTO l_matched_value
480: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
481: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
482: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
483: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
484: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 481: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id

477: BEGIN
478: SELECT HZ_ORG_CONTACTS.JOB_TITLE
479: INTO l_matched_value
480: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
481: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
482: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
483: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
484: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
485: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

Line 485: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

481: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
482: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
483: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
484: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
485: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
486: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
487: AND HZ_PERSON_PROFILES.effective_end_date IS NULL and rownum=1;
488: EXCEPTION
489: WHEN NO_DATA_FOUND THEN

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

2333: ELSIF p_contact_id IS NULL THEN
2334: RETURN NULL;
2335: ELSE
2336: BEGIN
2337: SELECT subject_id INTO l_person_id FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, hz_parties p
2338: WHERE oc.org_contact_id = p_contact_id
2339: AND r.relationship_id = oc.party_relationship_id
2340: AND r.object_id = p_party_id
2341: AND p.party_id = r.subject_id

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

2440: WHERE contains( concat_col, p_contains_str)>0
2441: AND ORG_CONTACT_ID in (
2442: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
2443: org_contact_id
2444: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
2445: where d.party_id = r.subject_id
2446: and oc.party_relationship_id = r.relationship_id
2447: and d.search_context_id = p_search_ctx_id);
2448: exception

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

2473: FORALL I in 1..H_PARTY_ID.COUNT
2474: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2475: l_search_ctx_id,H_PARTY_ID(I));
2476: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2477: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2478: HZ_RELATIONSHIPS r
2479: WHERE oc.party_relationship_id = r.relationship_id
2480: AND r.object_id = d.party_id
2481: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

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

2486: FORALL I in 1..H_PARTY_ID.COUNT
2487: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2488: l_search_ctx_id,H_PARTY_ID(I));
2489: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2490: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2491: HZ_RELATIONSHIPS r
2492: WHERE oc.party_relationship_id = r.relationship_id
2493: AND r.object_id = d.party_id
2494: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

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

2610: FORALL I in 1..H_PARTY_ID.COUNT
2611: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2612: l_search_ctx_id,H_PARTY_ID(I));
2613: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2614: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2615: HZ_RELATIONSHIPS r
2616: WHERE oc.party_relationship_id = r.relationship_id
2617: AND r.object_id = d.party_id
2618: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

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

2623: FORALL I in 1..H_PARTY_ID.COUNT
2624: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID) VALUES (
2625: l_search_ctx_id,H_PARTY_ID(I));
2626: INSERT INTO HZ_DQM_PARTIES_GT (SEARCH_CONTEXT_ID,PARTY_ID)
2627: SELECT distinct l_search_ctx_id,r.subject_id from HZ_DQM_PARTIES_GT d, HZ_ORG_CONTACTS oc,
2628: HZ_RELATIONSHIPS r
2629: WHERE oc.party_relationship_id = r.relationship_id
2630: AND r.object_id = d.party_id
2631: AND d.SEARCH_CONTEXT_ID=l_search_ctx_id;

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

3130: p_party_site_list HZ_PARTY_SEARCH.IDList;
3131: p_contact_ids HZ_PARTY_SEARCH.IDList;
3132: l_match_idx NUMBER;
3133: cursor get_cpt_for_contact_id is select contact_point_id
3134: from hz_org_contacts a, hz_relationships b, hz_contact_points c
3135: where a.party_relationship_id = b.relationship_id
3136: and c.owner_table_name = 'HZ_PARTIES'
3137: and c.primary_flag='Y'
3138: and c.owner_table_id = b.party_id

Line 4520: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

4516: FROM HZ_PARTY_SITES
4517: WHERE (status is null OR status = 'A')
4518: AND party_id in (
4519: SELECT party_id
4520: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4521: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
4522: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4523: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4524: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

Line 4524: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

4520: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4521: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
4522: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4523: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4524: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4525: and l_use_contact_info = 'Y'
4526: )
4527: ) order by identifying_address_flag desc
4528: ) LOOP

Line 4534: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

4530: ps:=ps+1;
4531: END LOOP;
4532: FOR CONTACTS IN (
4533: SELECT org_contact_id
4534: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4535: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
4536: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4537: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4538: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 4539: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

4535: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
4536: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4537: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4538: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
4539: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4540: ) LOOP
4541: l_contact_ids(ct) := CONTACTS.org_contact_id;
4542: ct := ct+1;
4543: END LOOP;

Line 4554: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

4550:
4551: UNION
4552:
4553: SELECT CONTACT_POINT_ID
4554: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
4555: WHERE PRIMARY_FLAG = 'Y'
4556: AND owner_table_name = 'HZ_PARTIES'
4557: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
4558: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 4561: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

4557: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
4558: AND HZ_RELATIONSHIPS.object_id = p_party_id
4559: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4560: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4561: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4562: and l_use_contact_info = 'Y'
4563: UNION
4564:
4565: SELECT CONTACT_POINT_ID

Line 4784: ,HZ_ORG_CONTACTS.JOB_TITLE

4780: x_contact_list OUT NOCOPY HZ_PARTY_SEARCH.contact_list
4781: ) IS
4782: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
4783: SELECT org_contact_id
4784: ,HZ_ORG_CONTACTS.JOB_TITLE
4785: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
4786: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
4787: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4788: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 4785: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

4781: ) IS
4782: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
4783: SELECT org_contact_id
4784: ,HZ_ORG_CONTACTS.JOB_TITLE
4785: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
4786: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
4787: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4788: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4789: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 4786: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id

4782: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
4783: SELECT org_contact_id
4784: ,HZ_ORG_CONTACTS.JOB_TITLE
4785: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
4786: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
4787: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4788: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4789: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
4790: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

Line 4790: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

4786: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
4787: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
4788: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
4789: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
4790: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
4791: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
4792: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
4793:
4794: I NUMBER;