VIEW: APPS.OKE_K_HEADERS_V

Source

View Text - Preformatted

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 ,EH.DEFAULT_TASK_ID ,PT.TASK_NUMBER FROM OKC_K_HEADERS_ALL_B CH , OKE_K_HEADERS EH , OKC_K_HEADERS_TL CHT , PA_TASKS PT WHERE CH.ID = EH.K_HEADER_ID AND CH.ID = CHT.ID AND CHT.LANGUAGE = USERENV('LANG') AND PT.TASK_ID (+) = EH.DEFAULT_TASK_ID

View Text - HTML Formatted

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
, EH.DEFAULT_TASK_ID
, PT.TASK_NUMBER
FROM OKC_K_HEADERS_ALL_B CH
, OKE_K_HEADERS EH
, OKC_K_HEADERS_TL CHT
, PA_TASKS PT
WHERE CH.ID = EH.K_HEADER_ID
AND CH.ID = CHT.ID
AND CHT.LANGUAGE = USERENV('LANG')
AND PT.TASK_ID (+) = EH.DEFAULT_TASK_ID