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

VIEW: OKE.OKE_K_HEADERS#

Object Details
Object Name: OKE_K_HEADERS#
Object Type: VIEW
Owner: OKE
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
K_HEADER_ID 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
,      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#;

Dependencies

[top of page]

OKE.OKE_K_HEADERS# references the following:

SchemaOKE
TableOKE_K_HEADERS
OKE.OKE_K_HEADERS# is referenced by following:

SchemaAPPS
SynonymOKE_K_HEADERS