eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKE_K_HEADERS_HV

Object Details

Object Name:	OKE_K_HEADERS_HV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKE.OKE_K_HEADERS_HV
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[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
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
K_NUMBER	VARCHAR2	(120)	Yes	Contract document number
K_NUMBER_DISP	VARCHAR2	(240)		Contract document number for display purpose
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_VALUE	NUMBER			Contract Value
PRODUCT_LINE_CODE	VARCHAR2	(30)		Product Line Code
PRIORITY_CODE	VARCHAR2	(30)		Priority rating of contract document
PROGRAM_ID	NUMBER			Program unique identifier
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
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
DCAA_AUDIT_REQ_FLAG	VARCHAR2	(1)		DCAA Audit Required indicator
BOOKED_FLAG	VARCHAR2	(1)		Booked indicator
OPEN_FLAG	VARCHAR2	(1)		Open indicator
EXPORT_FLAG	VARCHAR2	(1)		Export indicator
BOA_ID	NUMBER			Basic Order Agreement unique identifier
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 Contracter
DATE_RECEIVED	DATE			Date Received
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
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
PENALTY_CLAUSE_FLAG	VARCHAR2	(1)		Penalty Clause Applies indicator
SB_PLAN_REQ_FLAG	VARCHAR2	(1)		Small Business Plan Required indicator
SB_REPORT_FLAG	VARCHAR2	(1)		Small Business Report Required indicator
CQA_FLAG	VARCHAR2	(1)		Customer Quality Acceptance Required indicator
REPORTING_FLAG	VARCHAR2	(1)		Reporting Required indicator
CFE_FLAG	VARCHAR2	(1)		Customer Furnished Equipment Required indicator
CURRENCY_CODE	VARCHAR2	(15)		Currency
COUNTRY_OF_ORIGIN_CODE	VARCHAR2	(30)		Country of origin
COST_OF_MONEY	VARCHAR2	(1)		Cost of Money Applies indicator
DATE_DEFINITIZED	DATE			Date Definitized
DATE_NEGOTIATED	DATE			Date Negotiated
COST_SHARE_FLAG	VARCHAR2	(1)		Cost Share indicator
NTE_WARNING_FLAG	VARCHAR2	(1)		Not To Exceed Warning indicator
INTERIM_RPT_REQ_FLAG	VARCHAR2	(1)		Interim report required indicator
CLIENT_APPROVE_REQ_FLAG	VARCHAR2	(1)		Client Approval Required indicator
CAS_FLAG	VARCHAR2	(1)		Cost Accounting Standards Applies indicator
BILL_WITHOUT_DEF_FLAG	VARCHAR2	(1)		Bill Without Definitized indicator
OH_RATES_FINAL_FLAG	VARCHAR2	(1)		Overhead Rates Finalized indicator
NTE_AMOUNT	NUMBER			Not To Exceed Amount
TECH_DATA_WH_RATE	NUMBER			Technical Data Withholding 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 Reponse Required
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
TEMPLATE_YN	VARCHAR2	(3)	Yes	Template indicator
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
DEFAULT_TASK_ID	NUMBER			Task Id of the task to be defaulted on contract lines.
DEFAULT_TASK_NUMBER	VARCHAR2	(25)		Task number of the task to be defaulted on contract lines.

Query Text

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


SELECT ROW_ID
,      K_HEADER_ID
,      MAJOR_VERSION
,      OBJECT_VERSION_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      SCS_CODE
,      AUTHORING_ORG_ID
,      K_NUMBER
,      K_NUMBER_DISP
,      K_ALIAS
,      CHR_TYPE
,      K_TYPE_CODE
,      K_VALUE
,      PRODUCT_LINE_CODE
,      PRIORITY_CODE
,      PROGRAM_ID
,      START_DATE
,      END_DATE
,      BUY_OR_SELL
,      AWARD_DATE
,      STATUS_CODE
,      SHORT_DESCRIPTION
,      DESCRIPTION
,      PRIME_K_ALIAS
,      PRIME_K_NUMBER
,      CLASSIFIED_FLAG
,      DCAA_AUDIT_REQ_FLAG
,      BOOKED_FLAG
,      OPEN_FLAG
,      EXPORT_FLAG
,      BOA_ID
,      AUTHORIZE_DATE
,      SIC_CODE
,      AUTHORIZING_REASON
,      DATE_ISSUED
,      DATE_SIGN_BY_CUSTOMER
,      DATE_SIGN_BY_CONTRACTOR
,      DATE_RECEIVED
,      AWARD_CANCEL_DATE
,      FAA_APPROVE_DATE
,      FAA_REJECT_DATE
,      PROJECT_ID
,      CUSTOMER_PO_NUMBER
,      NO_COMPETITION_AUTHORIZE
,      HUMAN_SUBJECT_FLAG
,      PENALTY_CLAUSE_FLAG
,      SB_PLAN_REQ_FLAG
,      SB_REPORT_FLAG
,      CQA_FLAG
,      REPORTING_FLAG
,      CFE_FLAG
,      CURRENCY_CODE
,      COUNTRY_OF_ORIGIN_CODE
,      COST_OF_MONEY
,      DATE_DEFINITIZED
,      DATE_NEGOTIATED
,      COST_SHARE_FLAG
,      NTE_WARNING_FLAG
,      INTERIM_RPT_REQ_FLAG
,      CLIENT_APPROVE_REQ_FLAG
,      CAS_FLAG
,      BILL_WITHOUT_DEF_FLAG
,      OH_RATES_FINAL_FLAG
,      NTE_AMOUNT
,      TECH_DATA_WH_RATE
,      VAT_CODE
,      PROP_DELIVERY_LOCATION
,      PROP_DUE_DATE_TIME
,      PROP_DUE_TIME
,      PROP_EXPIRE_DATE
,      COPIES_REQUIRED
,      DEFINITIZED_FLAG
,      FINANCIAL_CTRL_VERIFIED_FLAG
,      COST_OF_SALE_RATE
,      LINE_VALUE_TOTAL
,      UNDEF_LINE_VALUE_TOTAL
,      OWNING_ORGANIZATION_ID
,      TEMPLATE_YN
,      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
,      DEFAULT_TASK_ID
,      DEFAULT_TASK_NUMBER
FROM APPS.OKE_K_HEADERS_HV;

Dependencies

[top of page]

APPS.OKE_K_HEADERS_HV references the following:

APPS: OKC_K_HEADERS_ALL_BH; OKC_K_HEADERS_TLH; OKE_K_HEADERS_H; PA_TASKS

APPS.OKE_K_HEADERS_HV is referenced by following:

APPS: OKE_CONTRACT_PRINTING_PKG - show dependent code; OKE_PRINT_CONTRACT_WF - show dependent code