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

VIEW: APPS.OKE_K_LINES_FWDN_V

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


This view is similar to OKE_K_LINES_SECURE_V, but with currency information properly formatted for display in the flow down viewer.


[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
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 VARCHAR2 (4000)
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 VARCHAR2 (4000)
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 VARCHAR2 (4000)
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 VARCHAR2 (4000)
Ceiling Price
CEILING_COST VARCHAR2 (4000)
Ceiling Cost
TOTAL_ESTIMATED_COST VARCHAR2 (4000)
Total Estimated Cost
AWARD_FEE VARCHAR2 (4000)
Award Fee
AWARD_FEE_POOL_AMOUNT VARCHAR2 (4000)
Award Fee Pool Amount
BASE_FEE VARCHAR2 (4000)
Base Fee
FIXED_FEE VARCHAR2 (4000)
Fixed Fee
MAXIMUM_FEE VARCHAR2 (4000)
Maximum Fee
MINIMUM_FEE VARCHAR2 (4000)
Minimum Fee
INITIAL_FEE VARCHAR2 (4000)
Initial Fee
FINAL_FEE VARCHAR2 (4000)
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 VARCHAR2 (4000)
Target Fee
TARGET_PRICE VARCHAR2 (4000)
Target Price
FINAL_PFT_AJT_FORMULA VARCHAR2 (30)
Final Profit Adjustment Formula
TARGET_COST VARCHAR2 (4000)
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 VARCHAR2 (4000)
Initial Price
REVISED_PRICE VARCHAR2 (4000)
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
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
,      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
,      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_FWDN_V;

Dependencies

[top of page]

APPS.OKE_K_LINES_FWDN_V references the following:

SchemaAPPS
ViewOKE_K_LINES_SECURE_V
PL/SQL PackageOKE_K_SECURITY_PKG - show dependent code
PL/SQL PackageOKE_UTILS - show dependent code

APPS.OKE_K_LINES_FWDN_V is not referenced by any database object