[Home] [Help]
1058:
1059: --bug 4500011 replaced hz_party_relationships with hz_relationships
1060: CURSOR c_contact IS
1061: SELECT oc.org_contact_id
1062: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc
1063: WHERE pr.relationship_id = oc.party_relationship_id
1064: AND pr.subject_id = p_party_id
1065: AND pr.subject_table_name = 'HZ_PARTIES'
1066: AND pr.object_table_name = 'HZ_PARTIES'
1392: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
1393: ,oc.CONTACT_NUMBER
1394: ,oc.JOB_TITLE
1395: FROM HZ_DQM_STAGE_GT g, HZ_RELATIONSHIPS r,
1396: HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp
1397: WHERE oc.party_relationship_id = r.relationship_id
1398: AND r.object_id = g.party_id
1399: AND r.subject_id = pp.party_id
1400: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1516: INTO H_ORG_CONTACT_ID(1), H_PARTY_ID(1), H_STATUS(1)
1517: , H_TX2(1)
1518: , H_TX11(1)
1519: , H_TX22(1)
1520: FROM HZ_ORG_CONTACTS oc, HZ_DQM_SYNC_INTERFACE d,
1521: HZ_RELATIONSHIPS r, HZ_PERSON_PROFILES pp
1522: WHERE d.ENTITY = 'CONTACTS'
1523: AND oc.org_contact_id = p_org_contact_id
1524: AND oc.org_contact_id = d.RECORD_ID
1633:
1634: l_party_id := -1;
1635:
1636: SELECT r.object_id INTO l_party_id
1637: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
1638: WHERE oc.org_contact_id = p_org_contact_id
1639: AND oc.party_relationship_id = r.relationship_id
1640: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1641: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1651: INTO H_ORG_CONTACT_ID(1), H_PARTY_ID(1), H_STATUS(1)
1652: ,H_TX2(1)
1653: ,H_TX11(1)
1654: ,H_TX22(1)
1655: FROM HZ_ORG_CONTACTS oc,
1656: HZ_RELATIONSHIPS r, HZ_PERSON_PROFILES pp
1657: WHERE
1658: oc.org_contact_id = p_org_contact_id
1659: AND oc.party_relationship_id = r.relationship_id
2120:
2121: IF l_party_type = 'PARTY_RELATIONSHIP' THEN
2122: BEGIN
2123: SELECT r.object_id, org_contact_id INTO l_party_id,l_org_contact_id
2124: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
2125: WHERE r.party_id = l_party_id1
2126: AND r.relationship_id = oc.party_relationship_id
2127: AND r.directional_flag = 'F'
2128: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2147: l_org_contact_id:=NULL;
2148: ELSE
2149: BEGIN
2150: SELECT r.object_id, org_contact_id INTO l_party_id,l_org_contact_id
2151: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
2152: WHERE r.party_id = l_ot_id
2153: AND r.relationship_id = oc.party_relationship_id
2154: AND r.directional_flag = 'F'
2155: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2731:
2732: IF l_party_type = 'PARTY_RELATIONSHIP' THEN
2733: BEGIN
2734: SELECT r.object_id, org_contact_id INTO l_party_id,l_org_contact_id
2735: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
2736: WHERE r.party_id = l_party_id1
2737: AND r.relationship_id = oc.party_relationship_id
2738: AND r.directional_flag = 'F'
2739: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3707: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
3708: ,oc.CONTACT_NUMBER
3709: ,oc.JOB_TITLE
3710: FROM HZ_DQM_SYNC_INTERFACE dsi, HZ_RELATIONSHIPS r,
3711: HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp
3712: WHERE oc.party_relationship_id = r.relationship_id
3713: AND dsi.record_id = oc.org_contact_id
3714: AND r.subject_id = pp.party_id
3715: AND r.subject_type = 'PERSON'
4449: ,oc.ROWID
4450: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
4451: ,oc.CONTACT_NUMBER
4452: ,oc.JOB_TITLE
4453: FROM hz_org_contacts oc, hz_imp_contacts_sg ocsg, hz_imp_batch_details bd,
4454: hz_relationships r, hz_person_profiles pp
4455: WHERE ocsg.batch_mode_flag = p_batch_mode_flag
4456: AND oc.party_relationship_id = r.relationship_id
4457: AND ocsg.batch_id = p_batch_id
4479: ,oc.ROWID
4480: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
4481: ,oc.CONTACT_NUMBER
4482: ,oc.JOB_TITLE
4483: FROM hz_org_contacts oc, hz_imp_relships_sg rsg, hz_imp_batch_details bd
4484: ,hz_relationships r, hz_person_profiles pp
4485: WHERE rsg.batch_mode_flag = p_batch_mode_flag
4486: AND rsg.batch_id = p_batch_id
4487: AND rsg.sub_orig_system = p_os