[Home] [Help]
[Dependency Information]
[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;
APPS
HR_ALL_ORGANIZATION_UNITS_TL
OKC_K_HEADERS_ALL_B
OKC_K_LINES_B
OKC_K_LINES_TL
OKC_LINE_STYLES_TL
OKC_STATUSES_TL
OKE_BILLING_METHODS_TL
OKE_K_LINES
OKE_K_VERS_NUMBERS_V
OKE_PRIORITY_CODES_TL
OKE_UTILS
- show dependent code
PA_PROJECTS_ALL
PA_TASKS
APPS
OKE_COMM_ACT_UTILS
- show dependent code
OKE_CONTRACT_PRINTING_PKG
- show dependent code
OKE_K_LINES_SECURE_V
QA_FLEX_UTIL
- show dependent code
QA_PLAN_ELEMENT_API
- show dependent code
|
|
|
|