Skip to content

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

VIEW: OKE.OKE_K_LINES_H#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
K_LINE_ID NUMBER
Yes
MAJOR_VERSION NUMBER (4) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

PARENT_LINE_ID NUMBER

PROJECT_ID NUMBER

TASK_ID NUMBER

BILLING_METHOD_CODE VARCHAR2 (30)
INVENTORY_ITEM_ID NUMBER

PRIORITY_CODE VARCHAR2 (30)
CUSTOMER_ITEM_ID NUMBER

DELIVERY_ORDER_FLAG VARCHAR2 (1)
SPLITED_FLAG VARCHAR2 (1)
LINE_QUANTITY NUMBER

DELIVERY_DATE DATE

PROPOSAL_DUE_DATE VARCHAR2 (80)
UNIT_PRICE NUMBER

UOM_CODE VARCHAR2 (30)
BILLABLE_FLAG VARCHAR2 (1)
SHIPPABLE_FLAG VARCHAR2 (1)
SUBCONTRACTED_FLAG VARCHAR2 (1)
COMPLETED_FLAG VARCHAR2 (1)
NSP_FLAG VARCHAR2 (1)
APP_CODE VARCHAR2 (30)
AS_OF_DATE DATE

AUTHORITY VARCHAR2 (30)
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (30)
DROP_SHIPPED_FLAG VARCHAR2 (1)
CUSTOMER_APPROVAL_REQ_FLAG VARCHAR2 (1)
DATE_MATERIAL_REQ DATE

INSPECTION_REQ_FLAG VARCHAR2 (1)
INTERIM_RPT_REQ_FLAG VARCHAR2 (1)
SUBJ_A133_FLAG VARCHAR2 (1)
EXPORT_FLAG VARCHAR2 (1)
CFE_REQ_FLAG VARCHAR2 (1)
COP_REQUIRED_FLAG VARCHAR2 (1)
EXPORT_LICENSE_NUM VARCHAR2 (30)
EXPORT_LICENSE_RES VARCHAR2 (30)
COPIES_REQUIRED NUMBER

CDRL_CATEGORY VARCHAR2 (30)
DATA_ITEM_NAME VARCHAR2 (30)
DATA_ITEM_SUBTITLE VARCHAR2 (30)
DATE_OF_FIRST_SUBMISSION DATE

FREQUENCY VARCHAR2 (30)
REQUIRING_OFFICE VARCHAR2 (30)
DCAA_AUDIT_REQ_FLAG VARCHAR2 (1)
DEFINITIZED_FLAG VARCHAR2 (1)
COST_OF_MONEY VARCHAR2 (1)
BILL_UNDEFINITIZED_FLAG VARCHAR2 (1)
NSN_NUMBER VARCHAR2 (30)
NTE_WARNING_FLAG VARCHAR2 (1)
DISCOUNT_FOR_PAYMENT NUMBER

FINANCIAL_CTRL_FLAG VARCHAR2 (1)
C_SCS_FLAG VARCHAR2 (1)
C_SSR_FLAG VARCHAR2 (1)
PREPAYMENT_AMOUNT NUMBER

PREPAYMENT_PERCENTAGE NUMBER

PROGRESS_PAYMENT_FLAG VARCHAR2 (1)
PROGRESS_PAYMENT_LIQ_RATE NUMBER

PROGRESS_PAYMENT_RATE NUMBER

AWARD_FEE NUMBER

AWARD_FEE_POOL_AMOUNT NUMBER

BASE_FEE NUMBER

CEILING_PRICE NUMBER

CEILING_COST NUMBER

MATERIAL_COST_INDEX VARCHAR2 (30)
LABOR_COST_INDEX VARCHAR2 (30)
COST_OVERRUN_SHARE_RATIO VARCHAR2 (80)
COST_UNDERRUN_SHARE_RATIO VARCHAR2 (80)
CUSTOMERS_PERCENT_IN_ORDER NUMBER

DATE_OF_PRICE_REDETERMIN DATE

ESTIMATED_TOTAL_QUANTITY NUMBER

FEE_AJT_FORMULA VARCHAR2 (30)
FINAL_FEE NUMBER

FINAL_PFT_AJT_FORMULA VARCHAR2 (30)
FIXED_FEE NUMBER

FIXED_QUANTITY NUMBER

INITIAL_FEE NUMBER

INITIAL_PRICE NUMBER

LEVEL_OF_EFFORT_HOURS NUMBER

LINE_LIQUIDATION_RATE NUMBER

MAXIMUM_FEE NUMBER

MAXIMUM_QUANTITY NUMBER

MINIMUM_FEE NUMBER

MINIMUM_QUANTITY NUMBER

NUMBER_OF_OPTIONS NUMBER

REVISED_PRICE NUMBER

TARGET_COST NUMBER

TARGET_DATE_DEFINITIZE DATE

TARGET_FEE NUMBER

TARGET_PRICE NUMBER

TOTAL_ESTIMATED_COST NUMBER

LINE_VALUE NUMBER

COST_OF_SALE_RATE NUMBER

LINE_VALUE_TOTAL NUMBER

UNDEF_UNIT_PRICE NUMBER

UNDEF_LINE_VALUE NUMBER

UNDEF_LINE_VALUE_TOTAL NUMBER

END_DATE DATE

CUSTOMER_ITEM_NUMBER VARCHAR2 (80)
SCHEDULED_DELV_DEFAULT VARCHAR2 (1)
Query Text

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


SELECT K_LINE_ID
,      MAJOR_VERSION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PARENT_LINE_ID
,      PROJECT_ID
,      TASK_ID
,      BILLING_METHOD_CODE
,      INVENTORY_ITEM_ID
,      PRIORITY_CODE
,      CUSTOMER_ITEM_ID
,      DELIVERY_ORDER_FLAG
,      SPLITED_FLAG
,      LINE_QUANTITY
,      DELIVERY_DATE
,      PROPOSAL_DUE_DATE
,      UNIT_PRICE
,      UOM_CODE
,      BILLABLE_FLAG
,      SHIPPABLE_FLAG
,      SUBCONTRACTED_FLAG
,      COMPLETED_FLAG
,      NSP_FLAG
,      APP_CODE
,      AS_OF_DATE
,      AUTHORITY
,      COUNTRY_OF_ORIGIN_CODE
,      DROP_SHIPPED_FLAG
,      CUSTOMER_APPROVAL_REQ_FLAG
,      DATE_MATERIAL_REQ
,      INSPECTION_REQ_FLAG
,      INTERIM_RPT_REQ_FLAG
,      SUBJ_A133_FLAG
,      EXPORT_FLAG
,      CFE_REQ_FLAG
,      COP_REQUIRED_FLAG
,      EXPORT_LICENSE_NUM
,      EXPORT_LICENSE_RES
,      COPIES_REQUIRED
,      CDRL_CATEGORY
,      DATA_ITEM_NAME
,      DATA_ITEM_SUBTITLE
,      DATE_OF_FIRST_SUBMISSION
,      FREQUENCY
,      REQUIRING_OFFICE
,      DCAA_AUDIT_REQ_FLAG
,      DEFINITIZED_FLAG
,      COST_OF_MONEY
,      BILL_UNDEFINITIZED_FLAG
,      NSN_NUMBER
,      NTE_WARNING_FLAG
,      DISCOUNT_FOR_PAYMENT
,      FINANCIAL_CTRL_FLAG
,      C_SCS_FLAG
,      C_SSR_FLAG
,      PREPAYMENT_AMOUNT
,      PREPAYMENT_PERCENTAGE
,      PROGRESS_PAYMENT_FLAG
,      PROGRESS_PAYMENT_LIQ_RATE
,      PROGRESS_PAYMENT_RATE
,      AWARD_FEE
,      AWARD_FEE_POOL_AMOUNT
,      BASE_FEE
,      CEILING_PRICE
,      CEILING_COST
,      MATERIAL_COST_INDEX
,      LABOR_COST_INDEX
,      COST_OVERRUN_SHARE_RATIO
,      COST_UNDERRUN_SHARE_RATIO
,      CUSTOMERS_PERCENT_IN_ORDER
,      DATE_OF_PRICE_REDETERMIN
,      ESTIMATED_TOTAL_QUANTITY
,      FEE_AJT_FORMULA
,      FINAL_FEE
,      FINAL_PFT_AJT_FORMULA
,      FIXED_FEE
,      FIXED_QUANTITY
,      INITIAL_FEE
,      INITIAL_PRICE
,      LEVEL_OF_EFFORT_HOURS
,      LINE_LIQUIDATION_RATE
,      MAXIMUM_FEE
,      MAXIMUM_QUANTITY
,      MINIMUM_FEE
,      MINIMUM_QUANTITY
,      NUMBER_OF_OPTIONS
,      REVISED_PRICE
,      TARGET_COST
,      TARGET_DATE_DEFINITIZE
,      TARGET_FEE
,      TARGET_PRICE
,      TOTAL_ESTIMATED_COST
,      LINE_VALUE
,      COST_OF_SALE_RATE
,      LINE_VALUE_TOTAL
,      UNDEF_UNIT_PRICE
,      UNDEF_LINE_VALUE
,      UNDEF_LINE_VALUE_TOTAL
,      END_DATE
,      CUSTOMER_ITEM_NUMBER
,      SCHEDULED_DELV_DEFAULT
FROM OKE.OKE_K_LINES_H#;

Dependencies

[top of page]

OKE.OKE_K_LINES_H# references the following:

SchemaOKE
TableOKE_K_LINES_H
OKE.OKE_K_LINES_H# is referenced by following:

SchemaAPPS
SynonymOKE_K_LINES_H