DBA Data[Home] [Help]

APPS.OKS_MASS_UPDATE_PVT dependencies on HZ_ORG_CONTACTS

Line 45: --| HZ_ORG_CONTACTS | X | | | | | |

41: --| OKC_K_GROUPS_B | X | | | | | |
42: --+---------------------------------+---+---+---+---+---+----------------------+
43: --| HZ_RELATIONSHIPS | X | | | | | |
44: --+---------------------------------+---+---+---+---+---+----------------------+
45: --| HZ_ORG_CONTACTS | X | | | | | |
46: --+---------------------------------+---+---+---+---+---+----------------------+
47: --| HZ_CUST_SITE_USES_ALL | X | | | | | |
48: --+---------------------------------+---+---+---+---+---+----------------------+
49: --| HZ_CUST_ACCT_SITES_ALL | X | | | | | |

Line 1581: hz_org_contacts oc

1577: SELECT 'x'
1578: FROM hz_relationships r,
1579: hz_parties p3,
1580: hz_parties p2,
1581: hz_org_contacts oc
1582: WHERE p2.party_id = r.subject_id
1583: AND r.relationship_code IN ('CONTACT_OF', 'EMPLOYEE_OF')
1584: AND r.content_source_type = 'USER_ENTERED'
1585: AND p3.party_id = r.party_id