[Home] [Help] [Dependency Information]
Object Name: | OKE_K_LINES_SECURE_HV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKE.OKE_K_LINES_SECURE_HV |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This secured view is used for controlling line level field access for archived contract. When shipped, this view does not contain attribute security logic.This basic version of this view is provided for compilation and code generation purposes. Upon completion of the security access rule definitions, this view get generated dynamically using the Generate Security Views process.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Database generated row identifier | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
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 | |
MAJOR_VERSION | NUMBER | (4) | Yes | Major version number of contract document |
MINOR_VERSION | NUMBER | Minor version number of contract document (not currently used) | ||
VERSION_DISP | VARCHAR2 | (42) | Concatenation of major version and minor version for display purposes | |
APP_CODE | VARCHAR2 | (30) | Approval Code | |
AS_OF_DATE | DATE | As of date | ||
AUTHORITY | VARCHAR2 | (30) | Authority | |
AWARD_FEE | NUMBER | Award Fee | ||
AWARD_FEE_POOL_AMOUNT | NUMBER | Award Fee Pool Amount | ||
BASE_FEE | NUMBER | Base Fee | ||
BILLABLE_FLAG | VARCHAR2 | (1) | Billable flag | |
BILLABLE_YN | VARCHAR2 | (4000) | Billable? | |
BILLING_METHOD | VARCHAR2 | (80) | Billing Method | |
BILLING_METHOD_CODE | VARCHAR2 | (30) | Billing method code | |
BILL_UNDEFINITIZED_FLAG | VARCHAR2 | (1) | Bill Without Definitized indicator | |
BILL_UNDEFINITIZED_YN | VARCHAR2 | (4000) | Bill Without Definitized? | |
BOE_DESCRIPTION | VARCHAR2 | (1995) | Basis of Estimate Description | |
CDRL_CATEGORY | VARCHAR2 | (30) | Data Item Category | |
CEILING_COST | NUMBER | Ceiling Cost | ||
CEILING_PRICE | NUMBER | Ceiling Price | ||
CFE_FLAG | VARCHAR2 | (1) | Customer Furnished Equipment Required indicator | |
CFE_YN | VARCHAR2 | (4000) | Customer Furnished Equipment Required? | |
COMMENTS | VARCHAR2 | (1995) | User-entered comments | |
COMPLETED_FLAG | VARCHAR2 | (1) | Completed indicator | |
COMPLETED_YN | VARCHAR2 | (4000) | Completed? | |
COPIES_REQUIRED | NUMBER | Copies of Data Item Required | ||
COP_REQUIRED_FLAG | VARCHAR2 | (1) | Certificate of Performance Required indicator | |
COP_REQUIRED_YN | VARCHAR2 | (4000) | Certificate of Performance Required? | |
COST_OF_MONEY | VARCHAR2 | (1) | Cost of Money Applies indicator | |
COST_OF_MONEY_YN | VARCHAR2 | (4000) | Cost of Money Applies? | |
COST_OF_SALE_RATE | NUMBER | Cost of Sale Rate | ||
COST_OVERRUN_SHARE_RATIO | VARCHAR2 | (80) | Cost Overrun Share Ratio | |
COST_UNDERRUN_SHARE_RATIO | VARCHAR2 | (80) | Cost Under-run Share Ratio | |
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (30) | Country of origin | |
CUSTOMER_APPROVAL_REQ_FLAG | VARCHAR2 | (1) | Customer approval required indicator | |
CUSTOMER_APPROVAL_REQ_YN | VARCHAR2 | (4000) | Customer Approval Required? | |
CUSTOMER_ITEM_ID | NUMBER | Customer Item unique identifier | ||
CUSTOMER_ITEM_NUMBER | VARCHAR2 | (80) | Customer Item Number | |
CUSTOMER_PERCENT_IN_ORDER | NUMBER | Cost share customer percentage | ||
C_SCS_FLAG | VARCHAR2 | (1) | Cost Schedule Control System Criteria Applies Flag | |
C_SCS_YN | VARCHAR2 | (4000) | Cost Schedule Control System Criteria Applies? | |
C_SSR_FLAG | VARCHAR2 | (1) | Cost Schedule Status Report Applies indicator | |
C_SSR_YN | VARCHAR2 | (4000) | Cost Schedule Status Report Applies? | |
DATA_ITEM_NAME | VARCHAR2 | (30) | Data Item Name | |
DATA_ITEM_SUBTITLE | VARCHAR2 | (30) | Data Item Subtitle | |
DATE_MATERIAL_REQ | DATE | Date Material Requested | ||
DATE_OF_FIRST_SUBMISSION | DATE | Data item first submission date | ||
DATE_OF_PRICE_REDETERMIN | DATE | Date of Price Re-determination | ||
DCAA_AUDIT_REQ_FLAG | VARCHAR2 | (1) | DCAA Audit Required indicator | |
DCAA_AUDIT_REQ_YN | VARCHAR2 | (4000) | DCAA Audit Required? | |
DEFINITIZED_FLAG | VARCHAR2 | (1) | Definitized indicator | |
DEFINITIZED_YN | VARCHAR2 | (4000) | Definitized? | |
DELIVERY_DATE | DATE | Delivery date | ||
DELIVERY_ORDER_FLAG | VARCHAR2 | (1) | Delivery Order indicator | |
DISCOUNT_FOR_PAYMENT | NUMBER | Discount for Payment | ||
DISPLAY_SEQUENCE | NUMBER | (7) | Yes | Display Sequence |
DROP_SHIPPED_FLAG | VARCHAR2 | (1) | Drop shipped indicator | |
DROP_SHIPPED_YN | VARCHAR2 | (4000) | Drop Shipped? | |
END_DATE | DATE | Date when contract line is no longer active (expired) | ||
ESTIMATED_TOTAL_QUANTITY | NUMBER | Estimated Total Quantity | ||
EXPORT_FLAG | VARCHAR2 | (1) | Export indicator | |
EXPORT_LICENSE_NUM | VARCHAR2 | (30) | Export License Number | |
EXPORT_LICENSE_RES | VARCHAR2 | (30) | Export License Res | |
EXPORT_YN | VARCHAR2 | (4000) | Export? | |
FEE_AJT_FORMULA | VARCHAR2 | (30) | Fee Adjustment Formula | |
FINAL_FEE | NUMBER | Final Fee | ||
FINAL_PFT_AJT_FORMULA | VARCHAR2 | (30) | Final Profit Adjustment Formula | |
FINANCIAL_CTRL_FLAG | VARCHAR2 | (1) | Financial Control Verified indicator | |
FINANCIAL_CTRL_YN | VARCHAR2 | (4000) | Financial Control Verified? | |
FIXED_FEE | NUMBER | Fixed Fee | ||
FIXED_QUANTITY | NUMBER | Fixed Quantity | ||
FREQUENCY | VARCHAR2 | (30) | Data Item Frequency | |
HEADER_ID | NUMBER | Yes | Contract header unique identifier | |
INITIAL_FEE | NUMBER | Initial Fee | ||
INITIAL_PRICE | NUMBER | Initial Price | ||
INSPECTION_REQ_FLAG | VARCHAR2 | (1) | Inspection required indicator | |
INSPECTION_REQ_YN | VARCHAR2 | (4000) | Inspection Required? | |
INTERIM_RPT_REQ_FLAG | VARCHAR2 | (1) | Interim report required indicator | |
INTERIM_RPT_REQ_YN | VARCHAR2 | (4000) | Interim Report Required? | |
INVENTORY_ITEM_ID | NUMBER | Inventory item unique identifier | ||
ITEM_DESCRIPTION | VARCHAR2 | (4000) | Item description | |
ITEM_NUMBER | VARCHAR2 | (4000) | Item number | |
K_LINE_ID | NUMBER | Yes | Contract document line item unique identifier | |
LABOR_COST_INDEX | VARCHAR2 | (30) | Labor Cost Index | |
LEVEL_OF_EFFORT_HOURS | NUMBER | Level of Effort Hours | ||
LINE_DESCRIPTION | VARCHAR2 | (1995) | Contract document line description | |
LINE_LIQUIDATION_RATE | NUMBER | Line Liquidation Rate | ||
LINE_NUMBER | VARCHAR2 | (150) | Yes | Contract document line item number |
LINE_QUANTITY | NUMBER | Line Quantity | ||
LINE_STYLE | VARCHAR2 | (150) | Line Style | |
LINE_VALUE | NUMBER | Contract line value | ||
LINE_VALUE_TOTAL | NUMBER | Line Value Total | ||
LSE_ID | NUMBER | Yes | Line Style unique identifier | |
MATERIAL_COST_INDEX | VARCHAR2 | (30) | Material Cost Index | |
MAXIMUM_FEE | NUMBER | Maximum Fee | ||
MAXIMUM_QUANTITY | NUMBER | Maximum Quantity | ||
MINIMUM_FEE | NUMBER | Minimum Fee | ||
MINIMUM_QUANTITY | NUMBER | Minimum Quantity | ||
NSN_NUMBER | VARCHAR2 | (30) | National Stock Number | |
NSP_FLAG | VARCHAR2 | (1) | Not Separately Priced indicator | |
NSP_YN | VARCHAR2 | (4000) | Not Separately Priced? | |
NTE_WARNING_FLAG | VARCHAR2 | (1) | Not To Exceed Warning indicator | |
NTE_WARNING_YN | VARCHAR2 | (4000) | Not To Exceed Warning? | |
NUMBER_OF_OPTIONS | NUMBER | Number of Options | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Internal object version number |
PARENT_LINE_ID | NUMBER | Parent Line unique identifier | ||
PREPAYMENT_AMOUNT | NUMBER | Prepayment Amount | ||
PREPAYMENT_PERCENTAGE | NUMBER | Prepayment Percentage | ||
PRIORITY_CODE | VARCHAR2 | (30) | Not currently used | |
PRIORITY_RATING | VARCHAR2 | (80) | Priority Rating | |
PROGRESS_PAYMENT_FLAG | VARCHAR2 | (1) | Progress Payment Applies indicator | |
PROGRESS_PAYMENT_LIQ_RATE | NUMBER | Progress Payment Liquidation Rate | ||
PROGRESS_PAYMENT_RATE | NUMBER | Progress Payment Rate | ||
PROGRESS_PAYMENT_YN | VARCHAR2 | (4000) | Progress Payment Applies? | |
PROJECT_COMPLETION_DATE | DATE | Project Completion Date | ||
PROJECT_DESCRIPTION | VARCHAR2 | (250) | Project description | |
PROJECT_ID | NUMBER | System generated project unique identifier | ||
PROJECT_NAME | VARCHAR2 | (30) | Project name | |
PROJECT_NUMBER | VARCHAR2 | (25) | Project number | |
PROJECT_ORGANIZATION | VARCHAR2 | (240) | Project Organization | |
PROJECT_START_DATE | DATE | Project Start Date | ||
PROPOSAL_DUE_DATE | VARCHAR2 | (80) | Proposal Due | |
REQUIRING_OFFICE | VARCHAR2 | (30) | Requiring Office | |
REVISED_PRICE | NUMBER | Revised Price | ||
SCHEDULED_DELV_DEFAULT | VARCHAR2 | (1) | Scheduled Deliverable Default | |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Multi-lingual indicator (not currently used) |
SHIPPABLE_FLAG | VARCHAR2 | (1) | Shippable indicator | |
SHIPPABLE_YN | VARCHAR2 | (4000) | Shippable? | |
SPLITED_FLAG | VARCHAR2 | (1) | Splited indicator | |
START_DATE | DATE | Date when contract line becomes effective | ||
STATUS | VARCHAR2 | (90) | Yes | Line Status |
STATUS_CODE | VARCHAR2 | (30) | Line Status Code | |
SUBCONTRACTED_FLAG | VARCHAR2 | (1) | Subcontracted indicator | |
SUBCONTRACTED_YN | VARCHAR2 | (4000) | Subcontracted? | |
SUBJ_A133_FLAG | VARCHAR2 | (1) | Subject A133 Applies indicator | |
SUBJ_A133_YN | VARCHAR2 | (4000) | Subject A133 Applies? | |
TARGET_COST | NUMBER | Target Cost | ||
TARGET_DATE_DEFINITIZE | DATE | Target Date of Definitization | ||
TARGET_FEE | NUMBER | Target Fee | ||
TARGET_PRICE | NUMBER | Target Price | ||
TASK_COMPLETION_DATE | DATE | Task Completion Date | ||
TASK_DESCRIPTION | VARCHAR2 | (250) | Task description | |
TASK_ID | NUMBER | System generated task unique identifier | ||
TASK_NAME | VARCHAR2 | (20) | Task name | |
TASK_NUMBER | VARCHAR2 | (25) | Task number | |
TASK_ORGANIZATION | VARCHAR2 | (240) | Task Organization | |
TASK_START_DATE | DATE | Task Start Date | ||
TOTAL_ESTIMATED_COST | NUMBER | Total Estimated Cost | ||
TRN_CODE | VARCHAR2 | (30) | Contract line termination code | |
UNDEF_LINE_VALUE | NUMBER | Undefinitized Line Value | ||
UNDEF_LINE_VALUE_TOTAL | NUMBER | Undefinitized Line Value Total | ||
UNDEF_UNIT_PRICE | NUMBER | Undefinitized Unit Price | ||
UNIT_PRICE | NUMBER | Unit price | ||
UOM_CODE | VARCHAR2 | (30) | Unit of measure |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, MAJOR_VERSION
, MINOR_VERSION
, VERSION_DISP
, APP_CODE
, AS_OF_DATE
, AUTHORITY
, AWARD_FEE
, AWARD_FEE_POOL_AMOUNT
, BASE_FEE
, BILLABLE_FLAG
, BILLABLE_YN
, BILLING_METHOD
, BILLING_METHOD_CODE
, BILL_UNDEFINITIZED_FLAG
, BILL_UNDEFINITIZED_YN
, BOE_DESCRIPTION
, CDRL_CATEGORY
, CEILING_COST
, CEILING_PRICE
, CFE_FLAG
, CFE_YN
, COMMENTS
, COMPLETED_FLAG
, COMPLETED_YN
, COPIES_REQUIRED
, COP_REQUIRED_FLAG
, COP_REQUIRED_YN
, COST_OF_MONEY
, COST_OF_MONEY_YN
, COST_OF_SALE_RATE
, COST_OVERRUN_SHARE_RATIO
, COST_UNDERRUN_SHARE_RATIO
, COUNTRY_OF_ORIGIN_CODE
, CUSTOMER_APPROVAL_REQ_FLAG
, CUSTOMER_APPROVAL_REQ_YN
, CUSTOMER_ITEM_ID
, CUSTOMER_ITEM_NUMBER
, CUSTOMER_PERCENT_IN_ORDER
, C_SCS_FLAG
, C_SCS_YN
, C_SSR_FLAG
, C_SSR_YN
, DATA_ITEM_NAME
, DATA_ITEM_SUBTITLE
, DATE_MATERIAL_REQ
, DATE_OF_FIRST_SUBMISSION
, DATE_OF_PRICE_REDETERMIN
, DCAA_AUDIT_REQ_FLAG
, DCAA_AUDIT_REQ_YN
, DEFINITIZED_FLAG
, DEFINITIZED_YN
, DELIVERY_DATE
, DELIVERY_ORDER_FLAG
, DISCOUNT_FOR_PAYMENT
, DISPLAY_SEQUENCE
, DROP_SHIPPED_FLAG
, DROP_SHIPPED_YN
, END_DATE
, ESTIMATED_TOTAL_QUANTITY
, EXPORT_FLAG
, EXPORT_LICENSE_NUM
, EXPORT_LICENSE_RES
, EXPORT_YN
, FEE_AJT_FORMULA
, FINAL_FEE
, FINAL_PFT_AJT_FORMULA
, FINANCIAL_CTRL_FLAG
, FINANCIAL_CTRL_YN
, FIXED_FEE
, FIXED_QUANTITY
, FREQUENCY
, HEADER_ID
, INITIAL_FEE
, INITIAL_PRICE
, INSPECTION_REQ_FLAG
, INSPECTION_REQ_YN
, INTERIM_RPT_REQ_FLAG
, INTERIM_RPT_REQ_YN
, INVENTORY_ITEM_ID
, ITEM_DESCRIPTION
, ITEM_NUMBER
, K_LINE_ID
, LABOR_COST_INDEX
, LEVEL_OF_EFFORT_HOURS
, LINE_DESCRIPTION
, LINE_LIQUIDATION_RATE
, LINE_NUMBER
, LINE_QUANTITY
, LINE_STYLE
, LINE_VALUE
, LINE_VALUE_TOTAL
, LSE_ID
, MATERIAL_COST_INDEX
, MAXIMUM_FEE
, MAXIMUM_QUANTITY
, MINIMUM_FEE
, MINIMUM_QUANTITY
, NSN_NUMBER
, NSP_FLAG
, NSP_YN
, NTE_WARNING_FLAG
, NTE_WARNING_YN
, NUMBER_OF_OPTIONS
, OBJECT_VERSION_NUMBER
, PARENT_LINE_ID
, PREPAYMENT_AMOUNT
, PREPAYMENT_PERCENTAGE
, PRIORITY_CODE
, PRIORITY_RATING
, PROGRESS_PAYMENT_FLAG
, PROGRESS_PAYMENT_LIQ_RATE
, PROGRESS_PAYMENT_RATE
, PROGRESS_PAYMENT_YN
, PROJECT_COMPLETION_DATE
, PROJECT_DESCRIPTION
, PROJECT_ID
, PROJECT_NAME
, PROJECT_NUMBER
, PROJECT_ORGANIZATION
, PROJECT_START_DATE
, PROPOSAL_DUE_DATE
, REQUIRING_OFFICE
, REVISED_PRICE
, SCHEDULED_DELV_DEFAULT
, SFWT_FLAG
, SHIPPABLE_FLAG
, SHIPPABLE_YN
, SPLITED_FLAG
, START_DATE
, STATUS
, STATUS_CODE
, SUBCONTRACTED_FLAG
, SUBCONTRACTED_YN
, SUBJ_A133_FLAG
, SUBJ_A133_YN
, TARGET_COST
, TARGET_DATE_DEFINITIZE
, TARGET_FEE
, TARGET_PRICE
, TASK_COMPLETION_DATE
, TASK_DESCRIPTION
, TASK_ID
, TASK_NAME
, TASK_NUMBER
, TASK_ORGANIZATION
, TASK_START_DATE
, TOTAL_ESTIMATED_COST
, TRN_CODE
, UNDEF_LINE_VALUE
, UNDEF_LINE_VALUE_TOTAL
, UNDEF_UNIT_PRICE
, UNIT_PRICE
, UOM_CODE
FROM APPS.OKE_K_LINES_SECURE_HV;
|
|
|