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

VIEW: APPS.OKE_K_HEADERS_FULL_HV

Object Details
Object Name: OKE_K_HEADERS_FULL_HV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKE.OKE_K_HEADERS_FULL_HV
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view shows more detailed historical contract header information, including displayed values for internal codes and checkboxes.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Database generated row identifier
K_HEADER_ID NUMBER
Yes Contract document unique identifier
MAJOR_VERSION NUMBER
Yes Major version number of contract document
MINOR_VERSION NUMBER

Minor version number of contract document (not currently used)
VERSION_DISP VARCHAR2 (42)
Concatenation of major version and minor version for display purposes
OBJECT_VERSION_NUMBER NUMBER (9) Yes Internal object version number
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract Number Modifier
SCS_CODE VARCHAR2 (30) Yes Contract Category Code
AUTHORING_ORG_ID NUMBER
Yes Contract Authoring (Owning) Organization unique identifier
AUTHORING_ORG VARCHAR2 (240)
Contract Authoring (Owning) Organization
K_NUMBER VARCHAR2 (120) Yes Contract document number
K_ALIAS VARCHAR2 (300)
Contract alias
CHR_TYPE VARCHAR2 (30) Yes OKC Contract Type
K_TYPE_CODE VARCHAR2 (30) Yes Internal identifier for contract document type
K_TYPE VARCHAR2 (80) Yes Contract document type name
TYPE_CLASS_CODE VARCHAR2 (30) Yes Contract document type class code
K_VALUE NUMBER

Contract Value
OWNING_ORGANIZATION_ID NUMBER

Owning Organization unique identifier
OWNING_ORGANIZATION VARCHAR2 (240)
Owning organization name
PRODUCT_LINE_CODE VARCHAR2 (30)
Product Line Code
PRODUCT_LINE VARCHAR2 (80)
Product Line
PRIORITY_CODE VARCHAR2 (30)
Priority rating of contract document
PRIORITY_RATING VARCHAR2 (80)
Priority Rating
PROGRAM_ID NUMBER

Program unique identifier
PROGRAM_NUMBER VARCHAR2 (80)
Program number
START_DATE DATE

Date when contract document becomes effective
END_DATE DATE

Date when contract document is no longer active (expired)
BUY_OR_SELL VARCHAR2 (3)
Contract intent
AWARD_DATE DATE

Contract Award Date
STATUS_CODE VARCHAR2 (30) Yes Contract Status Code
STATUS VARCHAR2 (90) Yes Contract Status
SHORT_DESCRIPTION VARCHAR2 (600)
Short Description
DESCRIPTION VARCHAR2 (1995)
Description of contract document
PRIME_K_ALIAS VARCHAR2 (30)
Prime Contract Alias
PRIME_K_NUMBER VARCHAR2 (30)
Prime Contract Number
CLASSIFIED_FLAG VARCHAR2 (1)
Classified indicator
CLASSIFIED_YN VARCHAR2 (4000)
Classified?
DCAA_AUDIT_REQ_FLAG VARCHAR2 (1)
DCAA Audit Required indicator
DCAA_AUDIT_REQ_YN VARCHAR2 (4000)
DCAA Audit Required?
BOOKED_FLAG VARCHAR2 (1)
Booked indicator
BOOKED_YN VARCHAR2 (4000)
Booked?
OPEN_FLAG VARCHAR2 (1)
Open indicator
OPEN_YN VARCHAR2 (4000)
Open?
EXPORT_FLAG VARCHAR2 (1)
Export indicator
EXPORT_YN VARCHAR2 (4000)
Export Required?
BOA_ID NUMBER

Basic Order Agreement unique identifier
BOA_NUMBER VARCHAR2 (120)
Basic Order Agreement Number
AUTHORIZE_DATE DATE

Authorize Date
SIC_CODE VARCHAR2 (30)
Industry Classification
AUTHORIZING_REASON VARCHAR2 (240)
Authorizing Reason
DATE_ISSUED DATE

Date Issued
DATE_SIGN_BY_CUSTOMER DATE

Date Signed by Customer
DATE_SIGN_BY_CONTRACTOR DATE

Date Signed by Contractor
DATE_RECEIVED DATE

Date Received
DATE_APPROVED DATE

Date Approved
AWARD_CANCEL_DATE DATE

Award Cancel Date
FAA_APPROVE_DATE DATE

First Article Approve Date
FAA_REJECT_DATE DATE

First Article Reject Date
PROJECT_ID NUMBER

System generated project unique identifier
PROJECT_NUMBER VARCHAR2 (25)
Project number
PROJECT_NAME VARCHAR2 (30)
Project name
PROJECT_DESCRIPTION VARCHAR2 (250)
Project description
PROJECT_START_DATE DATE

Project Start Date
PROJECT_COMPLETION_DATE DATE

Project Completion Date
PROJECT_ORGANIZATION VARCHAR2 (240)
Project Organization
CUSTOMER_PO_NUMBER VARCHAR2 (150)
Customer PO Number
NO_COMPETITION_AUTHORIZE VARCHAR2 (80)
Non-competition justification
HUMAN_SUBJECT_FLAG VARCHAR2 (1)
Human Subject Applies indicator
HUMAN_SUBJECT_YN VARCHAR2 (4000)
Human Subject Applies?
PENALTY_CLAUSE_FLAG VARCHAR2 (1)
Penalty Clause Applies indicator
PENALTY_CLAUSE_YN VARCHAR2 (4000)
Penalty Clause Applies?
SB_PLAN_REQ_FLAG VARCHAR2 (1)
Small Business Plan Required indicator
SB_PLAN_REQ_YN VARCHAR2 (4000)
Small Business Plan Required?
SB_REPORT_FLAG VARCHAR2 (1)
Small Business Report Required indicator
SB_REPORT_YN VARCHAR2 (4000)
Small Business Report Required?
CQA_FLAG VARCHAR2 (1)
Customer Quality Acceptance Required indicator
CQA_YN VARCHAR2 (4000)
Customer Quality Acceptance Required?
REPORTING_FLAG VARCHAR2 (1)
Reporting Required indicator
REPORTING_YN VARCHAR2 (4000)
Reporting Required?
CFE_FLAG VARCHAR2 (1)
Customer Furnished Equipment Required indicator
CFE_YN VARCHAR2 (4000)
Customer Furnished Equipment Required?
CURRENCY_CODE VARCHAR2 (15)
Currency
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (30)
Country of origin
COST_OF_MONEY VARCHAR2 (1)
Cost of Money Applies indicator
COST_OF_MONEY_YN VARCHAR2 (4000)
Cost of Money Applies?
DATE_DEFINITIZED DATE

Date Definitized
DATE_NEGOTIATED DATE

Date Negotiated
COST_SHARE_FLAG VARCHAR2 (1)
Cost Share indicator
COST_SHARE_YN VARCHAR2 (4000)
Cost Share?
NTE_WARNING_FLAG VARCHAR2 (1)
Not To Exceed Warning indicator
NTE_WARNING_YN VARCHAR2 (4000)
Not To Exceed Warning?
INTERIM_RPT_REQ_FLAG VARCHAR2 (1)
Interim report required indicator
INTERIM_RPT_REQ_YN VARCHAR2 (4000)
Interim Report Required?
CLIENT_APPROVE_REQ_FLAG VARCHAR2 (1)
Client Approval Required indicator
CLIENT_APPROVE_REQ_YN VARCHAR2 (4000)
Client Approval Required?
CAS_FLAG VARCHAR2 (1)
Cost Accounting Standards Applies indicator
CAS_YN VARCHAR2 (4000)
Cost Accounting Standards Applies?
BILL_WITHOUT_DEF_FLAG VARCHAR2 (1)
Bill Without Definitized indicator
BILL_WITHOUT_DEF_YN VARCHAR2 (4000)
Bill Without Definitized?
OH_RATES_FINAL_FLAG VARCHAR2 (1)
Overhead Rates Finalized indicator
OH_RATES_FINAL_YN VARCHAR2 (4000)
Overhead Rates Finalized?
NTE_AMOUNT NUMBER

Not To Exceed Amount
TECH_DATA_WH_RATE NUMBER

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

Progress Payment Liquidation Rate
PROGRESS_PAYMENT_RATE NUMBER

Progress Payment Rate
ALTERNATE_LIQUIDATION_RATE NUMBER

Alternate Liquidation Rate
VAT_CODE VARCHAR2 (30)
VAT Code
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
DEFINITIZED_FLAG VARCHAR2 (1)
Definitized indicator
DEFINITIZED_YN VARCHAR2 (4000)
Definitized?
FINANCIAL_CTRL_VERIFIED_FLAG VARCHAR2 (1)
Financial Control Verified indicator
FINANCIAL_CTRL_VERIFIED_YN VARCHAR2 (4000)
Financial Control Verified?
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
TEMPLATE_YN VARCHAR2 (3) Yes Template indicator
TEMPLATE_YN_DSP VARCHAR2 (4000)
Template?
QCL_ID NUMBER

Quality Check List unique identifier
TRN_CODE VARCHAR2 (30)
Contract line termination code
ISSUE_OR_RECEIVE VARCHAR2 (3)
Perspective
COMMENTS VARCHAR2 (1995)
User-entered comments
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive flexfield attribute context
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield attribute
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield attribute
FREIGHT_TERMS_CODE VARCHAR2 (4000)
FOB_POINT_CODE VARCHAR2 (4000)
DEFAULT_TASK_ID NUMBER

Task Id of the task to be defaulted on contract lines. Used only for defaulting.
DEFAULT_TASK_NUMBER VARCHAR2 (25)
Task number of the task to be defaulted on contract lines. Used only for defaulting.
Query Text

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


SELECT ROW_ID
,      K_HEADER_ID
,      MAJOR_VERSION
,      MINOR_VERSION
,      VERSION_DISP
,      OBJECT_VERSION_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      SCS_CODE
,      AUTHORING_ORG_ID
,      AUTHORING_ORG
,      K_NUMBER
,      K_ALIAS
,      CHR_TYPE
,      K_TYPE_CODE
,      K_TYPE
,      TYPE_CLASS_CODE
,      K_VALUE
,      OWNING_ORGANIZATION_ID
,      OWNING_ORGANIZATION
,      PRODUCT_LINE_CODE
,      PRODUCT_LINE
,      PRIORITY_CODE
,      PRIORITY_RATING
,      PROGRAM_ID
,      PROGRAM_NUMBER
,      START_DATE
,      END_DATE
,      BUY_OR_SELL
,      AWARD_DATE
,      STATUS_CODE
,      STATUS
,      SHORT_DESCRIPTION
,      DESCRIPTION
,      PRIME_K_ALIAS
,      PRIME_K_NUMBER
,      CLASSIFIED_FLAG
,      CLASSIFIED_YN
,      DCAA_AUDIT_REQ_FLAG
,      DCAA_AUDIT_REQ_YN
,      BOOKED_FLAG
,      BOOKED_YN
,      OPEN_FLAG
,      OPEN_YN
,      EXPORT_FLAG
,      EXPORT_YN
,      BOA_ID
,      BOA_NUMBER
,      AUTHORIZE_DATE
,      SIC_CODE
,      AUTHORIZING_REASON
,      DATE_ISSUED
,      DATE_SIGN_BY_CUSTOMER
,      DATE_SIGN_BY_CONTRACTOR
,      DATE_RECEIVED
,      DATE_APPROVED
,      AWARD_CANCEL_DATE
,      FAA_APPROVE_DATE
,      FAA_REJECT_DATE
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_DESCRIPTION
,      PROJECT_START_DATE
,      PROJECT_COMPLETION_DATE
,      PROJECT_ORGANIZATION
,      CUSTOMER_PO_NUMBER
,      NO_COMPETITION_AUTHORIZE
,      HUMAN_SUBJECT_FLAG
,      HUMAN_SUBJECT_YN
,      PENALTY_CLAUSE_FLAG
,      PENALTY_CLAUSE_YN
,      SB_PLAN_REQ_FLAG
,      SB_PLAN_REQ_YN
,      SB_REPORT_FLAG
,      SB_REPORT_YN
,      CQA_FLAG
,      CQA_YN
,      REPORTING_FLAG
,      REPORTING_YN
,      CFE_FLAG
,      CFE_YN
,      CURRENCY_CODE
,      COUNTRY_OF_ORIGIN_CODE
,      COST_OF_MONEY
,      COST_OF_MONEY_YN
,      DATE_DEFINITIZED
,      DATE_NEGOTIATED
,      COST_SHARE_FLAG
,      COST_SHARE_YN
,      NTE_WARNING_FLAG
,      NTE_WARNING_YN
,      INTERIM_RPT_REQ_FLAG
,      INTERIM_RPT_REQ_YN
,      CLIENT_APPROVE_REQ_FLAG
,      CLIENT_APPROVE_REQ_YN
,      CAS_FLAG
,      CAS_YN
,      BILL_WITHOUT_DEF_FLAG
,      BILL_WITHOUT_DEF_YN
,      OH_RATES_FINAL_FLAG
,      OH_RATES_FINAL_YN
,      NTE_AMOUNT
,      TECH_DATA_WH_RATE
,      PROGRESS_PAYMENT_FLAG
,      PROGRESS_PAYMENT_YN
,      PROGRESS_PAYMENT_LIQ_RATE
,      PROGRESS_PAYMENT_RATE
,      ALTERNATE_LIQUIDATION_RATE
,      VAT_CODE
,      PROP_DELIVERY_LOCATION
,      PROP_DUE_DATE_TIME
,      PROP_DUE_TIME
,      PROP_EXPIRE_DATE
,      COPIES_REQUIRED
,      DEFINITIZED_FLAG
,      DEFINITIZED_YN
,      FINANCIAL_CTRL_VERIFIED_FLAG
,      FINANCIAL_CTRL_VERIFIED_YN
,      COST_OF_SALE_RATE
,      LINE_VALUE_TOTAL
,      UNDEF_LINE_VALUE_TOTAL
,      TEMPLATE_YN
,      TEMPLATE_YN_DSP
,      QCL_ID
,      TRN_CODE
,      ISSUE_OR_RECEIVE
,      COMMENTS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      FREIGHT_TERMS_CODE
,      FOB_POINT_CODE
,      DEFAULT_TASK_ID
,      DEFAULT_TASK_NUMBER
FROM APPS.OKE_K_HEADERS_FULL_HV;

Dependencies

[top of page]

APPS.OKE_K_HEADERS_FULL_HV references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymOKC_K_HEADERS_ALL_B
SynonymOKC_K_HEADERS_ALL_BH
SynonymOKC_K_HEADERS_TLH
SynonymOKC_STATUSES_TL
SynonymOKE_K_HEADERS_H
ViewOKE_K_TYPES_VL
SynonymOKE_PRIORITY_CODES_TL
SynonymOKE_PROGRAMS
PL/SQL PackageOKE_UTILS - show dependent code
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
APPS.OKE_K_HEADERS_FULL_HV is referenced by following:

SchemaAPPS
ViewOKE_K_HEADERS_SECURE_HV