FND Design Data [Home] [Help]

Table: OKC_K_HEADERS_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: Not implemented in this database
Primary Key: CHR_CHR2_UK
  1. ColumnCONTRACT_NUMBER
  2. ColumnCONTRACT_NUMBER_MODIFIER
Primary Key: OKC_K_HEADERS_B_PK
  1. ColumnID
Foreign Keys
Table
Foreign Table Foreign Key Column
OKC_K_HEADERS_B FK Joins to TableOKC_K_HEADERS_B OKC_K_HEADERS_B.CHR_ID_AWARD
OKC_K_HEADERS_B FK Joins to TableOKC_K_HEADERS_B OKC_K_HEADERS_B.CHR_ID_RENEWED
OKC_K_HEADERS_B FK Joins to TableOKC_K_HEADERS_B OKC_K_HEADERS_B.CHR_ID_RENEWED_TO
OKC_K_HEADERS_B FK Joins to TableOKC_K_HEADERS_B OKC_K_HEADERS_B.CHR_ID_RESPONSE
OKC_K_HEADERS_B FK Joins to TableOKC_QA_CHECK_LISTS_B OKC_K_HEADERS_B.QCL_ID
OKC_K_HEADERS_B FK Joins to TableOKC_SUBCLASSES_B OKC_K_HEADERS_B.SCS_CODE
OKC_K_HEADERS_B FK Joins to TableOKC_STATUSES_B OKC_K_HEADERS_B.STS_CODE
TableAHL_OSP_ORDERS_B FK Joins to OKC_K_HEADERS_B AHL_OSP_ORDERS_B.CONTRACT_ID
TableAR_RAMC_AUDIT_TRAIL FK Joins to OKC_K_HEADERS_B AR_RAMC_AUDIT_TRAIL.CONTRACT_ID
TableOKS_K_ORDER_DETAILS FK Joins to OKC_K_HEADERS_B OKS_K_ORDER_DETAILS.CHR_ID
TableOKS_K_ORDER_DETAILS FK Joins to OKC_K_HEADERS_B OKS_K_ORDER_DETAILS.LINK_CHR_ID
TableOKS_INTERACTION_HISTORY FK Joins to OKC_K_HEADERS_B OKS_INTERACTION_HISTORY.CHR_ID
TableOKC_PRICE_ADJUSTMENTS_H FK Joins to OKC_K_HEADERS_B OKC_PRICE_ADJUSTMENTS_H.CHR_ID
TableOKC_PRICE_ATT_VALUES_H FK Joins to OKC_K_HEADERS_B OKC_PRICE_ATT_VALUES_H.CHR_ID
TableOKC_K_ACCESSES FK Joins to OKC_K_HEADERS_B OKC_K_ACCESSES.CHR_ID
TableOKC_K_GRPINGS FK Joins to OKC_K_HEADERS_B OKC_K_GRPINGS.INCLUDED_CHR_ID
TableOKC_K_HEADERS_B FK Joins to OKC_K_HEADERS_B OKC_K_HEADERS_B.CHR_ID_AWARD
TableOKC_K_HEADERS_B FK Joins to OKC_K_HEADERS_B OKC_K_HEADERS_B.CHR_ID_RENEWED
TableOKC_K_HEADERS_B FK Joins to OKC_K_HEADERS_B OKC_K_HEADERS_B.CHR_ID_RENEWED_TO
TableOKC_K_HEADERS_B FK Joins to OKC_K_HEADERS_B OKC_K_HEADERS_B.CHR_ID_RESPONSE
TableOKC_K_ITEMS FK Joins to OKC_K_HEADERS_B OKC_K_ITEMS.CHR_ID
TableOKC_K_LINES_B FK Joins to OKC_K_HEADERS_B OKC_K_LINES_B.CHR_ID
TableOKC_K_PARTY_ROLES_B FK Joins to OKC_K_HEADERS_B OKC_K_PARTY_ROLES_B.CHR_ID
TableOKC_K_PROCESSES FK Joins to OKC_K_HEADERS_B OKC_K_PROCESSES.CHR_ID
TableOKC_K_REL_OBJS FK Joins to OKC_K_HEADERS_B OKC_K_REL_OBJS.CHR_ID
TableOKC_CHANGE_REQUESTS_B FK Joins to OKC_K_HEADERS_B OKC_CHANGE_REQUESTS_B.CHR_ID
TableOKC_K_VERS_NUMBERS FK Joins to OKC_K_HEADERS_B OKC_K_VERS_NUMBERS.CHR_ID
TableOKC_GOVERNANCES FK Joins to OKC_K_HEADERS_B OKC_GOVERNANCES.CHR_ID
TableOKC_GOVERNANCES FK Joins to OKC_K_HEADERS_B OKC_GOVERNANCES.CHR_ID_REFERRED
TableOKC_K_HISTORY_B FK Joins to OKC_K_HEADERS_B OKC_K_HISTORY_B.CHR_ID
TableOKC_K_SALES_CREDITS_H FK Joins to OKC_K_HEADERS_B OKC_K_SALES_CREDITS_H.CHR_ID
TableOKC_K_SALES_CREDITS_H FK Joins to OKC_K_HEADERS_B OKC_K_SALES_CREDITS_H.DNZ_CHR_ID
TableOKC_K_SALES_CREDITS FK Joins to OKC_K_HEADERS_B OKC_K_SALES_CREDITS.CHR_ID
TableOKC_K_SALES_CREDITS FK Joins to OKC_K_HEADERS_B OKC_K_SALES_CREDITS.DNZ_CHR_ID
TableOKC_OPERATION_INSTANCES FK Joins to OKC_K_HEADERS_B OKC_OPERATION_INSTANCES.TARGET_CHR_ID
TableOKC_OPERATION_LINES FK Joins to OKC_K_HEADERS_B OKC_OPERATION_LINES.SUBJECT_CHR_ID
TableOKC_OPERATION_LINES FK Joins to OKC_K_HEADERS_B OKC_OPERATION_LINES.OBJECT_CHR_ID
TableOKC_PRICE_ADJUSTMENTS FK Joins to OKC_K_HEADERS_B OKC_PRICE_ADJUSTMENTS.CHR_ID
TableOKC_PRICE_ATT_VALUES FK Joins to OKC_K_HEADERS_B OKC_PRICE_ATT_VALUES.CHR_ID
TableOKC_RULE_GROUPS_B FK Joins to OKC_K_HEADERS_B OKC_RULE_GROUPS_B.CHR_ID
TableOKC_SECTIONS_B FK Joins to OKC_K_HEADERS_B OKC_SECTIONS_B.CHR_ID
TableOKC_USER_BINS FK Joins to OKC_K_HEADERS_B OKC_USER_BINS.CONTRACT_ID
TableOKE_K_HEADERS FK Joins to OKC_K_HEADERS_B OKE_K_HEADERS.K_HEADER_ID
TableOKL_TAX_SOURCES FK Joins to OKC_K_HEADERS_B OKL_TAX_SOURCES.KHR_ID
TableOKR_IP_ITEM_RELS_B FK Joins to OKC_K_HEADERS_B OKR_IP_ITEM_RELS_B.CHR_ID
TableOKR_IP_RELATIONS_B FK Joins to OKC_K_HEADERS_B OKR_IP_RELATIONS_B.KHR_ID
TableOKS_K_ORDER_DETAILS FK Joins to OKC_K_HEADERS_B OKS_K_ORDER_DETAILS.CHR_ID
TableOKS_K_ORDER_DETAILS FK Joins to OKC_K_HEADERS_B OKS_K_ORDER_DETAILS.LINK_CHR_ID
TableOKS_K_HEADERS_B FK Joins to OKC_K_HEADERS_B OKS_K_HEADERS_B.CHR_ID
TableOKS_K_SALES_CREDITS FK Joins to OKC_K_HEADERS_B OKS_K_SALES_CREDITS.CHR_ID
TablePV_PG_ENRL_REQUESTS FK Joins to OKC_K_HEADERS_B PV_PG_ENRL_REQUESTS.CONTRACT_ID
TableRA_CUSTOMER_TRX_ALL FK Joins to OKC_K_HEADERS_B RA_CUSTOMER_TRX_ALL.CONTRACT_ID
TableRA_INTERFACE_LINES_ALL FK Joins to OKC_K_HEADERS_B RA_INTERFACE_LINES_ALL.CONTRACT_ID