FND Design Data [Home] [Help]

Table: OKC_REP_CONTRACT_PARTIES

Product: OKC - Contracts Core
Description: This table stores the Parties in a Contract. The Party can be from PO_VENDORS, HZ_PARTIES, or HR_ALL_ORGANIZATION_UNITS. A PARTY_ID with a PARTY_ROLE_CODE of SUPPLIER-ORG comes from PO_VENDORS; A PARTY_ID with a PARTY_ROLE_CODE of CUSTOMER
Implementation/DBA Data: TableOKC.OKC_REP_CONTRACT_PARTIES
Primary Key: OKC_REP_CONTRACT_PARTIES_PK
  1. ColumnCONTRACT_ID
  2. ColumnPARTY_ID
  3. ColumnPARTY_ROLE_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
OKC_REP_CONTRACT_PARTIES FK Joins to TableOKC_REP_CONTRACTS_ALL OKC_REP_CONTRACT_PARTIES.CONTRACT_ID
TableOKC_REP_PARTY_CONTACTS FK Joins to OKC_REP_CONTRACT_PARTIES OKC_REP_PARTY_CONTACTS.CONTRACT_PARTY_ID