VIEW: APPS.OKE_K_HEADERS_FULL_HV

Source

View Text - Preformatted

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 ,OKE_UTILS.get_term_value(EH.k_header_id,'OB_FREIGHT_TERMS') ,OKE_UTILS.get_term_value(EH.k_header_id,'OB_FOB') ,EH.DEFAULT_TASK_ID ,PT.TASK_NUMBER FROM OKE_K_HEADERS_H EH , OKC_K_HEADERS_ALL_BH CH , OKC_K_HEADERS_TLH CHT , OKC_K_HEADERS_ALL_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 , PA_TASKS PT 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') AND PT.TASK_ID (+) = EH.DEFAULT_TASK_ID

View Text - HTML Formatted

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
, OKE_UTILS.GET_TERM_VALUE(EH.K_HEADER_ID
, 'OB_FREIGHT_TERMS')
, OKE_UTILS.GET_TERM_VALUE(EH.K_HEADER_ID
, 'OB_FOB')
, EH.DEFAULT_TASK_ID
, PT.TASK_NUMBER
FROM OKE_K_HEADERS_H EH
, OKC_K_HEADERS_ALL_BH CH
, OKC_K_HEADERS_TLH CHT
, OKC_K_HEADERS_ALL_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
, PA_TASKS PT
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')
AND PT.TASK_ID (+) = EH.DEFAULT_TASK_ID