DBA Data[Home] [Help] [Dependency Information]

TABLE: OKE.OKE_K_HEADERS_H

Object Details
Object Name: OKE_K_HEADERS_H
Object Type: TABLE
Owner: OKE
FND Design Data: TableOKE.OKE_K_HEADERS_H
Subobject Name:
Status: VALID


OKE_K_HEADERS_H stores some part of contract header history information, which are specific to Project Contract. Other header information are stored in OKC_K_HEADERS_BH.
Refer to OKE_K_HEADERS for the structure of contract headers.
This is the history table that stores the data associated with each version.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKE_K_HEADERS_H_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnK_HEADER_ID
ColumnMAJOR_VERSION
Columns
Name Datatype Length Mandatory Comments
K_HEADER_ID NUMBER
Yes Contract document unique identifier
MAJOR_VERSION NUMBER
Yes Major version number of contract document
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_ID NUMBER

Program unique identifier
PROJECT_ID NUMBER

System generated project unique identifier
BOA_ID NUMBER

Basic Order Agreement unique identifier
K_NUMBER_DISP VARCHAR2 (240)
Contract document number for display purpose
K_TYPE_CODE VARCHAR2 (30) Yes Internal identifier for contract document type
PRIORITY_CODE VARCHAR2 (30)
Priority rating of contract document
PRIME_K_ALIAS VARCHAR2 (30)
Prime Contract Alias
PRIME_K_NUMBER VARCHAR2 (30)
Prime Contract Number
AUTHORIZE_DATE DATE

Authorize Date
AUTHORIZING_REASON VARCHAR2 (240)
Authorizing Reason
AWARD_CANCEL_DATE DATE

Award Cancel Date
AWARD_DATE DATE

Contract Award Date
DATE_DEFINITIZED DATE

Date Definitized
DATE_ISSUED DATE

Date Issued
DATE_NEGOTIATED DATE

Date Negotiated
DATE_RECEIVED DATE

Date Received
DATE_SIGN_BY_CONTRACTOR DATE

Date Signed by Contracter
DATE_SIGN_BY_CUSTOMER DATE

Date Signed by Customer
FAA_APPROVE_DATE DATE

First Article Approve Date
FAA_REJECT_DATE DATE

First Article Reject Date
BOOKED_FLAG VARCHAR2 (1)
Booked indicator
OPEN_FLAG VARCHAR2 (1)
Open indicator
CFE_FLAG VARCHAR2 (1)
Customer Furnished Equipment Required indicator
VAT_CODE VARCHAR2 (30)
VAT Code
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (30)
Country of origin
EXPORT_FLAG VARCHAR2 (1)
Export indicator
HUMAN_SUBJECT_FLAG VARCHAR2 (1)
Human Subject Applies indicator
CQA_FLAG VARCHAR2 (1)
Customer Quality Acceptance Required indicator
INTERIM_RPT_REQ_FLAG VARCHAR2 (1)
Interim report required indicator
NO_COMPETITION_AUTHORIZE VARCHAR2 (80)
Non-competition justification
PENALTY_CLAUSE_FLAG VARCHAR2 (1)
Penalty Clause Applies indicator
PRODUCT_LINE_CODE VARCHAR2 (30)
Product Line Code
REPORTING_FLAG VARCHAR2 (1)
Reporting Required indicator
SB_PLAN_REQ_FLAG VARCHAR2 (1)
Small Business Plan Required indicator
SB_REPORT_FLAG VARCHAR2 (1)
Small Business Report Required indicator
NTE_AMOUNT NUMBER

Not To Exceed Amount
NTE_WARNING_FLAG VARCHAR2 (1)
Not To Exceed Warning indicator
BILL_WITHOUT_DEF_FLAG VARCHAR2 (1)
Bill Without Definitized indicator
CAS_FLAG VARCHAR2 (1)
Cost Accounting Standards Applies indicator
CLASSIFIED_FLAG VARCHAR2 (1)
Classified indicator
CLIENT_APPROVE_REQ_FLAG VARCHAR2 (1)
Client Approval Required indicator
COST_OF_MONEY VARCHAR2 (1)
Cost of Money Applies indicator
DCAA_AUDIT_REQ_FLAG VARCHAR2 (1)
DCAA Audit Required indicator
COST_SHARE_FLAG VARCHAR2 (1)
Cost Share indicator
OH_RATES_FINAL_FLAG VARCHAR2 (1)
Overhead Rates Finalized indicator
PROP_DELIVERY_LOCATION VARCHAR2 (150)
Proposal Delivery Location
PROP_DUE_DATE_TIME DATE

Proposal Due Date
PROP_DUE_TIME VARCHAR2 (80)
Proposal Due
PROP_EXPIRE_DATE DATE

Proposal Expiry Date
COPIES_REQUIRED NUMBER

Copies of Reponse Required
SIC_CODE VARCHAR2 (30)
Industry Classification
TECH_DATA_WH_RATE NUMBER

Technical Data Withholding Rate
PROGRESS_PAYMENT_FLAG VARCHAR2 (1)
Progress Payment Applies indicator
PROGRESS_PAYMENT_LIQ_RATE NUMBER

Progress Payment Liquidation Rate
PROGRESS_PAYMENT_RATE NUMBER

Progress Payment Rate
ALTERNATE_LIQUIDATION_RATE NUMBER

Alternate Liquidation Rate
DEFINITIZED_FLAG VARCHAR2 (1)
Definitized indicator
FINANCIAL_CTRL_VERIFIED_FLAG VARCHAR2 (1)
Financial Control Verified indicator
COST_OF_SALE_RATE NUMBER

Cost of Sale Rate
LINE_VALUE_TOTAL NUMBER

Line Value Total
UNDEF_LINE_VALUE_TOTAL NUMBER

Undefinitized Line Value Total
OWNING_ORGANIZATION_ID NUMBER

Owning Organization ID
DEFAULT_TASK_ID NUMBER

Task Id of task to be defaulted on contract lines. Used only for defaulting on line.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT K_HEADER_ID
,      MAJOR_VERSION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROJECT_ID
,      BOA_ID
,      K_NUMBER_DISP
,      K_TYPE_CODE
,      PRIORITY_CODE
,      PRIME_K_ALIAS
,      PRIME_K_NUMBER
,      AUTHORIZE_DATE
,      AUTHORIZING_REASON
,      AWARD_CANCEL_DATE
,      AWARD_DATE
,      DATE_DEFINITIZED
,      DATE_ISSUED
,      DATE_NEGOTIATED
,      DATE_RECEIVED
,      DATE_SIGN_BY_CONTRACTOR
,      DATE_SIGN_BY_CUSTOMER
,      FAA_APPROVE_DATE
,      FAA_REJECT_DATE
,      BOOKED_FLAG
,      OPEN_FLAG
,      CFE_FLAG
,      VAT_CODE
,      COUNTRY_OF_ORIGIN_CODE
,      EXPORT_FLAG
,      HUMAN_SUBJECT_FLAG
,      CQA_FLAG
,      INTERIM_RPT_REQ_FLAG
,      NO_COMPETITION_AUTHORIZE
,      PENALTY_CLAUSE_FLAG
,      PRODUCT_LINE_CODE
,      REPORTING_FLAG
,      SB_PLAN_REQ_FLAG
,      SB_REPORT_FLAG
,      NTE_AMOUNT
,      NTE_WARNING_FLAG
,      BILL_WITHOUT_DEF_FLAG
,      CAS_FLAG
,      CLASSIFIED_FLAG
,      CLIENT_APPROVE_REQ_FLAG
,      COST_OF_MONEY
,      DCAA_AUDIT_REQ_FLAG
,      COST_SHARE_FLAG
,      OH_RATES_FINAL_FLAG
,      PROP_DELIVERY_LOCATION
,      PROP_DUE_DATE_TIME
,      PROP_DUE_TIME
,      PROP_EXPIRE_DATE
,      COPIES_REQUIRED
,      SIC_CODE
,      TECH_DATA_WH_RATE
,      PROGRESS_PAYMENT_FLAG
,      PROGRESS_PAYMENT_LIQ_RATE
,      PROGRESS_PAYMENT_RATE
,      ALTERNATE_LIQUIDATION_RATE
,      DEFINITIZED_FLAG
,      FINANCIAL_CTRL_VERIFIED_FLAG
,      COST_OF_SALE_RATE
,      LINE_VALUE_TOTAL
,      UNDEF_LINE_VALUE_TOTAL
,      OWNING_ORGANIZATION_ID
,      DEFAULT_TASK_ID
FROM OKE.OKE_K_HEADERS_H;

Dependencies

[top of page]

OKE.OKE_K_HEADERS_H does not reference any database object

OKE.OKE_K_HEADERS_H is referenced by following:

SchemaOKE
ViewOKE_K_HEADERS_H#