VIEW: APPS.OKE_K_LINES_V

Source

View Text - Preformatted

SELECT CL.ROWID , CL.ID , CL.OBJECT_VERSION_NUMBER , CLT.SFWT_FLAG , CL.DISPLAY_SEQUENCE , CL.LSE_ID , CL.LINE_NUMBER , CLT.ITEM_DESCRIPTION , CL.STS_CODE , CL.START_DATE , EL.END_DATE , EL.PRIORITY_CODE , EL.DELIVERY_DATE , El.PROPOSAL_DUE_DATE , EL.INVENTORY_ITEM_ID , EL.PROJECT_ID , EL.TASK_ID , EL.DELIVERY_ORDER_FLAG , EL.SPLITED_FLAG , EL.LINE_QUANTITY , EL.BILLABLE_FLAG , EL.COMPLETED_FLAG , EL.EXPORT_FLAG , CL.CLE_ID , CL.DNZ_CHR_ID , EL.UNIT_PRICE , EL.UOM_CODE , EL.LINE_VALUE , EL.SHIPPABLE_FLAG , EL.SUBCONTRACTED_FLAG , EL.NSP_FLAG , EL.CUSTOMER_APPROVAL_REQ_FLAG , CLT.COMMENTS , EL.COST_OF_MONEY , EL.PREPAYMENT_PERCENTAGE , EL.PREPAYMENT_AMOUNT , CLT.OKE_BOE_DESCRIPTION , EL.PROGRESS_PAYMENT_FLAG , EL.PROGRESS_PAYMENT_LIQ_RATE , EL.LINE_LIQUIDATION_RATE , EL.PROGRESS_PAYMENT_RATE , EL.DISCOUNT_FOR_PAYMENT , EL.DCAA_AUDIT_REQ_FLAG , EL.INTERIM_RPT_REQ_FLAG , EL.BILL_UNDEFINITIZED_FLAG , EL.FINANCIAL_CTRL_FLAG , EL.C_SSR_FLAG , EL.C_SCS_FLAG , EL.BILLING_METHOD_CODE , EL.LEVEL_OF_EFFORT_HOURS , EL.CEILING_PRICE , EL.CEILING_COST , EL.TOTAL_ESTIMATED_COST , EL.AWARD_FEE , EL.AWARD_FEE_POOL_AMOUNT , EL.BASE_FEE , EL.FIXED_FEE , EL.MAXIMUM_FEE , EL.MINIMUM_FEE , EL.INITIAL_FEE , EL.FINAL_FEE , EL.DROP_SHIPPED_FLAG , EL.EXPORT_LICENSE_NUM , EL.EXPORT_LICENSE_RES , EL.MATERIAL_COST_INDEX , EL.LABOR_COST_INDEX , EL.COST_OVERRUN_SHARE_RATIO , EL.COST_UNDERRUN_SHARE_RATIO , EL.FEE_AJT_FORMULA , EL.FIXED_QUANTITY , EL.ESTIMATED_TOTAL_QUANTITY , EL.MAXIMUM_QUANTITY , EL.MINIMUM_QUANTITY , EL.NUMBER_OF_OPTIONS , EL.TARGET_FEE , EL.TARGET_PRICE , EL.FINAL_PFT_AJT_FORMULA , EL.TARGET_COST , EL.TARGET_DATE_DEFINITIZE , EL.DEFINITIZED_FLAG , EL.DATE_OF_PRICE_REDETERMIN , EL.INITIAL_PRICE , EL.REVISED_PRICE , EL.CUSTOMERS_PERCENT_IN_ORDER , EL.COUNTRY_OF_ORIGIN_CODE , EL.CUSTOMER_ITEM_ID , EL.APP_CODE , EL.NSN_NUMBER , EL.AS_OF_DATE , EL.DATE_MATERIAL_REQ , EL.AUTHORITY , EL.NTE_WARNING_FLAG , EL.COP_REQUIRED_FLAG , EL.INSPECTION_REQ_FLAG , EL.SUBJ_A133_FLAG , EL.CFE_REQ_FLAG , EL.DATA_ITEM_NAME , EL.CDRL_CATEGORY , EL.DATA_ITEM_SUBTITLE , EL.REQUIRING_OFFICE , EL.FREQUENCY , EL.DATE_OF_FIRST_SUBMISSION , EL.COPIES_REQUIRED , EL.COST_OF_SALE_RATE , EL.LINE_VALUE_TOTAL , EL.UNDEF_UNIT_PRICE , EL.UNDEF_LINE_VALUE , EL.UNDEF_LINE_VALUE_TOTAL , EL.CUSTOMER_ITEM_NUMBER , EL.SCHEDULED_DELV_DEFAULT , CL.CREATED_BY , CL.CREATION_DATE , CL.LAST_UPDATED_BY , CL.LAST_UPDATE_LOGIN , CL.LAST_UPDATE_DATE , CL.TRN_CODE , CL.ATTRIBUTE_CATEGORY , CL.ATTRIBUTE1 , CL.ATTRIBUTE2 , CL.ATTRIBUTE3 , CL.ATTRIBUTE4 , CL.ATTRIBUTE5 , CL.ATTRIBUTE6 , CL.ATTRIBUTE7 , CL.ATTRIBUTE8 , CL.ATTRIBUTE9 , CL.ATTRIBUTE10 , CL.ATTRIBUTE11 , CL.ATTRIBUTE12 , CL.ATTRIBUTE13 , CL.ATTRIBUTE14 , CL.ATTRIBUTE15 FROM OKC_K_LINES_B CL , OKC_K_LINES_TL CLT , OKE_K_LINES EL WHERE CL.ID = EL.K_LINE_ID AND CL.ID = CLT.ID AND CLT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT CL.ROWID
, CL.ID
, CL.OBJECT_VERSION_NUMBER
, CLT.SFWT_FLAG
, CL.DISPLAY_SEQUENCE
, CL.LSE_ID
, CL.LINE_NUMBER
, CLT.ITEM_DESCRIPTION
, CL.STS_CODE
, CL.START_DATE
, EL.END_DATE
, EL.PRIORITY_CODE
, EL.DELIVERY_DATE
, EL.PROPOSAL_DUE_DATE
, EL.INVENTORY_ITEM_ID
, EL.PROJECT_ID
, EL.TASK_ID
, EL.DELIVERY_ORDER_FLAG
, EL.SPLITED_FLAG
, EL.LINE_QUANTITY
, EL.BILLABLE_FLAG
, EL.COMPLETED_FLAG
, EL.EXPORT_FLAG
, CL.CLE_ID
, CL.DNZ_CHR_ID
, EL.UNIT_PRICE
, EL.UOM_CODE
, EL.LINE_VALUE
, EL.SHIPPABLE_FLAG
, EL.SUBCONTRACTED_FLAG
, EL.NSP_FLAG
, EL.CUSTOMER_APPROVAL_REQ_FLAG
, CLT.COMMENTS
, EL.COST_OF_MONEY
, EL.PREPAYMENT_PERCENTAGE
, EL.PREPAYMENT_AMOUNT
, CLT.OKE_BOE_DESCRIPTION
, EL.PROGRESS_PAYMENT_FLAG
, EL.PROGRESS_PAYMENT_LIQ_RATE
, EL.LINE_LIQUIDATION_RATE
, EL.PROGRESS_PAYMENT_RATE
, EL.DISCOUNT_FOR_PAYMENT
, EL.DCAA_AUDIT_REQ_FLAG
, EL.INTERIM_RPT_REQ_FLAG
, EL.BILL_UNDEFINITIZED_FLAG
, EL.FINANCIAL_CTRL_FLAG
, EL.C_SSR_FLAG
, EL.C_SCS_FLAG
, EL.BILLING_METHOD_CODE
, EL.LEVEL_OF_EFFORT_HOURS
, EL.CEILING_PRICE
, EL.CEILING_COST
, EL.TOTAL_ESTIMATED_COST
, EL.AWARD_FEE
, EL.AWARD_FEE_POOL_AMOUNT
, EL.BASE_FEE
, EL.FIXED_FEE
, EL.MAXIMUM_FEE
, EL.MINIMUM_FEE
, EL.INITIAL_FEE
, EL.FINAL_FEE
, EL.DROP_SHIPPED_FLAG
, EL.EXPORT_LICENSE_NUM
, EL.EXPORT_LICENSE_RES
, EL.MATERIAL_COST_INDEX
, EL.LABOR_COST_INDEX
, EL.COST_OVERRUN_SHARE_RATIO
, EL.COST_UNDERRUN_SHARE_RATIO
, EL.FEE_AJT_FORMULA
, EL.FIXED_QUANTITY
, EL.ESTIMATED_TOTAL_QUANTITY
, EL.MAXIMUM_QUANTITY
, EL.MINIMUM_QUANTITY
, EL.NUMBER_OF_OPTIONS
, EL.TARGET_FEE
, EL.TARGET_PRICE
, EL.FINAL_PFT_AJT_FORMULA
, EL.TARGET_COST
, EL.TARGET_DATE_DEFINITIZE
, EL.DEFINITIZED_FLAG
, EL.DATE_OF_PRICE_REDETERMIN
, EL.INITIAL_PRICE
, EL.REVISED_PRICE
, EL.CUSTOMERS_PERCENT_IN_ORDER
, EL.COUNTRY_OF_ORIGIN_CODE
, EL.CUSTOMER_ITEM_ID
, EL.APP_CODE
, EL.NSN_NUMBER
, EL.AS_OF_DATE
, EL.DATE_MATERIAL_REQ
, EL.AUTHORITY
, EL.NTE_WARNING_FLAG
, EL.COP_REQUIRED_FLAG
, EL.INSPECTION_REQ_FLAG
, EL.SUBJ_A133_FLAG
, EL.CFE_REQ_FLAG
, EL.DATA_ITEM_NAME
, EL.CDRL_CATEGORY
, EL.DATA_ITEM_SUBTITLE
, EL.REQUIRING_OFFICE
, EL.FREQUENCY
, EL.DATE_OF_FIRST_SUBMISSION
, EL.COPIES_REQUIRED
, EL.COST_OF_SALE_RATE
, EL.LINE_VALUE_TOTAL
, EL.UNDEF_UNIT_PRICE
, EL.UNDEF_LINE_VALUE
, EL.UNDEF_LINE_VALUE_TOTAL
, EL.CUSTOMER_ITEM_NUMBER
, EL.SCHEDULED_DELV_DEFAULT
, CL.CREATED_BY
, CL.CREATION_DATE
, CL.LAST_UPDATED_BY
, CL.LAST_UPDATE_LOGIN
, CL.LAST_UPDATE_DATE
, CL.TRN_CODE
, CL.ATTRIBUTE_CATEGORY
, CL.ATTRIBUTE1
, CL.ATTRIBUTE2
, CL.ATTRIBUTE3
, CL.ATTRIBUTE4
, CL.ATTRIBUTE5
, CL.ATTRIBUTE6
, CL.ATTRIBUTE7
, CL.ATTRIBUTE8
, CL.ATTRIBUTE9
, CL.ATTRIBUTE10
, CL.ATTRIBUTE11
, CL.ATTRIBUTE12
, CL.ATTRIBUTE13
, CL.ATTRIBUTE14
, CL.ATTRIBUTE15
FROM OKC_K_LINES_B CL
, OKC_K_LINES_TL CLT
, OKE_K_LINES EL
WHERE CL.ID = EL.K_LINE_ID
AND CL.ID = CLT.ID
AND CLT.LANGUAGE = USERENV('LANG')