VIEW: OKE.OKE_K_LINES_H#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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