Product: | OKE - Project Contracts |
---|---|
Description: | Historical contract header extended information view |
Implementation/DBA Data: | APPS.OKE_K_HEADERS_FULL_HV |
SELECT CH.ROWID
, EH.K_HEADER_ID
, EH.MAJOR_VERSION
, 0
, EH.MAJOR_VERSION || '.0'
, CH.OBJECT_VERSION_NUMBER
, CH.CONTRACT_NUMBER_MODIFIER
, CH.SCS_CODE
, CH.AUTHORING_ORG_ID
, ORG.NAME
, CH.CONTRACT_NUMBER
, CHT.COGNOMEN
, CH.CHR_TYPE
, EH.K_TYPE_CODE
, KT.K_TYPE_NAME
, KT.TYPE_CLASS_CODE
, CH.ESTIMATED_AMOUNT
, EH.OWNING_ORGANIZATION_ID
, OORG.NAME
, EH.PRODUCT_LINE_CODE
, PL.MEANING
, EH.PRIORITY_CODE
, PR.PRIORITY_NAME
, EH.PROGRAM_ID
, PGM.PROGRAM_NUMBER
, CH.START_DATE
, CH.END_DATE
, CH.BUY_OR_SELL
, EH.AWARD_DATE
, CH.STS_CODE
, ST.MEANING
, CHT.SHORT_DESCRIPTION
, CHT.DESCRIPTION
, EH.PRIME_K_ALIAS
, EH.PRIME_K_NUMBER
, EH.CLASSIFIED_FLAG
, OKE_UTILS.YES_NO( NVL(EH.CLASSIFIED_FLAG
, 'N') )
, EH.DCAA_AUDIT_REQ_FLAG
, OKE_UTILS.YES_NO( NVL(EH.DCAA_AUDIT_REQ_FLAG
, 'N') )
, EH.BOOKED_FLAG
, OKE_UTILS.YES_NO( NVL(EH.BOOKED_FLAG
, 'N') )
, EH.OPEN_FLAG
, OKE_UTILS.YES_NO( NVL(EH.OPEN_FLAG
, 'N') )
, EH.EXPORT_FLAG
, OKE_UTILS.YES_NO( NVL(EH.EXPORT_FLAG
, 'N') )
, EH.BOA_ID
, BOA.CONTRACT_NUMBER
, 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
, CH.DATE_APPROVED
, EH.AWARD_CANCEL_DATE
, EH.FAA_APPROVE_DATE
, EH.FAA_REJECT_DATE
, EH.PROJECT_ID
, PRJ.SEGMENT1
, PRJ.NAME
, PRJ.DESCRIPTION
, PRJ.START_DATE
, PRJ.COMPLETION_DATE
, PORG.NAME
, CH.CUST_PO_NUMBER
, EH.NO_COMPETITION_AUTHORIZE
, EH.HUMAN_SUBJECT_FLAG
, OKE_UTILS.YES_NO( NVL(EH.HUMAN_SUBJECT_FLAG
, 'N') )
, EH.PENALTY_CLAUSE_FLAG
, OKE_UTILS.YES_NO( NVL(EH.PENALTY_CLAUSE_FLAG
, 'N') )
, EH.SB_PLAN_REQ_FLAG
, OKE_UTILS.YES_NO( NVL(EH.SB_PLAN_REQ_FLAG
, 'N') )
, EH.SB_REPORT_FLAG
, OKE_UTILS.YES_NO( NVL(EH.SB_REPORT_FLAG
, 'N') )
, EH.CQA_FLAG
, OKE_UTILS.YES_NO( NVL(EH.CQA_FLAG
, 'N') )
, EH.REPORTING_FLAG
, OKE_UTILS.YES_NO( NVL(EH.REPORTING_FLAG
, 'N') )
, EH.CFE_FLAG
, OKE_UTILS.YES_NO( NVL(EH.CFE_FLAG
, 'N') )
, CH.CURRENCY_CODE
, EH.COUNTRY_OF_ORIGIN_CODE
, EH.COST_OF_MONEY
, OKE_UTILS.YES_NO( NVL(EH.COST_OF_MONEY
, 'N') )
, EH.DATE_DEFINITIZED
, EH.DATE_NEGOTIATED
, EH.COST_SHARE_FLAG
, OKE_UTILS.YES_NO( NVL(EH.COST_SHARE_FLAG
, 'N') )
, EH.NTE_WARNING_FLAG
, OKE_UTILS.YES_NO( NVL(EH.NTE_WARNING_FLAG
, 'N') )
, EH.INTERIM_RPT_REQ_FLAG
, OKE_UTILS.YES_NO( NVL(EH.INTERIM_RPT_REQ_FLAG
, 'N') )
, EH.CLIENT_APPROVE_REQ_FLAG
, OKE_UTILS.YES_NO( NVL(EH.CLIENT_APPROVE_REQ_FLAG
, 'N') )
, EH.CAS_FLAG
, OKE_UTILS.YES_NO( NVL(EH.CAS_FLAG
, 'N') )
, EH.BILL_WITHOUT_DEF_FLAG
, OKE_UTILS.YES_NO( NVL(EH.BILL_WITHOUT_DEF_FLAG
, 'N') )
, EH.OH_RATES_FINAL_FLAG
, OKE_UTILS.YES_NO( NVL(EH.OH_RATES_FINAL_FLAG
, 'N') )
, EH.NTE_AMOUNT
, EH.TECH_DATA_WH_RATE
, EH.PROGRESS_PAYMENT_FLAG
, OKE_UTILS.YES_NO( NVL(EH.PROGRESS_PAYMENT_FLAG
, 'N') )
, 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
, OKE_UTILS.YES_NO( NVL(EH.DEFINITIZED_FLAG
, 'N') )
, EH.FINANCIAL_CTRL_VERIFIED_FLAG
, OKE_UTILS.YES_NO( NVL(EH.FINANCIAL_CTRL_VERIFIED_FLAG
, 'N') )
, EH.COST_OF_SALE_RATE
, EH.LINE_VALUE_TOTAL
, EH.UNDEF_LINE_VALUE_TOTAL
, CH.TEMPLATE_YN
, OKE_UTILS.YES_NO( NVL(CH.TEMPLATE_YN
, 'N') )
, 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 OKE_K_HEADERS_H EH
, OKC_K_HEADERS_BH CH
, OKC_K_HEADERS_TLH CHT
, OKC_K_HEADERS_B BOA
, PA_PROJECTS_ALL PRJ
, OKE_PROGRAMS PGM
, OKE_K_TYPES_VL KT
, FND_LOOKUP_VALUES PL
, OKE_PRIORITY_CODES_TL PR
, OKC_STATUSES_TL ST
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, HR_ALL_ORGANIZATION_UNITS_TL OORG
, HR_ALL_ORGANIZATION_UNITS_TL PORG
WHERE CH.ID = EH.K_HEADER_ID
AND CH.MAJOR_VERSION = EH.MAJOR_VERSION
AND CHT.ID = CH.ID
AND CHT.MAJOR_VERSION = CH.MAJOR_VERSION
AND CHT.LANGUAGE = USERENV('LANG')
AND PRJ.PROJECT_ID (+) = EH.PROJECT_ID
AND BOA.ID (+) = EH.BOA_ID
AND PGM.PROGRAM_ID (+) = EH.PROGRAM_ID
AND KT.K_TYPE_CODE = EH.K_TYPE_CODE
AND PL.VIEW_APPLICATION_ID (+) = 777
AND PL.LOOKUP_TYPE (+) = 'PRODUCT_LINE'
AND PL.LOOKUP_CODE (+) = EH.PRODUCT_LINE_CODE
AND PL.LANGUAGE (+) = USERENV('LANG')
AND PR.PRIORITY_CODE (+) = EH.PRIORITY_CODE
AND PR.LANGUAGE (+) = USERENV('LANG')
AND ST.CODE = CH.STS_CODE
AND ST.LANGUAGE = USERENV('LANG')
AND ORG.ORGANIZATION_ID (+) = CH.AUTHORING_ORG_ID
AND ORG.LANGUAGE (+) = USERENV('LANG')
AND OORG.ORGANIZATION_ID (+) = EH.OWNING_ORGANIZATION_ID
AND OORG.LANGUAGE (+) = USERENV('LANG')
AND PORG.ORGANIZATION_ID (+) = PRJ.CARRYING_OUT_ORGANIZATION_ID
AND PORG.LANGUAGE (+) = USERENV('LANG')