Product: | OKE - Project Contracts |
---|---|
Description: | Secured historical contract header extended information view |
Implementation/DBA Data: | APPS.OKE_K_HEADERS_SECURE_HV |
SELECT K.ROW_ID
, K.K_HEADER_ID
, K.MAJOR_VERSION
, K.MINOR_VERSION
, K.VERSION_DISP
, K.OBJECT_VERSION_NUMBER
, K.CONTRACT_NUMBER_MODIFIER
, K.SCS_CODE
, K.AUTHORING_ORG_ID
, K.AUTHORING_ORG
, K.K_NUMBER
, K.K_ALIAS
, K.CHR_TYPE
, K.K_TYPE_CODE
, K.K_TYPE
, K.TYPE_CLASS_CODE
, K.K_VALUE
, K.PRODUCT_LINE_CODE
, K.PRODUCT_LINE
, K.PRIORITY_CODE
, K.PRIORITY_RATING
, K.PROGRAM_ID
, K.PROGRAM_NUMBER
, K.START_DATE
, K.END_DATE
, K.BUY_OR_SELL
, K.AWARD_DATE
, K.STATUS_CODE
, K.STATUS
, K.SHORT_DESCRIPTION
, K.DESCRIPTION
, K.PRIME_K_ALIAS
, K.PRIME_K_NUMBER
, K.CLASSIFIED_FLAG
, K.CLASSIFIED_YN
, K.DCAA_AUDIT_REQ_FLAG
, K.DCAA_AUDIT_REQ_YN
, K.BOOKED_FLAG
, K.BOOKED_YN
, K.OPEN_FLAG
, K.OPEN_YN
, K.EXPORT_FLAG
, K.EXPORT_YN
, K.BOA_ID
, K.BOA_NUMBER
, K.AUTHORIZE_DATE
, K.SIC_CODE
, K.AUTHORIZING_REASON
, K.DATE_ISSUED
, K.DATE_SIGN_BY_CUSTOMER
, K.DATE_SIGN_BY_CONTRACTOR
, K.DATE_RECEIVED
, K.DATE_APPROVED
, K.AWARD_CANCEL_DATE
, K.FAA_APPROVE_DATE
, K.FAA_REJECT_DATE
, K.PROJECT_ID
, K.PROJECT_NUMBER
, K.PROJECT_NAME
, K.PROJECT_DESCRIPTION
, K.PROJECT_START_DATE
, K.PROJECT_COMPLETION_DATE
, K.PROJECT_ORGANIZATION
, K.CUSTOMER_PO_NUMBER
, K.NO_COMPETITION_AUTHORIZE
, K.HUMAN_SUBJECT_FLAG
, K.HUMAN_SUBJECT_YN
, K.PENALTY_CLAUSE_FLAG
, K.PENALTY_CLAUSE_YN
, K.SB_PLAN_REQ_FLAG
, K.SB_PLAN_REQ_YN
, K.SB_REPORT_FLAG
, K.SB_REPORT_YN
, K.CQA_FLAG
, K.CQA_YN
, K.REPORTING_FLAG
, K.REPORTING_YN
, K.CFE_FLAG
, K.CFE_YN
, K.CURRENCY_CODE
, K.COUNTRY_OF_ORIGIN_CODE
, K.COST_OF_MONEY
, K.COST_OF_MONEY_YN
, K.DATE_DEFINITIZED
, K.DATE_NEGOTIATED
, K.COST_SHARE_FLAG
, K.COST_SHARE_YN
, K.NTE_WARNING_FLAG
, K.NTE_WARNING_YN
, K.INTERIM_RPT_REQ_FLAG
, K.INTERIM_RPT_REQ_YN
, K.CLIENT_APPROVE_REQ_FLAG
, K.CLIENT_APPROVE_REQ_YN
, K.CAS_FLAG
, K.CAS_YN
, K.BILL_WITHOUT_DEF_FLAG
, K.BILL_WITHOUT_DEF_YN
, K.OH_RATES_FINAL_FLAG
, K.OH_RATES_FINAL_YN
, K.NTE_AMOUNT
, K.TECH_DATA_WH_RATE
, K.PROGRESS_PAYMENT_FLAG
, K.PROGRESS_PAYMENT_YN
, K.PROGRESS_PAYMENT_LIQ_RATE
, K.PROGRESS_PAYMENT_RATE
, K.ALTERNATE_LIQUIDATION_RATE
, K.VAT_CODE
, K.PROP_DELIVERY_LOCATION
, K.PROP_DUE_DATE_TIME
, K.PROP_DUE_TIME
, K.PROP_EXPIRE_DATE
, K.COPIES_REQUIRED
, K.DEFINITIZED_FLAG
, K.DEFINITIZED_YN
, K.FINANCIAL_CTRL_VERIFIED_FLAG
, K.FINANCIAL_CTRL_VERIFIED_YN
, K.COST_OF_SALE_RATE
, K.LINE_VALUE_TOTAL
, K.UNDEF_LINE_VALUE_TOTAL
, K.OWNING_ORGANIZATION_ID
, K.OWNING_ORGANIZATION
, K.TEMPLATE_YN
, K.TEMPLATE_YN_DSP
, K.QCL_ID
, K.TRN_CODE
, K.ISSUE_OR_RECEIVE
, K.COMMENTS
, K.CREATION_DATE
, K.CREATED_BY
, K.LAST_UPDATE_DATE
, K.LAST_UPDATED_BY
, K.LAST_UPDATE_LOGIN
, 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_HEADERS_FULL_HV K
, OKE_K_ALL_ACCESS_BASIC_V ACC
WHERE ACC.K_HEADER_ID = K.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 )