VIEW: APPS.OKE_K_LINES_FULL_V

Source

View Text - Preformatted

SELECT CL.ROWID , CL.ID , KV.MAJOR_VERSION , KV.MINOR_VERSION , KV.MAJOR_VERSION || '.' || KV.MINOR_VERSION , CL.OBJECT_VERSION_NUMBER , CLT.SFWT_FLAG , CL.DISPLAY_SEQUENCE , CL.LSE_ID , LS.NAME , CL.LINE_NUMBER , CLT.ITEM_DESCRIPTION , CL.STS_CODE , ST.MEANING , CH.AUTHORING_ORG_ID , CL.START_DATE , EL.END_DATE , EL.PRIORITY_CODE , PR.PRIORITY_NAME , EL.DELIVERY_DATE , EL.PROPOSAL_DUE_DATE , EL.INVENTORY_ITEM_ID , OKE_UTILS.ITEM_NUMBER( CH.INV_ORGANIZATION_ID , EL.INVENTORY_ITEM_ID ) , OKE_UTILS.ITEM_DESCRIPTION( CH.INV_ORGANIZATION_ID , EL.INVENTORY_ITEM_ID ) , EL.PROJECT_ID , PRJ.SEGMENT1 , PRJ.NAME , PRJ.DESCRIPTION , PRJ.START_DATE , PRJ.COMPLETION_DATE , PORG.NAME , EL.TASK_ID , TSK.TASK_NUMBER , TSK.TASK_NAME , TSK.DESCRIPTION , TSK.START_DATE , TSK.COMPLETION_DATE , TORG.NAME , EL.DELIVERY_ORDER_FLAG , EL.SPLITED_FLAG , EL.LINE_QUANTITY , EL.LINE_VALUE , EL.BILLABLE_FLAG , OKE_UTILS.YES_NO( NVL(EL.BILLABLE_FLAG , 'N') ) , EL.COMPLETED_FLAG , OKE_UTILS.YES_NO( NVL(EL.COMPLETED_FLAG , 'N') ) , EL.EXPORT_FLAG , OKE_UTILS.YES_NO( NVL(EL.EXPORT_FLAG , 'N') ) , CL.CLE_ID , CL.DNZ_CHR_ID , EL.UNIT_PRICE , EL.UOM_CODE , EL.SHIPPABLE_FLAG , OKE_UTILS.YES_NO( NVL(EL.SHIPPABLE_FLAG , 'N') ) , EL.SUBCONTRACTED_FLAG , OKE_UTILS.YES_NO( NVL(EL.SUBCONTRACTED_FLAG , 'N') ) , EL.NSP_FLAG , OKE_UTILS.YES_NO( NVL(EL.NSP_FLAG , 'N') ) , EL.CUSTOMER_APPROVAL_REQ_FLAG , OKE_UTILS.YES_NO( NVL(EL.CUSTOMER_APPROVAL_REQ_FLAG , 'N') ) , CLT.COMMENTS , EL.COST_OF_MONEY , OKE_UTILS.YES_NO( NVL(EL.COST_OF_MONEY , 'N') ) , EL.PREPAYMENT_PERCENTAGE , EL.PREPAYMENT_AMOUNT , CLT.OKE_BOE_DESCRIPTION , EL.PROGRESS_PAYMENT_FLAG , OKE_UTILS.YES_NO( NVL(EL.PROGRESS_PAYMENT_FLAG , 'N') ) , EL.PROGRESS_PAYMENT_LIQ_RATE , EL.LINE_LIQUIDATION_RATE , EL.PROGRESS_PAYMENT_RATE , EL.DISCOUNT_FOR_PAYMENT , EL.DCAA_AUDIT_REQ_FLAG , OKE_UTILS.YES_NO( NVL(EL.DCAA_AUDIT_REQ_FLAG , 'N') ) , EL.INTERIM_RPT_REQ_FLAG , OKE_UTILS.YES_NO( NVL(EL.INTERIM_RPT_REQ_FLAG , 'N') ) , EL.BILL_UNDEFINITIZED_FLAG , OKE_UTILS.YES_NO( NVL(EL.BILL_UNDEFINITIZED_FLAG , 'N') ) , EL.FINANCIAL_CTRL_FLAG , OKE_UTILS.YES_NO( NVL(EL.FINANCIAL_CTRL_FLAG , 'N') ) , EL.C_SSR_FLAG , OKE_UTILS.YES_NO( NVL(EL.C_SSR_FLAG , 'N') ) , EL.C_SCS_FLAG , OKE_UTILS.YES_NO( NVL(EL.C_SCS_FLAG , 'N') ) , EL.BILLING_METHOD_CODE , BM.BILLING_METHOD_NAME , 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 , OKE_UTILS.YES_NO( NVL(EL.DROP_SHIPPED_FLAG , 'N') ) , 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 , OKE_UTILS.YES_NO( NVL(EL.DEFINITIZED_FLAG , 'N') ) , 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.CUSTOMER_ITEM_NUMBER , EL.APP_CODE , EL.NSN_NUMBER , EL.AS_OF_DATE , EL.DATE_MATERIAL_REQ , EL.AUTHORITY , EL.NTE_WARNING_FLAG , OKE_UTILS.YES_NO( NVL(EL.NTE_WARNING_FLAG , 'N') ) , EL.COP_REQUIRED_FLAG , OKE_UTILS.YES_NO( NVL(EL.COP_REQUIRED_FLAG , 'N') ) , EL.INSPECTION_REQ_FLAG , OKE_UTILS.YES_NO( NVL(EL.INSPECTION_REQ_FLAG , 'N') ) , EL.SUBJ_A133_FLAG , OKE_UTILS.YES_NO( NVL(EL.SUBJ_A133_FLAG , 'N') ) , EL.CFE_REQ_FLAG , OKE_UTILS.YES_NO( NVL(EL.CFE_REQ_FLAG , 'N') ) , 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.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 , OKE_K_VERS_NUMBERS_V KV , OKC_K_HEADERS_ALL_B CH , OKC_LINE_STYLES_TL LS , OKC_STATUSES_TL ST , OKE_PRIORITY_CODES_TL PR , PA_PROJECTS_ALL PRJ , HR_ALL_ORGANIZATION_UNITS_TL PORG , PA_TASKS TSK , HR_ALL_ORGANIZATION_UNITS_TL TORG , OKE_BILLING_METHODS_TL BM WHERE CL.ID = EL.K_LINE_ID AND CL.ID = CLT.ID AND CLT.LANGUAGE = USERENV('LANG') AND CH.ID = CL.DNZ_CHR_ID AND KV.CHR_ID = CH.ID AND LS.ID = CL.LSE_ID AND LS.LANGUAGE = USERENV('LANG') AND ST.CODE = CL.STS_CODE AND ST.LANGUAGE = USERENV('LANG') AND PR.PRIORITY_CODE (+) = EL.PRIORITY_CODE AND PR.LANGUAGE (+) = USERENV('LANG') AND PRJ.PROJECT_ID (+) = EL.PROJECT_ID AND PORG.ORGANIZATION_ID (+) = PRJ.CARRYING_OUT_ORGANIZATION_ID AND PORG.LANGUAGE (+) = USERENV('LANG') AND TSK.TASK_ID (+) = EL.TASK_ID AND TORG.ORGANIZATION_ID (+) = TSK.CARRYING_OUT_ORGANIZATION_ID AND TORG.LANGUAGE (+) = USERENV('LANG') AND BM.BILLING_METHOD_CODE (+) = EL.BILLING_METHOD_CODE AND BM.LANGUAGE (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT CL.ROWID
, CL.ID
, KV.MAJOR_VERSION
, KV.MINOR_VERSION
, KV.MAJOR_VERSION || '.' || KV.MINOR_VERSION
, CL.OBJECT_VERSION_NUMBER
, CLT.SFWT_FLAG
, CL.DISPLAY_SEQUENCE
, CL.LSE_ID
, LS.NAME
, CL.LINE_NUMBER
, CLT.ITEM_DESCRIPTION
, CL.STS_CODE
, ST.MEANING
, CH.AUTHORING_ORG_ID
, CL.START_DATE
, EL.END_DATE
, EL.PRIORITY_CODE
, PR.PRIORITY_NAME
, EL.DELIVERY_DATE
, EL.PROPOSAL_DUE_DATE
, EL.INVENTORY_ITEM_ID
, OKE_UTILS.ITEM_NUMBER( CH.INV_ORGANIZATION_ID
, EL.INVENTORY_ITEM_ID )
, OKE_UTILS.ITEM_DESCRIPTION( CH.INV_ORGANIZATION_ID
, EL.INVENTORY_ITEM_ID )
, EL.PROJECT_ID
, PRJ.SEGMENT1
, PRJ.NAME
, PRJ.DESCRIPTION
, PRJ.START_DATE
, PRJ.COMPLETION_DATE
, PORG.NAME
, EL.TASK_ID
, TSK.TASK_NUMBER
, TSK.TASK_NAME
, TSK.DESCRIPTION
, TSK.START_DATE
, TSK.COMPLETION_DATE
, TORG.NAME
, EL.DELIVERY_ORDER_FLAG
, EL.SPLITED_FLAG
, EL.LINE_QUANTITY
, EL.LINE_VALUE
, EL.BILLABLE_FLAG
, OKE_UTILS.YES_NO( NVL(EL.BILLABLE_FLAG
, 'N') )
, EL.COMPLETED_FLAG
, OKE_UTILS.YES_NO( NVL(EL.COMPLETED_FLAG
, 'N') )
, EL.EXPORT_FLAG
, OKE_UTILS.YES_NO( NVL(EL.EXPORT_FLAG
, 'N') )
, CL.CLE_ID
, CL.DNZ_CHR_ID
, EL.UNIT_PRICE
, EL.UOM_CODE
, EL.SHIPPABLE_FLAG
, OKE_UTILS.YES_NO( NVL(EL.SHIPPABLE_FLAG
, 'N') )
, EL.SUBCONTRACTED_FLAG
, OKE_UTILS.YES_NO( NVL(EL.SUBCONTRACTED_FLAG
, 'N') )
, EL.NSP_FLAG
, OKE_UTILS.YES_NO( NVL(EL.NSP_FLAG
, 'N') )
, EL.CUSTOMER_APPROVAL_REQ_FLAG
, OKE_UTILS.YES_NO( NVL(EL.CUSTOMER_APPROVAL_REQ_FLAG
, 'N') )
, CLT.COMMENTS
, EL.COST_OF_MONEY
, OKE_UTILS.YES_NO( NVL(EL.COST_OF_MONEY
, 'N') )
, EL.PREPAYMENT_PERCENTAGE
, EL.PREPAYMENT_AMOUNT
, CLT.OKE_BOE_DESCRIPTION
, EL.PROGRESS_PAYMENT_FLAG
, OKE_UTILS.YES_NO( NVL(EL.PROGRESS_PAYMENT_FLAG
, 'N') )
, EL.PROGRESS_PAYMENT_LIQ_RATE
, EL.LINE_LIQUIDATION_RATE
, EL.PROGRESS_PAYMENT_RATE
, EL.DISCOUNT_FOR_PAYMENT
, EL.DCAA_AUDIT_REQ_FLAG
, OKE_UTILS.YES_NO( NVL(EL.DCAA_AUDIT_REQ_FLAG
, 'N') )
, EL.INTERIM_RPT_REQ_FLAG
, OKE_UTILS.YES_NO( NVL(EL.INTERIM_RPT_REQ_FLAG
, 'N') )
, EL.BILL_UNDEFINITIZED_FLAG
, OKE_UTILS.YES_NO( NVL(EL.BILL_UNDEFINITIZED_FLAG
, 'N') )
, EL.FINANCIAL_CTRL_FLAG
, OKE_UTILS.YES_NO( NVL(EL.FINANCIAL_CTRL_FLAG
, 'N') )
, EL.C_SSR_FLAG
, OKE_UTILS.YES_NO( NVL(EL.C_SSR_FLAG
, 'N') )
, EL.C_SCS_FLAG
, OKE_UTILS.YES_NO( NVL(EL.C_SCS_FLAG
, 'N') )
, EL.BILLING_METHOD_CODE
, BM.BILLING_METHOD_NAME
, 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
, OKE_UTILS.YES_NO( NVL(EL.DROP_SHIPPED_FLAG
, 'N') )
, 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
, OKE_UTILS.YES_NO( NVL(EL.DEFINITIZED_FLAG
, 'N') )
, 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.CUSTOMER_ITEM_NUMBER
, EL.APP_CODE
, EL.NSN_NUMBER
, EL.AS_OF_DATE
, EL.DATE_MATERIAL_REQ
, EL.AUTHORITY
, EL.NTE_WARNING_FLAG
, OKE_UTILS.YES_NO( NVL(EL.NTE_WARNING_FLAG
, 'N') )
, EL.COP_REQUIRED_FLAG
, OKE_UTILS.YES_NO( NVL(EL.COP_REQUIRED_FLAG
, 'N') )
, EL.INSPECTION_REQ_FLAG
, OKE_UTILS.YES_NO( NVL(EL.INSPECTION_REQ_FLAG
, 'N') )
, EL.SUBJ_A133_FLAG
, OKE_UTILS.YES_NO( NVL(EL.SUBJ_A133_FLAG
, 'N') )
, EL.CFE_REQ_FLAG
, OKE_UTILS.YES_NO( NVL(EL.CFE_REQ_FLAG
, 'N') )
, 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.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
, OKE_K_VERS_NUMBERS_V KV
, OKC_K_HEADERS_ALL_B CH
, OKC_LINE_STYLES_TL LS
, OKC_STATUSES_TL ST
, OKE_PRIORITY_CODES_TL PR
, PA_PROJECTS_ALL PRJ
, HR_ALL_ORGANIZATION_UNITS_TL PORG
, PA_TASKS TSK
, HR_ALL_ORGANIZATION_UNITS_TL TORG
, OKE_BILLING_METHODS_TL BM
WHERE CL.ID = EL.K_LINE_ID
AND CL.ID = CLT.ID
AND CLT.LANGUAGE = USERENV('LANG')
AND CH.ID = CL.DNZ_CHR_ID
AND KV.CHR_ID = CH.ID
AND LS.ID = CL.LSE_ID
AND LS.LANGUAGE = USERENV('LANG')
AND ST.CODE = CL.STS_CODE
AND ST.LANGUAGE = USERENV('LANG')
AND PR.PRIORITY_CODE (+) = EL.PRIORITY_CODE
AND PR.LANGUAGE (+) = USERENV('LANG')
AND PRJ.PROJECT_ID (+) = EL.PROJECT_ID
AND PORG.ORGANIZATION_ID (+) = PRJ.CARRYING_OUT_ORGANIZATION_ID
AND PORG.LANGUAGE (+) = USERENV('LANG')
AND TSK.TASK_ID (+) = EL.TASK_ID
AND TORG.ORGANIZATION_ID (+) = TSK.CARRYING_OUT_ORGANIZATION_ID
AND TORG.LANGUAGE (+) = USERENV('LANG')
AND BM.BILLING_METHOD_CODE (+) = EL.BILLING_METHOD_CODE
AND BM.LANGUAGE (+) = USERENV('LANG')