Product: | OKE - Project Contracts |
---|---|
Description: | Contract line extended information view |
Implementation/DBA Data: | APPS.OKE_K_LINES_FULL_V |
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_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')