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


VIEW: APPS.OKE_K_LINES_FULL_V

Object Details
Object Name: OKE_K_LINES_FULL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKE.OKE_K_LINES_FULL_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view shows detailed contract line information, including displayed values for internal codes and checkboxes.


[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

Major version number of contract document
MINOR_VERSION NUMBER
Yes Minor version number of contract document (not currently used)
VERSION_DISP VARCHAR2 (81)
Concatenation of major version and minor version for display purposes
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_STYLE VARCHAR2 (150)
Line Style
LINE_NUMBER VARCHAR2 (150) Yes Contract document line item number
LINE_DESCRIPTION VARCHAR2 (1995)
Contract document line description
STATUS_CODE VARCHAR2 (30) Yes Line Status Code
STATUS VARCHAR2 (90) Yes Line Status
AUTHORING_ORG_ID NUMBER
Yes Contract Authoring Organization
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
PRIORITY_RATING VARCHAR2 (80)
Priority Rating
DELIVERY_DATE DATE

Delivery date
PROPOSAL_DUE_DATE VARCHAR2 (80)
Proposal Due
INVENTORY_ITEM_ID NUMBER

Inventory item unique identifier
ITEM_NUMBER VARCHAR2 (4000)
Item number
ITEM_DESCRIPTION VARCHAR2 (4000)
Item description
PROJECT_ID NUMBER

System generated project unique identifier
PROJECT_NUMBER VARCHAR2 (25)
Project number
PROJECT_NAME VARCHAR2 (30)
Project name
PROJECT_DESCRIPTION VARCHAR2 (250)
Project description
PROJECT_START_DATE DATE

Project Start Date
PROJECT_COMPLETION_DATE DATE

Project Completion Date
PROJECT_ORGANIZATION VARCHAR2 (240)
Project Organization
TASK_ID NUMBER

System generated task unique identifier
TASK_NUMBER VARCHAR2 (25)
Task number
TASK_NAME VARCHAR2 (20)
Task name
TASK_DESCRIPTION VARCHAR2 (250)
Task description
TASK_START_DATE DATE

Task Start Date
TASK_COMPLETION_DATE DATE

Task Completion Date
TASK_ORGANIZATION VARCHAR2 (240)
Task Organization
DELIVERY_ORDER_FLAG VARCHAR2 (1)
Delivery Order indicator
SPLITED_FLAG VARCHAR2 (1)
Splited indicator
LINE_QUANTITY NUMBER

Line Quantity
LINE_VALUE NUMBER

Contract line value
BILLABLE_FLAG VARCHAR2 (1)
Billable flag
BILLABLE_YN VARCHAR2 (4000)
Billable?
COMPLETED_FLAG VARCHAR2 (1)
Completed indicator
COMPLETED_YN VARCHAR2 (4000)
Completed?
EXPORT_FLAG VARCHAR2 (1)
Export indicator
EXPORT_YN VARCHAR2 (4000)
Export?
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
SHIPPABLE_FLAG VARCHAR2 (1)
Shippable indicator
SHIPPABLE_YN VARCHAR2 (4000)
Shippable?
SUBCONTRACTED_FLAG VARCHAR2 (1)
Subcontracted indicator
SUBCONTRACTED_YN VARCHAR2 (4000)
Subcontracted?
NSP_FLAG VARCHAR2 (1)
Not Separately Priced indicator
NSP_YN VARCHAR2 (4000)
Not Separately Priced?
CUSTOMER_APPROVAL_REQ_FLAG VARCHAR2 (1)
Customer approval required indicator
CUSTOMER_APPROVAL_REQ_YN VARCHAR2 (4000)
Customer Approval Required?
COMMENTS VARCHAR2 (1995)
User-entered comments
COST_OF_MONEY VARCHAR2 (1)
Cost of Money Applies indicator
COST_OF_MONEY_YN VARCHAR2 (4000)
Cost of Money Applies?
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_YN VARCHAR2 (4000)
Progress Payment Applies?
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
DCAA_AUDIT_REQ_YN VARCHAR2 (4000)
DCAA Audit Required?
INTERIM_RPT_REQ_FLAG VARCHAR2 (1)
Interim report required indicator
INTERIM_RPT_REQ_YN VARCHAR2 (4000)
Interim Report Required?
BILL_UNDEFINITIZED_FLAG VARCHAR2 (1)
Bill Without Definitized indicator
BILL_UNDEFINITIZED_YN VARCHAR2 (4000)
Bill Without Definitized?
FINANCIAL_CTRL_FLAG VARCHAR2 (1)
Financial Control Verified indicator
FINANCIAL_CTRL_YN VARCHAR2 (4000)
Financial Control Verified?
C_SSR_FLAG VARCHAR2 (1)
Cost Schedule Status Report Applies indicator
C_SSR_YN VARCHAR2 (4000)
Cost Schedule Status Report Applies?
C_SCS_FLAG VARCHAR2 (1)
Cost Schedule Control System Criteria Applies Flag
C_SCS_YN VARCHAR2 (4000)
Cost Schedule Control System Criteria Applies?
BILLING_METHOD_CODE VARCHAR2 (30)
Billing method code
BILLING_METHOD VARCHAR2 (80)
Billing Method
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
DROP_SHIPPED_YN VARCHAR2 (4000)
Drop Shipped?
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 Under-run 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
DEFINITIZED_YN VARCHAR2 (4000)
Definitized?
DATE_OF_PRICE_REDETERMIN DATE

Date of Price Re-determination
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
CUSTOMER_ITEM_NUMBER VARCHAR2 (80)
Customer Item Number
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
NTE_WARNING_YN VARCHAR2 (4000)
Not To Exceed Warning?
COP_REQUIRED_FLAG VARCHAR2 (1)
Certificate of Performance Required indicator
COP_REQUIRED_YN VARCHAR2 (4000)
Certificate of Performance Required?
INSPECTION_REQ_FLAG VARCHAR2 (1)
Inspection required indicator
INSPECTION_REQ_YN VARCHAR2 (4000)
Inspection Required?
SUBJ_A133_FLAG VARCHAR2 (1)
Subject A133 Applies indicator
SUBJ_A133_YN VARCHAR2 (4000)
Subject A133 Applies?
CFE_FLAG VARCHAR2 (1)
Customer Furnished Equipment Required indicator
CFE_YN VARCHAR2 (4000)
Customer Furnished Equipment Required?
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
SCHEDULED_DELV_DEFAULT VARCHAR2 (1)
Scheduled For Deliverable 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
,      MINOR_VERSION
,      VERSION_DISP
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      DISPLAY_SEQUENCE
,      LSE_ID
,      LINE_STYLE
,      LINE_NUMBER
,      LINE_DESCRIPTION
,      STATUS_CODE
,      STATUS
,      AUTHORING_ORG_ID
,      START_DATE
,      END_DATE
,      PRIORITY_CODE
,      PRIORITY_RATING
,      DELIVERY_DATE
,      PROPOSAL_DUE_DATE
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      PROJECT_DESCRIPTION
,      PROJECT_START_DATE
,      PROJECT_COMPLETION_DATE
,      PROJECT_ORGANIZATION
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      TASK_DESCRIPTION
,      TASK_START_DATE
,      TASK_COMPLETION_DATE
,      TASK_ORGANIZATION
,      DELIVERY_ORDER_FLAG
,      SPLITED_FLAG
,      LINE_QUANTITY
,      LINE_VALUE
,      BILLABLE_FLAG
,      BILLABLE_YN
,      COMPLETED_FLAG
,      COMPLETED_YN
,      EXPORT_FLAG
,      EXPORT_YN
,      PARENT_LINE_ID
,      HEADER_ID
,      UNIT_PRICE
,      UOM_CODE
,      SHIPPABLE_FLAG
,      SHIPPABLE_YN
,      SUBCONTRACTED_FLAG
,      SUBCONTRACTED_YN
,      NSP_FLAG
,      NSP_YN
,      CUSTOMER_APPROVAL_REQ_FLAG
,      CUSTOMER_APPROVAL_REQ_YN
,      COMMENTS
,      COST_OF_MONEY
,      COST_OF_MONEY_YN
,      PREPAYMENT_PERCENTAGE
,      PREPAYMENT_AMOUNT
,      BOE_DESCRIPTION
,      PROGRESS_PAYMENT_FLAG
,      PROGRESS_PAYMENT_YN
,      PROGRESS_PAYMENT_LIQ_RATE
,      LINE_LIQUIDATION_RATE
,      PROGRESS_PAYMENT_RATE
,      DISCOUNT_FOR_PAYMENT
,      DCAA_AUDIT_REQ_FLAG
,      DCAA_AUDIT_REQ_YN
,      INTERIM_RPT_REQ_FLAG
,      INTERIM_RPT_REQ_YN
,      BILL_UNDEFINITIZED_FLAG
,      BILL_UNDEFINITIZED_YN
,      FINANCIAL_CTRL_FLAG
,      FINANCIAL_CTRL_YN
,      C_SSR_FLAG
,      C_SSR_YN
,      C_SCS_FLAG
,      C_SCS_YN
,      BILLING_METHOD_CODE
,      BILLING_METHOD
,      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
,      DROP_SHIPPED_YN
,      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
,      DEFINITIZED_YN
,      DATE_OF_PRICE_REDETERMIN
,      INITIAL_PRICE
,      REVISED_PRICE
,      CUSTOMER_PERCENT_IN_ORDER
,      COUNTRY_OF_ORIGIN_CODE
,      CUSTOMER_ITEM_ID
,      CUSTOMER_ITEM_NUMBER
,      APP_CODE
,      NSN_NUMBER
,      AS_OF_DATE
,      DATE_MATERIAL_REQ
,      AUTHORITY
,      NTE_WARNING_FLAG
,      NTE_WARNING_YN
,      COP_REQUIRED_FLAG
,      COP_REQUIRED_YN
,      INSPECTION_REQ_FLAG
,      INSPECTION_REQ_YN
,      SUBJ_A133_FLAG
,      SUBJ_A133_YN
,      CFE_FLAG
,      CFE_YN
,      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
,      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_FULL_V;

Dependencies

[top of page]

APPS.OKE_K_LINES_FULL_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymOKC_K_HEADERS_ALL_B
SynonymOKC_K_LINES_B
SynonymOKC_K_LINES_TL
SynonymOKC_LINE_STYLES_TL
SynonymOKC_STATUSES_TL
SynonymOKE_BILLING_METHODS_TL
SynonymOKE_K_LINES
ViewOKE_K_VERS_NUMBERS_V
SynonymOKE_PRIORITY_CODES_TL
PL/SQL PackageOKE_UTILS - show dependent code
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
APPS.OKE_K_LINES_FULL_V is referenced by following:

SchemaAPPS
Package BodyOKE_COMM_ACT_UTILS - show dependent code
Package BodyOKE_CONTRACT_PRINTING_PKG - show dependent code
ViewOKE_K_LINES_SECURE_V
Package BodyQA_FLEX_UTIL - show dependent code
Package BodyQA_PLAN_ELEMENT_API - show dependent code