FND Design Data [Home] [Help]

Table: OKC_REP_PARTY_CONTACTS

Product: OKC - Contracts Core
Description: This table stores the contacts for a party in a contract. The contact record can be from PO_VENDOR_CONTACTS, HZ_PARTIES, or PER_PEOPLE_F, depending on the party role of the contact party. A contact whose party has a role of SUPPLIER_ORG c
Implementation/DBA Data: TableOKC.OKC_REP_PARTY_CONTACTS
Primary Key: OKC_REP_PARTY_CONTACTS_PK
  1. ColumnCONTRACT_ID
  2. ColumnPARTY_ID
  3. ColumnPARTY_ROLE_CODE
  4. ColumnCONTACT_ID
  5. ColumnCONTACT_ROLE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
OKC_REP_PARTY_CONTACTS FK Joins to TableOKC_REP_CONTRACTS_ALL OKC_REP_PARTY_CONTACTS.CONTRACT_ID
OKC_REP_PARTY_CONTACTS FK Joins to TableOKC_REP_CONTACT_ROLES_B OKC_REP_PARTY_CONTACTS.CONTACT_ROLE_ID
OKC_REP_PARTY_CONTACTS FK Joins to TableOKC_REP_CONTRACT_PARTIES OKC_REP_PARTY_CONTACTS.CONTRACT_PARTY_ID