FND Design Data [Home] [Help]

Table: OKE_CHG_REQUESTS

Product: OKE - Project Contracts
Description: stores information about contract change requests
Implementation/DBA Data: TableOKE.OKE_CHG_REQUESTS
Primary Key: OKE_CHG_REQUESTS_PK
  1. ColumnCHG_REQUEST_ID
Primary Key: OKE_CHG_REQUESTS_UK01
  1. ColumnK_HEADER_ID
  2. ColumnCHG_REQUEST_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
OKE_CHG_REQUESTS FK Joins to TableOKE_K_HEADERS OKE_CHG_REQUESTS.K_HEADER_ID
OKE_CHG_REQUESTS FK Joins to TableOKE_CHG_STATUSES_B OKE_CHG_REQUESTS.CHG_STATUS_CODE
OKE_CHG_REQUESTS FK Joins to TableOKE_CHG_LOGS OKE_CHG_REQUESTS.LAST_CHG_LOG_ID
TableOKE_APPROVAL_HISTORY FK Joins to OKE_CHG_REQUESTS OKE_APPROVAL_HISTORY.CHG_REQUEST_ID
TableOKE_CHG_LOGS FK Joins to OKE_CHG_REQUESTS OKE_CHG_LOGS.CHG_REQUEST_ID
TableOKE_K_BILLING_EVENTS FK Joins to OKE_CHG_REQUESTS OKE_K_BILLING_EVENTS.BILL_CHG_REQ_ID
TableOKE_K_COMMUNICATIONS FK Joins to OKE_CHG_REQUESTS OKE_K_COMMUNICATIONS.CHG_REQUEST_ID
TableOKE_K_RELATED_ENTITIES FK Joins to OKE_CHG_REQUESTS OKE_K_RELATED_ENTITIES.CHG_REQUEST_ID
TableOKE_K_VERS_NUMBERS_H FK Joins to OKE_CHG_REQUESTS OKE_K_VERS_NUMBERS_H.CHG_REQUEST_ID
TableOKE_K_VERS_NUMBERS_H FK Joins to OKE_CHG_REQUESTS OKE_K_VERS_NUMBERS_H.CHG_REQUEST_ID