Product: | OKE - Project Contracts |
---|---|
Description: | Secured contract historical line extended information view |
Implementation/DBA Data: | APPS.OKE_K_LINES_SECURE_HV |
SELECT K.ROW_ID
, K.K_LINE_ID
, K.MAJOR_VERSION
, K.MINOR_VERSION
, K.VERSION_DISP
, K.OBJECT_VERSION_NUMBER
, K.SFWT_FLAG
, K.DISPLAY_SEQUENCE
, K.LSE_ID
, K.LINE_STYLE
, K.LINE_NUMBER
, K.LINE_DESCRIPTION
, K.STATUS_CODE
, K.STATUS
, K.START_DATE
, K.END_DATE
, K.PRIORITY_CODE
, K.PRIORITY_RATING
, K.DELIVERY_DATE
, K.PROPOSAL_DUE_DATE
, K.INVENTORY_ITEM_ID
, K.ITEM_NUMBER
, K.ITEM_DESCRIPTION
, K.PROJECT_ID
, K.PROJECT_NUMBER
, K.PROJECT_NAME
, K.PROJECT_DESCRIPTION
, K.PROJECT_START_DATE
, K.PROJECT_COMPLETION_DATE
, K.PROJECT_ORGANIZATION
, K.TASK_ID
, K.TASK_NUMBER
, K.TASK_NAME
, K.TASK_DESCRIPTION
, K.TASK_START_DATE
, K.TASK_COMPLETION_DATE
, K.TASK_ORGANIZATION
, K.DELIVERY_ORDER_FLAG
, K.SPLITED_FLAG
, K.LINE_QUANTITY
, K.LINE_VALUE
, K.BILLABLE_FLAG
, K.BILLABLE_YN
, K.COMPLETED_FLAG
, K.COMPLETED_YN
, K.EXPORT_FLAG
, K.EXPORT_YN
, K.PARENT_LINE_ID
, K.HEADER_ID
, K.UNIT_PRICE
, K.UOM_CODE
, K.SHIPPABLE_FLAG
, K.SHIPPABLE_YN
, K.SUBCONTRACTED_FLAG
, K.SUBCONTRACTED_YN
, K.NSP_FLAG
, K.NSP_YN
, K.CUSTOMER_APPROVAL_REQ_FLAG
, K.CUSTOMER_APPROVAL_REQ_YN
, K.COMMENTS
, K.COST_OF_MONEY
, K.COST_OF_MONEY_YN
, K.PREPAYMENT_PERCENTAGE
, K.PREPAYMENT_AMOUNT
, K.BOE_DESCRIPTION
, K.PROGRESS_PAYMENT_FLAG
, K.PROGRESS_PAYMENT_YN
, K.PROGRESS_PAYMENT_LIQ_RATE
, K.LINE_LIQUIDATION_RATE
, K.PROGRESS_PAYMENT_RATE
, K.DISCOUNT_FOR_PAYMENT
, K.DCAA_AUDIT_REQ_FLAG
, K.DCAA_AUDIT_REQ_YN
, K.INTERIM_RPT_REQ_FLAG
, K.INTERIM_RPT_REQ_YN
, K.BILL_UNDEFINITIZED_FLAG
, K.BILL_UNDEFINITIZED_YN
, K.FINANCIAL_CTRL_FLAG
, K.FINANCIAL_CTRL_YN
, K.C_SSR_FLAG
, K.C_SSR_YN
, K.C_SCS_FLAG
, K.C_SCS_YN
, K.BILLING_METHOD_CODE
, K.BILLING_METHOD
, K.LEVEL_OF_EFFORT_HOURS
, K.CEILING_PRICE
, K.CEILING_COST
, K.TOTAL_ESTIMATED_COST
, K.AWARD_FEE
, K.AWARD_FEE_POOL_AMOUNT
, K.BASE_FEE
, K.FIXED_FEE
, K.MAXIMUM_FEE
, K.MINIMUM_FEE
, K.INITIAL_FEE
, K.FINAL_FEE
, K.DROP_SHIPPED_FLAG
, K.DROP_SHIPPED_YN
, K.EXPORT_LICENSE_NUM
, K.EXPORT_LICENSE_RES
, K.MATERIAL_COST_INDEX
, K.LABOR_COST_INDEX
, K.COST_OVERRUN_SHARE_RATIO
, K.COST_UNDERRUN_SHARE_RATIO
, K.FEE_AJT_FORMULA
, K.FIXED_QUANTITY
, K.ESTIMATED_TOTAL_QUANTITY
, K.MAXIMUM_QUANTITY
, K.MINIMUM_QUANTITY
, K.NUMBER_OF_OPTIONS
, K.TARGET_FEE
, K.TARGET_PRICE
, K.FINAL_PFT_AJT_FORMULA
, K.TARGET_COST
, K.TARGET_DATE_DEFINITIZE
, K.DEFINITIZED_FLAG
, K.DEFINITIZED_YN
, K.DATE_OF_PRICE_REDETERMIN
, K.INITIAL_PRICE
, K.REVISED_PRICE
, K.CUSTOMER_PERCENT_IN_ORDER
, K.COUNTRY_OF_ORIGIN_CODE
, K.CUSTOMER_ITEM_ID
, K.CUSTOMER_ITEM_NUMBER
, K.APP_CODE
, K.NSN_NUMBER
, K.AS_OF_DATE
, K.DATE_MATERIAL_REQ
, K.AUTHORITY
, K.NTE_WARNING_FLAG
, K.NTE_WARNING_YN
, K.COP_REQUIRED_FLAG
, K.COP_REQUIRED_YN
, K.INSPECTION_REQ_FLAG
, K.INSPECTION_REQ_YN
, K.SUBJ_A133_FLAG
, K.SUBJ_A133_YN
, K.CFE_FLAG
, K.CFE_YN
, K.DATA_ITEM_NAME
, K.CDRL_CATEGORY
, K.DATA_ITEM_SUBTITLE
, K.REQUIRING_OFFICE
, K.FREQUENCY
, K.DATE_OF_FIRST_SUBMISSION
, K.COPIES_REQUIRED
, K.COST_OF_SALE_RATE
, K.LINE_VALUE_TOTAL
, K.UNDEF_UNIT_PRICE
, K.UNDEF_LINE_VALUE
, K.UNDEF_LINE_VALUE_TOTAL
, K.SCHEDULED_DELV_DEFAULT
, K.CREATED_BY
, K.CREATION_DATE
, K.LAST_UPDATED_BY
, K.LAST_UPDATE_LOGIN
, K.LAST_UPDATE_DATE
, K.TRN_CODE
, K.ATTRIBUTE_CATEGORY
, K.ATTRIBUTE1
, K.ATTRIBUTE2
, K.ATTRIBUTE3
, K.ATTRIBUTE4
, K.ATTRIBUTE5
, K.ATTRIBUTE6
, K.ATTRIBUTE7
, K.ATTRIBUTE8
, K.ATTRIBUTE9
, K.ATTRIBUTE10
, K.ATTRIBUTE11
, K.ATTRIBUTE12
, K.ATTRIBUTE13
, K.ATTRIBUTE14
, K.ATTRIBUTE15
FROM OKE_K_LINES_FULL_HV K
, OKE_K_ALL_ACCESS_BASIC_V ACC
WHERE ACC.K_HEADER_ID = K.HEADER_ID
AND ACC.PERSON_ID = FND_GLOBAL.EMPLOYEE_ID
AND ( OKE_UTILS.CROSS_ORG_ACCESS = 'Y' OR NVL(K.AUTHORING_ORG_ID
, -99) = OKE_UTILS.ORG_ID )