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

VIEW: APPS.OKE_K_LINES_HV

Object Details
Object Name: OKE_K_LINES_HV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKE.OKE_K_LINES_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_LINE_ID NUMBER
Yes Contract document line item unique identifier
MAJOR_VERSION NUMBER (4) Yes Major version number of contract document
OBJECT_VERSION_NUMBER NUMBER (9) Yes Internal object version number
SFWT_FLAG VARCHAR2 (3) Yes Multi-lingual indicator (not currently used)
DISPLAY_SEQUENCE NUMBER (7) Yes Display Sequence
LSE_ID NUMBER
Yes Line Style unique identifier
LINE_NUMBER VARCHAR2 (150) Yes Contract document line item number
LINE_DESCRIPTION VARCHAR2 (1995)
Contract document line description
STATUS_CODE VARCHAR2 (30)
Line Status Code
START_DATE DATE

Date when contract line becomes effective
END_DATE DATE

Date when contract line is no longer active (expired)
PRIORITY_CODE VARCHAR2 (30)
Not currently used
DELIVERY_DATE DATE

Delivery date
PROPOSAL_DUE_DATE VARCHAR2 (80)
Proposal Due
INVENTORY_ITEM_ID NUMBER

Inventory item unique identifier
PROJECT_ID NUMBER

System generated project unique identifier
TASK_ID NUMBER

System generated task unique identifier
DELIVERY_ORDER_FLAG VARCHAR2 (1)
Delivery Order indicator
SPLITED_FLAG VARCHAR2 (1)
Splited indicator
LINE_QUANTITY NUMBER

Line Quantity
BILLABLE_FLAG VARCHAR2 (1)
Billable flag
COMPLETED_FLAG VARCHAR2 (1)
Completed indicator
EXPORT_FLAG VARCHAR2 (1)
Export indicator
PARENT_LINE_ID NUMBER

Parent Line unique identifier
HEADER_ID NUMBER
Yes Contract header unique identifier
UNIT_PRICE NUMBER

Unit price
UOM_CODE VARCHAR2 (30)
Unit of measure
LINE_VALUE NUMBER

Contract line value
SHIPPABLE_FLAG VARCHAR2 (1)
Shippable indicator
SUBCONTRACTED_FLAG VARCHAR2 (1)
Subcontracted indicator
NSP_FLAG VARCHAR2 (1)
Not Seperately Priced indicator
CUSTOMER_APPROVAL_REQ_FLAG VARCHAR2 (1)
Customer approval required indicator
COMMENTS VARCHAR2 (1995)
User-entered comments
COST_OF_MONEY VARCHAR2 (1)
Cost of Money Applies indicator
PREPAYMENT_PERCENTAGE NUMBER

Prepayment Percentage
PREPAYMENT_AMOUNT NUMBER

Prepayment Amount
BOE_DESCRIPTION VARCHAR2 (1995)
Basis of Estimate Description
PROGRESS_PAYMENT_FLAG VARCHAR2 (1)
Progress Payment Applies indicator
PROGRESS_PAYMENT_LIQ_RATE NUMBER

Progress Payment Liquidation Rate
LINE_LIQUIDATION_RATE NUMBER

Line Liquidation Rate
PROGRESS_PAYMENT_RATE NUMBER

Progress Payment Rate
DISCOUNT_FOR_PAYMENT NUMBER

Discount for Payment
DCAA_AUDIT_REQ_FLAG VARCHAR2 (1)
DCAA Audit Required indicator
INTERIM_RPT_REQ_FLAG VARCHAR2 (1)
Interim report required indicator
BILL_UNDEFINITIZED_FLAG VARCHAR2 (1)
Bill Without Definitized indicator
FINANCIAL_CTRL_FLAG VARCHAR2 (1)
Financial Control Verified indicator
C_SSR_FLAG VARCHAR2 (1)
Cost Schedule Status Report Applies indicator
C_SCS_FLAG VARCHAR2 (1)
Cost Schedule Control System Criteria Applies Flag
BILLING_METHOD_CODE VARCHAR2 (30)
Billing method code
LEVEL_OF_EFFORT_HOURS NUMBER

Level of Effort Hours
CEILING_PRICE NUMBER

Ceiling Price
CEILING_COST NUMBER

Ceiling Cost
TOTAL_ESTIMATED_COST NUMBER

Total Estimated Cost
AWARD_FEE NUMBER

Award Fee
AWARD_FEE_POOL_AMOUNT NUMBER

Award Fee Pool Amount
BASE_FEE NUMBER

Base Fee
FIXED_FEE NUMBER

Fixed Fee
MAXIMUM_FEE NUMBER

Maximum Fee
MINIMUM_FEE NUMBER

Minimum Fee
INITIAL_FEE NUMBER

Initial Fee
FINAL_FEE NUMBER

Final Fee
DROP_SHIPPED_FLAG VARCHAR2 (1)
Drop shipped indicator
EXPORT_LICENSE_NUM VARCHAR2 (30)
Export License Number
EXPORT_LICENSE_RES VARCHAR2 (30)
Export License Res
MATERIAL_COST_INDEX VARCHAR2 (30)
Material Cost Index
LABOR_COST_INDEX VARCHAR2 (30)
Labor Cost Index
COST_OVERRUN_SHARE_RATIO VARCHAR2 (80)
Cost Overrun Share Ratio
COST_UNDERRUN_SHARE_RATIO VARCHAR2 (80)
Cost Underrun Share Ratio
FEE_AJT_FORMULA VARCHAR2 (30)
Fee Adjustment Formula
FIXED_QUANTITY NUMBER

Fixed Quantity
ESTIMATED_TOTAL_QUANTITY NUMBER

Estimated Total Quantity
MAXIMUM_QUANTITY NUMBER

Maximum Quantity
MINIMUM_QUANTITY NUMBER

Minimum Quantity
NUMBER_OF_OPTIONS NUMBER

Number of Options
TARGET_FEE NUMBER

Target Fee
TARGET_PRICE NUMBER

Target Price
FINAL_PFT_AJT_FORMULA VARCHAR2 (30)
Final Profit Adjustment Formula
TARGET_COST NUMBER

Target Cost
TARGET_DATE_DEFINITIZE DATE

Target Date of Definitization
DEFINITIZED_FLAG VARCHAR2 (1)
Definitized indicator
DATE_OF_PRICE_REDETERMIN DATE

Date of Price Redetermination
INITIAL_PRICE NUMBER

Initial Price
REVISED_PRICE NUMBER

Revised Price
CUSTOMER_PERCENT_IN_ORDER NUMBER

Cost share customer percentage
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (30)
Country of origin
CUSTOMER_ITEM_ID NUMBER

Customer Item unique identifier
APP_CODE VARCHAR2 (30)
Approval Code
NSN_NUMBER VARCHAR2 (30)
National Stock Number
AS_OF_DATE DATE

As of date
DATE_MATERIAL_REQ DATE

Date Material Requested
AUTHORITY VARCHAR2 (30)
Authority
NTE_WARNING_FLAG VARCHAR2 (1)
Not To Exceed Warning indicator
COP_REQUIRED_FLAG VARCHAR2 (1)
Certificate of Performance Required indicator
INSPECTION_REQ_FLAG VARCHAR2 (1)
Inspection required indicator
SUBJ_A133_FLAG VARCHAR2 (1)
Subject A133 Applies indicator
CFE_FLAG VARCHAR2 (1)
Customer Furnished Equipment Required indicator
DATA_ITEM_NAME VARCHAR2 (30)
Data Item Name
CDRL_CATEGORY VARCHAR2 (30)
Data Item Category
DATA_ITEM_SUBTITLE VARCHAR2 (30)
Data Item Subtitle
REQUIRING_OFFICE VARCHAR2 (30)
Requiring Office
FREQUENCY VARCHAR2 (30)
Data Item Frequency
DATE_OF_FIRST_SUBMISSION DATE

Data item first submission date
COPIES_REQUIRED NUMBER

Copies of Data Item Required
COST_OF_SALE_RATE NUMBER

Cost of Sale Rate
LINE_VALUE_TOTAL NUMBER

Line Value Total
UNDEF_UNIT_PRICE NUMBER

Undefinitized Unit Price
UNDEF_LINE_VALUE NUMBER

Undefinitized Line Value
UNDEF_LINE_VALUE_TOTAL NUMBER

Undefinitized Line Value Total
CUSTOMER_ITEM_NUMBER VARCHAR2 (80)
Customer Item Number
SCHEDULED_DELV_DEFAULT VARCHAR2 (1)
Scheduled Delv Default
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
TRN_CODE VARCHAR2 (30)
Contract line termination code
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
Query Text

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


SELECT ROW_ID
,      K_LINE_ID
,      MAJOR_VERSION
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      DISPLAY_SEQUENCE
,      LSE_ID
,      LINE_NUMBER
,      LINE_DESCRIPTION
,      STATUS_CODE
,      START_DATE
,      END_DATE
,      PRIORITY_CODE
,      DELIVERY_DATE
,      PROPOSAL_DUE_DATE
,      INVENTORY_ITEM_ID
,      PROJECT_ID
,      TASK_ID
,      DELIVERY_ORDER_FLAG
,      SPLITED_FLAG
,      LINE_QUANTITY
,      BILLABLE_FLAG
,      COMPLETED_FLAG
,      EXPORT_FLAG
,      PARENT_LINE_ID
,      HEADER_ID
,      UNIT_PRICE
,      UOM_CODE
,      LINE_VALUE
,      SHIPPABLE_FLAG
,      SUBCONTRACTED_FLAG
,      NSP_FLAG
,      CUSTOMER_APPROVAL_REQ_FLAG
,      COMMENTS
,      COST_OF_MONEY
,      PREPAYMENT_PERCENTAGE
,      PREPAYMENT_AMOUNT
,      BOE_DESCRIPTION
,      PROGRESS_PAYMENT_FLAG
,      PROGRESS_PAYMENT_LIQ_RATE
,      LINE_LIQUIDATION_RATE
,      PROGRESS_PAYMENT_RATE
,      DISCOUNT_FOR_PAYMENT
,      DCAA_AUDIT_REQ_FLAG
,      INTERIM_RPT_REQ_FLAG
,      BILL_UNDEFINITIZED_FLAG
,      FINANCIAL_CTRL_FLAG
,      C_SSR_FLAG
,      C_SCS_FLAG
,      BILLING_METHOD_CODE
,      LEVEL_OF_EFFORT_HOURS
,      CEILING_PRICE
,      CEILING_COST
,      TOTAL_ESTIMATED_COST
,      AWARD_FEE
,      AWARD_FEE_POOL_AMOUNT
,      BASE_FEE
,      FIXED_FEE
,      MAXIMUM_FEE
,      MINIMUM_FEE
,      INITIAL_FEE
,      FINAL_FEE
,      DROP_SHIPPED_FLAG
,      EXPORT_LICENSE_NUM
,      EXPORT_LICENSE_RES
,      MATERIAL_COST_INDEX
,      LABOR_COST_INDEX
,      COST_OVERRUN_SHARE_RATIO
,      COST_UNDERRUN_SHARE_RATIO
,      FEE_AJT_FORMULA
,      FIXED_QUANTITY
,      ESTIMATED_TOTAL_QUANTITY
,      MAXIMUM_QUANTITY
,      MINIMUM_QUANTITY
,      NUMBER_OF_OPTIONS
,      TARGET_FEE
,      TARGET_PRICE
,      FINAL_PFT_AJT_FORMULA
,      TARGET_COST
,      TARGET_DATE_DEFINITIZE
,      DEFINITIZED_FLAG
,      DATE_OF_PRICE_REDETERMIN
,      INITIAL_PRICE
,      REVISED_PRICE
,      CUSTOMER_PERCENT_IN_ORDER
,      COUNTRY_OF_ORIGIN_CODE
,      CUSTOMER_ITEM_ID
,      APP_CODE
,      NSN_NUMBER
,      AS_OF_DATE
,      DATE_MATERIAL_REQ
,      AUTHORITY
,      NTE_WARNING_FLAG
,      COP_REQUIRED_FLAG
,      INSPECTION_REQ_FLAG
,      SUBJ_A133_FLAG
,      CFE_FLAG
,      DATA_ITEM_NAME
,      CDRL_CATEGORY
,      DATA_ITEM_SUBTITLE
,      REQUIRING_OFFICE
,      FREQUENCY
,      DATE_OF_FIRST_SUBMISSION
,      COPIES_REQUIRED
,      COST_OF_SALE_RATE
,      LINE_VALUE_TOTAL
,      UNDEF_UNIT_PRICE
,      UNDEF_LINE_VALUE
,      UNDEF_LINE_VALUE_TOTAL
,      CUSTOMER_ITEM_NUMBER
,      SCHEDULED_DELV_DEFAULT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      TRN_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.OKE_K_LINES_HV;

Dependencies

[top of page]

APPS.OKE_K_LINES_HV references the following:

SchemaAPPS
SynonymOKC_K_LINES_BH
SynonymOKC_K_LINES_TLH
SynonymOKE_K_LINES_H
APPS.OKE_K_LINES_HV is referenced by following:

SchemaAPPS
Package BodyOKE_CONTRACT_PRINTING_PKG - show dependent code