OKE Tables (72)

OKE - Project Contracts — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
`OKE_APPROVAL_HISTORY`	15	Contract document approval history
`OKE_APPROVAL_PATHS`	12	Contract document approval hierarchy
`OKE_APPROVAL_PATHS_TL`	11	Language specific information for contract document approval hierarchy
`OKE_APPROVAL_STEPS`	11	Contract document approval hierarchy steps
`OKE_ARTICLE_FLOWDOWNS`	7	holds flowdown setting for the articles by the article subjects
`OKE_ATTRIBUTE_FLOWDOWNS`	8	stores the mappings between the contract attributes and business areas
`OKE_BILLING_METHODS_B`	27	Stores information about billing methods
`OKE_BILLING_METHODS_TL`	10	Contract billing method multi-lingual information
`OKE_CHG_LOGS`	11	stores information about contract change statuses history
`OKE_CHG_REQUESTS`	39	stores information about contract change requests
`OKE_CHG_STATUSES_B`	28	Stores information about change statuses
`OKE_CHG_STATUSES_TL`	10	Contract change request status multi-lingual information
`OKE_CHG_STS_TYPE_FLOWS`	8	Not in use
`OKE_COMM_ACTIONS_B`	27	Stores information about communication actions
`OKE_COMM_ACTIONS_TL`	10	Contract communication actions multi-lingual information
`OKE_COMPILED_ACCESS_RULES`	13	Stores compiled access rules information
`OKE_DEPENDENCIES`	8	Table to store dependencies related to contract deliverables.
`OKE_DOCUMENT_FLOWDOWNS`	7	holds flowdown setting for the attachments by the document categories
`OKE_FUNDING_POOLS`	27	Funding Pool Definition
`OKE_HOLD_STATUSES_B`	26	Stores information about hold statuses
`OKE_HOLD_STATUSES_TL`	10	Contract hold status multi-lingual information
`OKE_K_ACCESS_RULES`	12	Stores access rules for contract roles
`OKE_K_BILLING_EVENTS`	48	Deliverable-based billing events
`OKE_K_BILLING_METHODS`	24	Billing Methods
`OKE_K_BILLING_METHODS_H`	25	Billing Methods (History)
`OKE_K_COMMUNICATIONS`	47	COmmunication Definition
`OKE_K_DELIVERABLES_B`	123	This table stores all deliverable information for Project Contracts
`OKE_K_DELIVERABLES_BH`	124	Historical Contract Deliverable information
`OKE_K_DELIVERABLES_TL`	13	Contract deliverable multi-lingual information
`OKE_K_DELIVERABLES_TLH`	14	Contract deliverable multi-lingual historical information
`OKE_K_FIFO_LOGS`	9	User Contract Document Access FIFO Log
`OKE_K_FORM_HEADERS`	168	Print form header information
`OKE_K_FORM_LINES`	165	Print form line information
`OKE_K_FUNDING_SOURCES`	68	Contract Funding Sources
`OKE_K_FUNDING_SOURCES_H`	69	Contract Funding Sources History
`OKE_K_FUND_ALLOCATIONS`	59	Contract Funding Allocations
`OKE_K_FUND_ALLOCATIONS_H`	60	Contract Funding Allocations History
`OKE_K_HEADERS`	69	Project contract extended header information
`OKE_K_HEADERS_H`	70	Project contract extended header historical information
`OKE_K_HOLDS`	37	Contract hold application and removal information
`OKE_K_LINES`	103	Project contract extended line information
`OKE_K_LINES_H`	104	Project contract extended line historical information
`OKE_K_PRINT_FORMS`	27	Contract Print Forms
`OKE_K_RELATED_ENTITIES`	11	Related Entity Table
`OKE_K_STANDARD_NOTES_B`	27	Contract standard notes information
`OKE_K_STANDARD_NOTES_BH`	28	Contract standard notes historical information
`OKE_K_STANDARD_NOTES_TL`	12	Contract standard notes multi-lingual information
`OKE_K_STANDARD_NOTES_TLH`	13	Contract standard notes multi-lingual historical information
`OKE_K_TERMS`	26	Terms & Conditions
`OKE_K_TERMS_H`	27	Terms & Conditions (History)
`OKE_K_TYPES_B`	27	Stores information about contract document types
`OKE_K_TYPES_TL`	10	Contract document types multi-lingual information
`OKE_K_USER_ATTRIBUTES`	40	User Attributes Header and Lines
`OKE_K_USER_ATTRIBUTES_H`	41	User Attributes Header and Lines (History)
`OKE_K_VERS_NUMBERS_H`	9	Version Information
`OKE_NUMBER_OPTIONS`	42	stores contract document type numbering options
`OKE_OBJECT_ATTRIBUTES_B`	15	Contract attributes
`OKE_OBJECT_ATTRIBUTES_TL`	12	Contract attributes multi-lingual information
`OKE_POOL_PARTIES`	33	Funding Pool Parties
`OKE_PRINT_FORMS_B`	26	Stores information about print forms
`OKE_PRINT_FORMS_TL`	11	Print form multi-lingual information
`OKE_PRIORITY_CODES_B`	25	Stores information about priority codes
`OKE_PRIORITY_CODES_TL`	10	Contract priority rating multi-lingual information
`OKE_PROGRAMS`	28	Stores information about programs
`OKE_ROLE_FUNCTIONS`	7	Allowable functions by role
`OKE_SEARCH_CRITERIA`	10	Table to store user defined search criteria for Authoring filter
`OKE_STD_NOTE_FLOWDOWNS`	7	holds flowdown setting for the standard notes by the standard note types
`OKE_SUBMISSIONS`	9	Table to store subsequent submissions for data item contract deliverables
`OKE_TERMCOND_FLOWDOWNS`	7	holds flowdown setting for the terms & conditions by the term types
`OKE_TERMS_B`	11	Stores information about contract terms
`OKE_TERMS_TL`	11	Contract terms and conditions multi-lingual information
`OKE_VERSION_COMPARE_RESULTS`	16	This table stores the version comparison results.