View: OKE_K_HEADERS_V

Product:	OKE - Project Contracts
Description:	Contract header information view
Implementation/DBA Data:	APPS.OKE_K_HEADERS_V

View Text

SELECT CH.ROWID
, EH.K_HEADER_ID
, CH.OBJECT_VERSION_NUMBER
, CH.CONTRACT_NUMBER_MODIFIER
, CH.SCS_CODE
, CH.AUTHORING_ORG_ID
, CH.CONTRACT_NUMBER
, EH.K_NUMBER_DISP
, CHT.COGNOMEN
, CH.CHR_TYPE
, EH.K_TYPE_CODE
, CH.ESTIMATED_AMOUNT
, EH.PRODUCT_LINE_CODE
, EH.PRIORITY_CODE
, EH.PROGRAM_ID
, CH.START_DATE
, CH.END_DATE
, CH.BUY_OR_SELL
, EH.AWARD_DATE
, CH.STS_CODE
, CHT.SHORT_DESCRIPTION
, CHT.DESCRIPTION
, EH.PRIME_K_ALIAS
, EH.PRIME_K_NUMBER
, EH.CLASSIFIED_FLAG
, EH.DCAA_AUDIT_REQ_FLAG
, EH.BOOKED_FLAG
, EH.OPEN_FLAG
, EH.EXPORT_FLAG
, EH.BOA_ID
, EH.AUTHORIZE_DATE
, EH.SIC_CODE
, EH.AUTHORIZING_REASON
, EH.DATE_ISSUED
, EH.DATE_SIGN_BY_CUSTOMER
, EH.DATE_SIGN_BY_CONTRACTOR
, EH.DATE_RECEIVED
, EH.AWARD_CANCEL_DATE
, EH.FAA_APPROVE_DATE
, EH.FAA_REJECT_DATE
, EH.PROJECT_ID
, CH.CUST_PO_NUMBER
, EH.NO_COMPETITION_AUTHORIZE
, EH.HUMAN_SUBJECT_FLAG
, EH.PENALTY_CLAUSE_FLAG
, EH.SB_PLAN_REQ_FLAG
, EH.SB_REPORT_FLAG
, EH.CQA_FLAG
, EH.REPORTING_FLAG
, EH.CFE_FLAG
, CH.CURRENCY_CODE
, EH.COUNTRY_OF_ORIGIN_CODE
, EH.COST_OF_MONEY
, EH.DATE_DEFINITIZED
, EH.DATE_NEGOTIATED
, EH.COST_SHARE_FLAG
, EH.NTE_WARNING_FLAG
, EH.INTERIM_RPT_REQ_FLAG
, EH.CLIENT_APPROVE_REQ_FLAG
, EH.CAS_FLAG
, EH.BILL_WITHOUT_DEF_FLAG
, EH.OH_RATES_FINAL_FLAG
, EH.NTE_AMOUNT
, EH.TECH_DATA_WH_RATE
, EH.PROGRESS_PAYMENT_FLAG
, EH.PROGRESS_PAYMENT_LIQ_RATE
, EH.PROGRESS_PAYMENT_RATE
, EH.ALTERNATE_LIQUIDATION_RATE
, EH.VAT_CODE
, EH.PROP_DELIVERY_LOCATION
, EH.PROP_DUE_DATE_TIME
, EH.PROP_DUE_TIME
, EH.PROP_EXPIRE_DATE
, EH.COPIES_REQUIRED
, EH.DEFINITIZED_FLAG
, EH.FINANCIAL_CTRL_VERIFIED_FLAG
, EH.COST_OF_SALE_RATE
, EH.LINE_VALUE_TOTAL
, EH.UNDEF_LINE_VALUE_TOTAL
, EH.OWNING_ORGANIZATION_ID
, CH.TEMPLATE_YN
, CH.QCL_ID
, CH.TRN_CODE
, CH.ISSUE_OR_RECEIVE
, CHT.COMMENTS
, CH.CREATION_DATE
, CH.CREATED_BY
, CH.LAST_UPDATE_DATE
, CH.LAST_UPDATED_BY
, CH.LAST_UPDATE_LOGIN
, CH.ATTRIBUTE_CATEGORY
, CH.ATTRIBUTE1
, CH.ATTRIBUTE2
, CH.ATTRIBUTE3
, CH.ATTRIBUTE4
, CH.ATTRIBUTE5
, CH.ATTRIBUTE6
, CH.ATTRIBUTE7
, CH.ATTRIBUTE8
, CH.ATTRIBUTE9
, CH.ATTRIBUTE10
, CH.ATTRIBUTE11
, CH.ATTRIBUTE12
, CH.ATTRIBUTE13
, CH.ATTRIBUTE14
, CH.ATTRIBUTE15
FROM OKC_K_HEADERS_B CH
, OKE_K_HEADERS EH
, OKC_K_HEADERS_TL CHT
WHERE CH.ID = EH.K_HEADER_ID
AND CH.ID = CHT.ID
AND CHT.LANGUAGE = USERENV('LANG')

Columns