FND Design Data [Home] [Help]

Table: HZ_ORG_CONTACTS

Product: AR - Receivables
Description: People as contacts for parties
Implementation/DBA Data: TableAR.HZ_ORG_CONTACTS
Primary Key: HZ_ORG_CONTACTS_PK
  1. ColumnORG_CONTACT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
HZ_ORG_CONTACTS FK Joins to TableHZ_PARTY_RELATIONSHIPS HZ_ORG_CONTACTS.PARTY_RELATIONSHIP_ID
HZ_ORG_CONTACTS FK Joins to TableHZ_PARTY_SITES HZ_ORG_CONTACTS.PARTY_SITE_ID
HZ_ORG_CONTACTS FK Joins to TableHZ_RELATIONSHIPS HZ_ORG_CONTACTS.PARTY_RELATIONSHIP_ID
TableAMS_EVENT_REGISTRATIONS FK Joins to HZ_ORG_CONTACTS AMS_EVENT_REGISTRATIONS.REGISTRANT_CONTACT_ID
TableAMS_EVENT_REGISTRATIONS FK Joins to HZ_ORG_CONTACTS AMS_EVENT_REGISTRATIONS.ATTENDANT_CONTACT_ID
TableAMS_EVENT_REGISTRATIONS FK Joins to HZ_ORG_CONTACTS AMS_EVENT_REGISTRATIONS.ORIGINAL_REGISTRANT_CONTACT_ID
TableAS_INTERESTS_ALL FK Joins to HZ_ORG_CONTACTS AS_INTERESTS_ALL.CONTACT_ID
TableAS_LEAD_CONTACTS_ALL FK Joins to HZ_ORG_CONTACTS AS_LEAD_CONTACTS_ALL.CONTACT_ID
TableHZ_DQM_SYNC_INTERFACE FK Joins to HZ_ORG_CONTACTS HZ_DQM_SYNC_INTERFACE.ORG_CONTACT_ID
TableHZ_ORG_CONTACT_ROLES FK Joins to HZ_ORG_CONTACTS HZ_ORG_CONTACT_ROLES.ORG_CONTACT_ID
TableHZ_STAGED_CONTACT_POINTS FK Joins to HZ_ORG_CONTACTS HZ_STAGED_CONTACT_POINTS.ORG_CONTACT_ID
TableHZ_STAGED_PARTY_SITES FK Joins to HZ_ORG_CONTACTS HZ_STAGED_PARTY_SITES.ORG_CONTACT_ID
TableJTF_RS_RESOURCE_EXTNS FK Joins to HZ_ORG_CONTACTS JTF_RS_RESOURCE_EXTNS.CONTACT_ID
TableJTF_RS_RESOURCE_EXTN_AUD FK Joins to HZ_ORG_CONTACTS JTF_RS_RESOURCE_EXTN_AUD.NEW_CONTACT_ID
TableJTF_RS_RESOURCE_EXTN_AUD FK Joins to HZ_ORG_CONTACTS JTF_RS_RESOURCE_EXTN_AUD.OLD_CONTACT_ID
TableOE_LINES_IFACE_ALL FK Joins to HZ_ORG_CONTACTS OE_LINES_IFACE_ALL.DELIVER_TO_ORG_CONTACT_ID
TableOE_LINES_IFACE_ALL FK Joins to HZ_ORG_CONTACTS OE_LINES_IFACE_ALL.END_CUSTOMER_ORG_CONTACT_ID
TableOE_LINES_IFACE_ALL FK Joins to HZ_ORG_CONTACTS OE_LINES_IFACE_ALL.INVOICE_TO_ORG_CONTACT_ID
TableOE_LINES_IFACE_ALL FK Joins to HZ_ORG_CONTACTS OE_LINES_IFACE_ALL.SHIP_TO_ORG_CONTACT_ID