FND Design Data [Home] [Help]

Table: OKC_K_HEADERS_ALL_B

Product: OKC - Contracts Core
Description: Stores header level attributes of a Contract. It groups all the lines and terms and conditions of a contract
Implementation/DBA Data: TableOKC.OKC_K_HEADERS_ALL_B
Primary Key: CHR_CHR2_UK
  1. ColumnCONTRACT_NUMBER
  2. ColumnCONTRACT_NUMBER_MODIFIER
Primary Key: OKC_K_HEADERS_ALL_B_PK
  1. ColumnID
Foreign Keys
Table
Foreign Table Foreign Key Column
OKC_K_HEADERS_ALL_B FK Joins to TableOKC_K_HEADERS_ALL_B OKC_K_HEADERS_ALL_B.CHR_ID_AWARD
OKC_K_HEADERS_ALL_B FK Joins to TableOKC_K_HEADERS_ALL_B OKC_K_HEADERS_ALL_B.CHR_ID_RENEWED
OKC_K_HEADERS_ALL_B FK Joins to TableOKC_K_HEADERS_ALL_B OKC_K_HEADERS_ALL_B.CHR_ID_RENEWED_TO
OKC_K_HEADERS_ALL_B FK Joins to TableOKC_K_HEADERS_ALL_B OKC_K_HEADERS_ALL_B.CHR_ID_RESPONSE
OKC_K_HEADERS_ALL_B FK Joins to TableOKC_QA_CHECK_LISTS_B OKC_K_HEADERS_ALL_B.QCL_ID
OKC_K_HEADERS_ALL_B FK Joins to TableOKC_SUBCLASSES_B OKC_K_HEADERS_ALL_B.SCS_CODE
OKC_K_HEADERS_ALL_B FK Joins to TableOKC_STATUSES_B OKC_K_HEADERS_ALL_B.STS_CODE
TableOKC_K_GRPINGS FK Joins to OKC_K_HEADERS_ALL_B OKC_K_GRPINGS.INCLUDED_CHR_ID
TableOKC_K_HEADERS_ALL_B FK Joins to OKC_K_HEADERS_ALL_B OKC_K_HEADERS_ALL_B.CHR_ID_AWARD
TableOKC_K_HEADERS_ALL_B FK Joins to OKC_K_HEADERS_ALL_B OKC_K_HEADERS_ALL_B.CHR_ID_RENEWED
TableOKC_K_HEADERS_ALL_B FK Joins to OKC_K_HEADERS_ALL_B OKC_K_HEADERS_ALL_B.CHR_ID_RENEWED_TO
TableOKC_K_HEADERS_ALL_B FK Joins to OKC_K_HEADERS_ALL_B OKC_K_HEADERS_ALL_B.CHR_ID_RESPONSE
TableOKC_OPERATION_LINES FK Joins to OKC_K_HEADERS_ALL_B OKC_OPERATION_LINES.SUBJECT_CHR_ID
TableOKC_OPERATION_LINES FK Joins to OKC_K_HEADERS_ALL_B OKC_OPERATION_LINES.OBJECT_CHR_ID