FND Design Data [Home] [Help]

Table: OKC_REP_CONTRACTS_ALL

Product: OKC - Contracts Core
Description: This table is the main Contracts table. This table stores the latest version of all contracts authored in Contract Repository.
Implementation/DBA Data: TableOKC.OKC_REP_CONTRACTS_ALL
Primary Key: OKC_REP_CONTRACTS_ALL_PK
  1. ColumnCONTRACT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
OKC_REP_CONTRACTS_ALL FK Joins to TableOKC_BUS_DOC_TYPES_B OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE
OKC_REP_CONTRACTS_ALL FK Joins to TableOKC_REP_CONTACT_ROLES_B OKC_REP_CONTRACTS_ALL.NOTIFY_CONTACT_ROLE_ID
TableOKC_REP_CON_APPROVALS FK Joins to OKC_REP_CONTRACTS_ALL OKC_REP_CON_APPROVALS.CONTRACT_ID
TableOKC_REP_CONTRACT_PARTIES FK Joins to OKC_REP_CONTRACTS_ALL OKC_REP_CONTRACT_PARTIES.CONTRACT_ID
TableOKC_REP_CONTRACT_RELS FK Joins to OKC_REP_CONTRACTS_ALL OKC_REP_CONTRACT_RELS.CONTRACT_ID
TableOKC_REP_PARTY_CONTACTS FK Joins to OKC_REP_CONTRACTS_ALL OKC_REP_PARTY_CONTACTS.CONTRACT_ID
TableOKC_REP_CONTRACT_ACCESS FK Joins to OKC_REP_CONTRACTS_ALL OKC_REP_CONTRACT_ACCESS.CONTRACT_ID
TableOKC_REP_CONTRACT_RELS FK Joins to OKC_REP_CONTRACTS_ALL OKC_REP_CONTRACT_RELS.CONTRACT_ID
TableOKC_REP_CON_STATUS_HIST FK Joins to OKC_REP_CONTRACTS_ALL OKC_REP_CON_STATUS_HIST.CONTRACT_ID