[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKE_K_HEADERS |
|---|---|
| Object Type: | TABLE |
| Owner: | OKE |
| FND Design Data: |  OKE.OKE_K_HEADERS
|
| Subobject Name: | |
| Status: | VALID |
A Contract Header stores common information that applies to the entire contract. This would be the top-level structure that would contain Contract Lines. The data is stored in three tables: OKE_K_HEADERS, OKC_K_HEADERS_B and OKC_K_HEADERS_TL.
OKE_K_HEADERS store information that is specific only to Project Contracts. OKC_K_HEADERS_B is the Contracts Core table upon which OKE_K_HEADERS is built and therefore the rows in the two tables have one to one relationships between them. OKC_K_HEADERS_TL store the translated Contracts Core data.
A Contract Header may belong to any of the following type classes:
'Awarded Contract',
'Basic Order Agreement',
'Delivery Order',
'Proposal',
'Solicitation'
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OKE_K_HEADERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 K_HEADER_ID
|
| OKE_K_HEADERS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
K_TYPE_CODE
|
| OKE_K_HEADERS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BOA_ID
|
| OKE_K_HEADERS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_ID
|
| OKE_K_HEADERS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROGRAM_ID
|
| OKE_K_HEADERS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
K_NUMBER_DISP
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| K_HEADER_ID | NUMBER | Yes | Contract document unique identifier | |
| 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 Contractor | ||
| 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 Response 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 the task to be defaulted on contract lines. Used only for defaulting. |
Cut, paste (and edit) the following text to query this object:
SELECT K_HEADER_ID
, 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;
OKE.OKE_K_HEADERS does not reference any database object
OKE.OKE_K_HEADERS is referenced by following:
OKE
OKE_K_HEADERS#
|
|
|
|