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_58 dependencies on HZ_RELATIONSHIPS

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 389: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

385: IF p_attribute = 'JOB_TITLE' THEN
386: BEGIN
387: SELECT HZ_ORG_CONTACTS.JOB_TITLE
388: INTO l_matched_value
389: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
390: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
391: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
392: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
393: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 391: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

387: SELECT HZ_ORG_CONTACTS.JOB_TITLE
388: INTO l_matched_value
389: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
390: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
391: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
392: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
393: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
394: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
395: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

Line 392: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

388: INTO l_matched_value
389: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
390: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
391: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
392: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
393: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
394: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
395: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
396: AND HZ_PERSON_PROFILES.effective_end_date IS NULL and rownum=1;

Line 393: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

389: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
390: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
391: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
392: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
393: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
394: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
395: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
396: AND HZ_PERSON_PROFILES.effective_end_date IS NULL and rownum=1;
397: EXCEPTION

Line 394: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

390: WHERE HZ_ORG_CONTACTS.org_contact_id = p_record_id
391: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
392: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
393: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
394: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
395: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
396: AND HZ_PERSON_PROFILES.effective_end_date IS NULL and rownum=1;
397: EXCEPTION
398: WHEN NO_DATA_FOUND THEN

Line 395: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

391: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
392: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
393: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
394: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
395: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
396: AND HZ_PERSON_PROFILES.effective_end_date IS NULL and rownum=1;
397: EXCEPTION
398: WHEN NO_DATA_FOUND THEN
399: l_matched_value := 'Err';

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

1556: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1557: AND stage.party_id = p_party_id
1558: UNION
1559: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID
1560: FROM HZ_STAGED_PARTY_SITES stage, hz_relationships r, hz_org_contacts oc
1561: WHERE contains( concat_col, p_contains_str)>0
1562: AND( (l_search_merged ='Y' )
1563: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1564: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1608: AND d.party_id = stage.party_id
1609: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
1610: UNION
1611: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N2) */ stage.PARTY_SITE_ID, r.subject_id, stage.ORG_CONTACT_ID
1612: FROM HZ_DQM_PARTIES_GT d, hz_relationships r,hz_org_contacts oc, HZ_STAGED_PARTY_SITES stage
1613: WHERE contains( concat_col, p_contains_str)>0
1614: AND( (l_search_merged ='Y' )
1615: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1616: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

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

1682: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
1683: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
1684: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
1685: ' AND ORG_CONTACT_ID IN ' ||
1686: ' ( SELECT org_contact_id from HZ_ORG_CONTACTS oc, (select object_id, relationship_id, subject_id party_id from hz_relationships ' ||
1687: ' where subject_type = ''PERSON'' AND object_type = ''ORGANIZATION'') stage1 ' ||
1688: ' where stage1.relationship_id = oc.party_relationship_id ' ||
1689: ' and ('||p_restrict_sql1|| ') )' ||
1690: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

1975: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1976: AND stage.party_id = p_party_id
1977: UNION
1978: 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, TX6, TX5
1979: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1980: WHERE contains( concat_col, p_contains_str)>0
1981: AND r.object_id = p_party_id
1982: AND( (l_search_merged ='Y' )
1983: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

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

2027: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2028: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2029: UNION
2030: 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, TX6, TX5
2031: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2032: WHERE contains( concat_col, p_contains_str)>0
2033: AND d.search_context_id = p_search_ctx_id
2034: AND d.party_id = r.subject_id
2035: AND r.relationship_id = oc.party_relationship_id

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

2101: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2102: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2103: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2104: ' AND (stage.org_contact_id in ' ||
2105: ' ( SELECT org_contact_id from HZ_ORG_CONTACTS oc, (select object_id, relationship_id, subject_id party_id from hz_relationships r ' ||
2106: ' where subject_type = ''PERSON'' AND object_type = ''ORGANIZATION'') stage1 ' ||
2107: ' where stage1.relationship_id = oc.party_relationship_id ' ||
2108: ' and ('||p_restrict_sql1 || ') ) )' ||
2109: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ';

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

3323: ELSIF p_contact_id IS NULL THEN
3324: RETURN NULL;
3325: ELSE
3326: BEGIN
3327: SELECT subject_id INTO l_person_id FROM HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, hz_parties p
3328: WHERE oc.org_contact_id = p_contact_id
3329: AND r.relationship_id = oc.party_relationship_id
3330: AND r.object_id = p_party_id
3331: AND p.party_id = r.subject_id

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

3475: WHERE contains( concat_col, p_contains_str)>0
3476: AND ORG_CONTACT_ID in (
3477: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
3478: org_contact_id
3479: from hz_dqm_parties_gt d, hz_relationships r, hz_org_contacts oc
3480: where d.party_id = r.subject_id
3481: and oc.party_relationship_id = r.relationship_id
3482: and d.search_context_id = p_search_ctx_id);
3483: exception

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

4355: p_party_site_list HZ_PARTY_SEARCH.IDList;
4356: p_contact_ids HZ_PARTY_SEARCH.IDList;
4357: l_match_idx NUMBER;
4358: cursor get_cpt_for_contact_id is select contact_point_id
4359: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4360: where a.party_relationship_id = b.relationship_id
4361: and c.owner_table_name = 'HZ_PARTIES'
4362: and c.primary_flag='Y'
4363: and c.owner_table_id = b.party_id

Line 5666: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5662: END IF;
5663: l_party_id := p_party_id;
5664: FOR CONTACTS IN (
5665: SELECT org_contact_id
5666: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5667: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
5668: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5669: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5670: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 5667: WHERE HZ_RELATIONSHIPS.object_id = p_party_id

5663: l_party_id := p_party_id;
5664: FOR CONTACTS IN (
5665: SELECT org_contact_id
5666: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5667: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
5668: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5669: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5670: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5671: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

Line 5668: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

5664: FOR CONTACTS IN (
5665: SELECT org_contact_id
5666: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5667: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
5668: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5669: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5670: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5671: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5672: AND ROWNUM<6

Line 5669: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

5665: SELECT org_contact_id
5666: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5667: WHERE HZ_RELATIONSHIPS.object_id = p_party_id
5668: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5669: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5670: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5671: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5672: AND ROWNUM<6
5673: ) LOOP

Line 5670: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

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

Line 5671: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

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

Line 5687: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

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

Line 5690: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id

5686: SELECT CONTACT_POINT_ID
5687: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5688: WHERE PRIMARY_FLAG = 'Y'
5689: AND owner_table_name = 'HZ_PARTIES'
5690: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5691: AND HZ_RELATIONSHIPS.object_id = p_party_id
5692: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5693: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5694: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

Line 5691: AND HZ_RELATIONSHIPS.object_id = p_party_id

5687: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5688: WHERE PRIMARY_FLAG = 'Y'
5689: AND owner_table_name = 'HZ_PARTIES'
5690: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5691: AND HZ_RELATIONSHIPS.object_id = p_party_id
5692: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5693: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5694: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5695: and l_use_contact_info = 'Y'

Line 5692: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 5693: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 5694: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

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

Line 5899: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES

5895: ) IS
5896: CURSOR c_contacts(cp_org_contact_id NUMBER) IS
5897: SELECT org_contact_id
5898: ,translate(HZ_ORG_CONTACTS.JOB_TITLE, '%',' ')
5899: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5900: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5901: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5902: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5903: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

Line 5901: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

5897: SELECT org_contact_id
5898: ,translate(HZ_ORG_CONTACTS.JOB_TITLE, '%',' ')
5899: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5900: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5901: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5902: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5903: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5904: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5905: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

Line 5902: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'

5898: ,translate(HZ_ORG_CONTACTS.JOB_TITLE, '%',' ')
5899: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5900: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5901: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5902: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5903: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5904: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5905: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5906: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;

Line 5903: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'

5899: FROM HZ_ORG_CONTACTS, HZ_RELATIONSHIPS, HZ_PERSON_PROFILES
5900: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5901: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5902: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5903: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5904: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5905: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5906: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5907:

Line 5904: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id

5900: WHERE HZ_ORG_CONTACTS.org_contact_id = cp_org_contact_id
5901: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5902: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5903: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5904: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5905: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5906: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5907:
5908: I NUMBER;

Line 5905: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id

5901: AND HZ_RELATIONSHIPS.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
5902: AND HZ_RELATIONSHIPS.OBJECT_TABLE_NAME = 'HZ_PARTIES'
5903: AND HZ_RELATIONSHIPS.DIRECTIONAL_FLAG = 'F'
5904: AND HZ_ORG_CONTACTS.party_relationship_id = HZ_RELATIONSHIPS.relationship_id
5905: AND HZ_RELATIONSHIPS.subject_id = HZ_PERSON_PROFILES.party_id
5906: AND HZ_PERSON_PROFILES.effective_end_date IS NULL;
5907:
5908: I NUMBER;
5909: l_org_contact_id NUMBER;