[Home] [Help] [Dependency Information]
Object Name: | OKE_K_LINES_FULL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKE.OKE_K_LINES_FULL_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
|
|
|