eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: OKE.OKE_K_LINES#

Object Details

Object Name:	OKE_K_LINES#
Object Type:	VIEW
Owner:	OKE
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
K_LINE_ID	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
PARENT_LINE_ID	NUMBER
PROJECT_ID	NUMBER
TASK_ID	NUMBER
BILLING_METHOD_CODE	VARCHAR2	(30)
INVENTORY_ITEM_ID	NUMBER
PRIORITY_CODE	VARCHAR2	(30)
CUSTOMER_ITEM_ID	NUMBER
LINE_QUANTITY	NUMBER
DELIVERY_DATE	DATE
PROPOSAL_DUE_DATE	VARCHAR2	(80)
UNIT_PRICE	NUMBER
UOM_CODE	VARCHAR2	(30)
DELIVERY_ORDER_FLAG	VARCHAR2	(1)
SPLITED_FLAG	VARCHAR2	(1)
BILLABLE_FLAG	VARCHAR2	(1)
SHIPPABLE_FLAG	VARCHAR2	(1)
SUBCONTRACTED_FLAG	VARCHAR2	(1)
COMPLETED_FLAG	VARCHAR2	(1)
NSP_FLAG	VARCHAR2	(1)
APP_CODE	VARCHAR2	(30)
AS_OF_DATE	DATE
AUTHORITY	VARCHAR2	(30)
COUNTRY_OF_ORIGIN_CODE	VARCHAR2	(30)
DROP_SHIPPED_FLAG	VARCHAR2	(1)
CUSTOMER_APPROVAL_REQ_FLAG	VARCHAR2	(1)
DATE_MATERIAL_REQ	DATE
INSPECTION_REQ_FLAG	VARCHAR2	(1)
INTERIM_RPT_REQ_FLAG	VARCHAR2	(1)
SUBJ_A133_FLAG	VARCHAR2	(1)
EXPORT_FLAG	VARCHAR2	(1)
CFE_REQ_FLAG	VARCHAR2	(1)
COP_REQUIRED_FLAG	VARCHAR2	(1)
EXPORT_LICENSE_NUM	VARCHAR2	(30)
EXPORT_LICENSE_RES	VARCHAR2	(30)
COPIES_REQUIRED	NUMBER
CDRL_CATEGORY	VARCHAR2	(30)
DATA_ITEM_NAME	VARCHAR2	(30)
DATA_ITEM_SUBTITLE	VARCHAR2	(30)
DATE_OF_FIRST_SUBMISSION	DATE
FREQUENCY	VARCHAR2	(30)
REQUIRING_OFFICE	VARCHAR2	(30)
DCAA_AUDIT_REQ_FLAG	VARCHAR2	(1)
DEFINITIZED_FLAG	VARCHAR2	(1)
COST_OF_MONEY	VARCHAR2	(1)
BILL_UNDEFINITIZED_FLAG	VARCHAR2	(1)
NSN_NUMBER	VARCHAR2	(30)
NTE_WARNING_FLAG	VARCHAR2	(1)
DISCOUNT_FOR_PAYMENT	NUMBER
FINANCIAL_CTRL_FLAG	VARCHAR2	(1)
C_SCS_FLAG	VARCHAR2	(1)
C_SSR_FLAG	VARCHAR2	(1)
PREPAYMENT_AMOUNT	NUMBER
PREPAYMENT_PERCENTAGE	NUMBER
PROGRESS_PAYMENT_FLAG	VARCHAR2	(1)
PROGRESS_PAYMENT_LIQ_RATE	NUMBER
PROGRESS_PAYMENT_RATE	NUMBER
AWARD_FEE	NUMBER
AWARD_FEE_POOL_AMOUNT	NUMBER
BASE_FEE	NUMBER
CEILING_PRICE	NUMBER
CEILING_COST	NUMBER
LABOR_COST_INDEX	VARCHAR2	(30)
MATERIAL_COST_INDEX	VARCHAR2	(30)
COST_OVERRUN_SHARE_RATIO	VARCHAR2	(80)
COST_UNDERRUN_SHARE_RATIO	VARCHAR2	(80)
CUSTOMERS_PERCENT_IN_ORDER	NUMBER
DATE_OF_PRICE_REDETERMIN	DATE
ESTIMATED_TOTAL_QUANTITY	NUMBER
FEE_AJT_FORMULA	VARCHAR2	(30)
FINAL_FEE	NUMBER
FINAL_PFT_AJT_FORMULA	VARCHAR2	(30)
FIXED_FEE	NUMBER
FIXED_QUANTITY	NUMBER
INITIAL_FEE	NUMBER
INITIAL_PRICE	NUMBER
LEVEL_OF_EFFORT_HOURS	NUMBER
LINE_LIQUIDATION_RATE	NUMBER
MAXIMUM_FEE	NUMBER
MAXIMUM_QUANTITY	NUMBER
MINIMUM_FEE	NUMBER
MINIMUM_QUANTITY	NUMBER
NUMBER_OF_OPTIONS	NUMBER
REVISED_PRICE	NUMBER
TARGET_COST	NUMBER
TARGET_DATE_DEFINITIZE	DATE
TARGET_FEE	NUMBER
TARGET_PRICE	NUMBER
TOTAL_ESTIMATED_COST	NUMBER
LINE_VALUE	NUMBER
COST_OF_SALE_RATE	NUMBER
LINE_VALUE_TOTAL	NUMBER
UNDEF_UNIT_PRICE	NUMBER
UNDEF_LINE_VALUE	NUMBER
UNDEF_LINE_VALUE_TOTAL	NUMBER
END_DATE	DATE
CUSTOMER_ITEM_NUMBER	VARCHAR2	(80)
SCHEDULED_DELV_DEFAULT	VARCHAR2	(1)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT K_LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PARENT_LINE_ID
,      PROJECT_ID
,      TASK_ID
,      BILLING_METHOD_CODE
,      INVENTORY_ITEM_ID
,      PRIORITY_CODE
,      CUSTOMER_ITEM_ID
,      LINE_QUANTITY
,      DELIVERY_DATE
,      PROPOSAL_DUE_DATE
,      UNIT_PRICE
,      UOM_CODE
,      DELIVERY_ORDER_FLAG
,      SPLITED_FLAG
,      BILLABLE_FLAG
,      SHIPPABLE_FLAG
,      SUBCONTRACTED_FLAG
,      COMPLETED_FLAG
,      NSP_FLAG
,      APP_CODE
,      AS_OF_DATE
,      AUTHORITY
,      COUNTRY_OF_ORIGIN_CODE
,      DROP_SHIPPED_FLAG
,      CUSTOMER_APPROVAL_REQ_FLAG
,      DATE_MATERIAL_REQ
,      INSPECTION_REQ_FLAG
,      INTERIM_RPT_REQ_FLAG
,      SUBJ_A133_FLAG
,      EXPORT_FLAG
,      CFE_REQ_FLAG
,      COP_REQUIRED_FLAG
,      EXPORT_LICENSE_NUM
,      EXPORT_LICENSE_RES
,      COPIES_REQUIRED
,      CDRL_CATEGORY
,      DATA_ITEM_NAME
,      DATA_ITEM_SUBTITLE
,      DATE_OF_FIRST_SUBMISSION
,      FREQUENCY
,      REQUIRING_OFFICE
,      DCAA_AUDIT_REQ_FLAG
,      DEFINITIZED_FLAG
,      COST_OF_MONEY
,      BILL_UNDEFINITIZED_FLAG
,      NSN_NUMBER
,      NTE_WARNING_FLAG
,      DISCOUNT_FOR_PAYMENT
,      FINANCIAL_CTRL_FLAG
,      C_SCS_FLAG
,      C_SSR_FLAG
,      PREPAYMENT_AMOUNT
,      PREPAYMENT_PERCENTAGE
,      PROGRESS_PAYMENT_FLAG
,      PROGRESS_PAYMENT_LIQ_RATE
,      PROGRESS_PAYMENT_RATE
,      AWARD_FEE
,      AWARD_FEE_POOL_AMOUNT
,      BASE_FEE
,      CEILING_PRICE
,      CEILING_COST
,      LABOR_COST_INDEX
,      MATERIAL_COST_INDEX
,      COST_OVERRUN_SHARE_RATIO
,      COST_UNDERRUN_SHARE_RATIO
,      CUSTOMERS_PERCENT_IN_ORDER
,      DATE_OF_PRICE_REDETERMIN
,      ESTIMATED_TOTAL_QUANTITY
,      FEE_AJT_FORMULA
,      FINAL_FEE
,      FINAL_PFT_AJT_FORMULA
,      FIXED_FEE
,      FIXED_QUANTITY
,      INITIAL_FEE
,      INITIAL_PRICE
,      LEVEL_OF_EFFORT_HOURS
,      LINE_LIQUIDATION_RATE
,      MAXIMUM_FEE
,      MAXIMUM_QUANTITY
,      MINIMUM_FEE
,      MINIMUM_QUANTITY
,      NUMBER_OF_OPTIONS
,      REVISED_PRICE
,      TARGET_COST
,      TARGET_DATE_DEFINITIZE
,      TARGET_FEE
,      TARGET_PRICE
,      TOTAL_ESTIMATED_COST
,      LINE_VALUE
,      COST_OF_SALE_RATE
,      LINE_VALUE_TOTAL
,      UNDEF_UNIT_PRICE
,      UNDEF_LINE_VALUE
,      UNDEF_LINE_VALUE_TOTAL
,      END_DATE
,      CUSTOMER_ITEM_NUMBER
,      SCHEDULED_DELV_DEFAULT
FROM OKE.OKE_K_LINES#;

Dependencies

[top of page]

OKE.OKE_K_LINES# references the following:

OKE: OKE_K_LINES

OKE.OKE_K_LINES# is referenced by following:

APPS: OKE_K_LINES