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: OKE.OKE_K_HEADERS_H#

Object Details

Object Name:	OKE_K_HEADERS_H#
Object Type:	VIEW
Owner:	OKE
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
K_HEADER_ID	NUMBER		Yes
MAJOR_VERSION	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
PROGRAM_ID	NUMBER
PROJECT_ID	NUMBER
BOA_ID	NUMBER
K_NUMBER_DISP	VARCHAR2	(240)
K_TYPE_CODE	VARCHAR2	(30)	Yes
PRIORITY_CODE	VARCHAR2	(30)
PRIME_K_ALIAS	VARCHAR2	(30)
PRIME_K_NUMBER	VARCHAR2	(30)
AUTHORIZE_DATE	DATE
AUTHORIZING_REASON	VARCHAR2	(240)
AWARD_CANCEL_DATE	DATE
AWARD_DATE	DATE
DATE_DEFINITIZED	DATE
DATE_ISSUED	DATE
DATE_NEGOTIATED	DATE
DATE_RECEIVED	DATE
DATE_SIGN_BY_CONTRACTOR	DATE
DATE_SIGN_BY_CUSTOMER	DATE
FAA_APPROVE_DATE	DATE
FAA_REJECT_DATE	DATE
BOOKED_FLAG	VARCHAR2	(1)
OPEN_FLAG	VARCHAR2	(1)
CFE_FLAG	VARCHAR2	(1)
VAT_CODE	VARCHAR2	(30)
COUNTRY_OF_ORIGIN_CODE	VARCHAR2	(30)
EXPORT_FLAG	VARCHAR2	(1)
HUMAN_SUBJECT_FLAG	VARCHAR2	(1)
CQA_FLAG	VARCHAR2	(1)
INTERIM_RPT_REQ_FLAG	VARCHAR2	(1)
NO_COMPETITION_AUTHORIZE	VARCHAR2	(80)
PENALTY_CLAUSE_FLAG	VARCHAR2	(1)
PRODUCT_LINE_CODE	VARCHAR2	(30)
REPORTING_FLAG	VARCHAR2	(1)
SB_PLAN_REQ_FLAG	VARCHAR2	(1)
SB_REPORT_FLAG	VARCHAR2	(1)
NTE_AMOUNT	NUMBER
NTE_WARNING_FLAG	VARCHAR2	(1)
BILL_WITHOUT_DEF_FLAG	VARCHAR2	(1)
CAS_FLAG	VARCHAR2	(1)
CLASSIFIED_FLAG	VARCHAR2	(1)
CLIENT_APPROVE_REQ_FLAG	VARCHAR2	(1)
COST_OF_MONEY	VARCHAR2	(1)
DCAA_AUDIT_REQ_FLAG	VARCHAR2	(1)
COST_SHARE_FLAG	VARCHAR2	(1)
OH_RATES_FINAL_FLAG	VARCHAR2	(1)
PROP_DELIVERY_LOCATION	VARCHAR2	(150)
PROP_DUE_DATE_TIME	DATE
PROP_DUE_TIME	VARCHAR2	(80)
PROP_EXPIRE_DATE	DATE
COPIES_REQUIRED	NUMBER
SIC_CODE	VARCHAR2	(30)
TECH_DATA_WH_RATE	NUMBER
PROGRESS_PAYMENT_FLAG	VARCHAR2	(1)
PROGRESS_PAYMENT_LIQ_RATE	NUMBER
PROGRESS_PAYMENT_RATE	NUMBER
ALTERNATE_LIQUIDATION_RATE	NUMBER
DEFINITIZED_FLAG	VARCHAR2	(1)
FINANCIAL_CTRL_VERIFIED_FLAG	VARCHAR2	(1)
COST_OF_SALE_RATE	NUMBER
LINE_VALUE_TOTAL	NUMBER
UNDEF_LINE_VALUE_TOTAL	NUMBER
OWNING_ORGANIZATION_ID	NUMBER
DEFAULT_TASK_ID	NUMBER

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# references the following:

OKE: OKE_K_HEADERS_H

OKE.OKE_K_HEADERS_H# is referenced by following:

APPS: OKE_K_HEADERS_H