Product: | OKE - Project Contracts |
---|---|
Description: | Contract header view for flowdown |
Implementation/DBA Data: | APPS.OKE_K_HEADERS_FWDN_V |
SELECT ROW_ID
, K_HEADER_ID
, MAJOR_VERSION
, MINOR_VERSION
, VERSION_DISP
, OBJECT_VERSION_NUMBER
, CONTRACT_NUMBER_MODIFIER
, SCS_CODE
, AUTHORING_ORG_ID
, AUTHORING_ORG
, K_NUMBER
, K_ALIAS
, CHR_TYPE
, K_TYPE_CODE
, K_TYPE
, TYPE_CLASS_CODE
, TO_CHAR( K_VALUE
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( CURRENCY_CODE
, 38 ) )
, PRODUCT_LINE_CODE
, PRODUCT_LINE
, PRIORITY_CODE
, PRIORITY_RATING
, PROGRAM_ID
, PROGRAM_NUMBER
, START_DATE
, END_DATE
, BUY_OR_SELL
, AWARD_DATE
, STATUS_CODE
, STATUS
, SHORT_DESCRIPTION
, DESCRIPTION
, PRIME_K_ALIAS
, PRIME_K_NUMBER
, CLASSIFIED_FLAG
, CLASSIFIED_YN
, DCAA_AUDIT_REQ_FLAG
, DCAA_AUDIT_REQ_YN
, BOOKED_FLAG
, BOOKED_YN
, OPEN_FLAG
, OPEN_YN
, EXPORT_FLAG
, EXPORT_YN
, BOA_ID
, BOA_NUMBER
, AUTHORIZE_DATE
, SIC_CODE
, AUTHORIZING_REASON
, DATE_ISSUED
, DATE_SIGN_BY_CUSTOMER
, DATE_SIGN_BY_CONTRACTOR
, DATE_RECEIVED
, DATE_APPROVED
, AWARD_CANCEL_DATE
, FAA_APPROVE_DATE
, FAA_REJECT_DATE
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_DESCRIPTION
, PROJECT_START_DATE
, PROJECT_COMPLETION_DATE
, PROJECT_ORGANIZATION
, CUSTOMER_PO_NUMBER
, NO_COMPETITION_AUTHORIZE
, HUMAN_SUBJECT_FLAG
, HUMAN_SUBJECT_YN
, PENALTY_CLAUSE_FLAG
, PENALTY_CLAUSE_YN
, SB_PLAN_REQ_FLAG
, SB_PLAN_REQ_YN
, SB_REPORT_FLAG
, SB_REPORT_YN
, CQA_FLAG
, CQA_YN
, REPORTING_FLAG
, REPORTING_YN
, CFE_FLAG
, CFE_YN
, CURRENCY_CODE
, COUNTRY_OF_ORIGIN_CODE
, COST_OF_MONEY
, COST_OF_MONEY_YN
, DATE_DEFINITIZED
, DATE_NEGOTIATED
, COST_SHARE_FLAG
, COST_SHARE_YN
, NTE_WARNING_FLAG
, NTE_WARNING_YN
, INTERIM_RPT_REQ_FLAG
, INTERIM_RPT_REQ_YN
, CLIENT_APPROVE_REQ_FLAG
, CLIENT_APPROVE_REQ_YN
, CAS_FLAG
, CAS_YN
, BILL_WITHOUT_DEF_FLAG
, BILL_WITHOUT_DEF_YN
, OH_RATES_FINAL_FLAG
, OH_RATES_FINAL_YN
, TO_CHAR( NTE_AMOUNT
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( CURRENCY_CODE
, 38 ) )
, TECH_DATA_WH_RATE
, PROGRESS_PAYMENT_FLAG
, PROGRESS_PAYMENT_YN
, PROGRESS_PAYMENT_LIQ_RATE
, PROGRESS_PAYMENT_RATE
, ALTERNATE_LIQUIDATION_RATE
, VAT_CODE
, PROP_DELIVERY_LOCATION
, PROP_DUE_DATE_TIME
, PROP_DUE_TIME
, PROP_EXPIRE_DATE
, COPIES_REQUIRED
, DEFINITIZED_FLAG
, DEFINITIZED_YN
, FINANCIAL_CTRL_VERIFIED_FLAG
, FINANCIAL_CTRL_VERIFIED_YN
, COST_OF_SALE_RATE
, TO_CHAR( LINE_VALUE_TOTAL
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( CURRENCY_CODE
, 38 ) )
, TO_CHAR(UNDEF_LINE_VALUE_TOTAL
, FND_CURRENCY_CACHE.GET_FORMAT_MASK( CURRENCY_CODE
, 38 ) )
, OWNING_ORGANIZATION_ID
, OWNING_ORGANIZATION
, TEMPLATE_YN
, TEMPLATE_YN_DSP
, QCL_ID
, TRN_CODE
, ISSUE_OR_RECEIVE
, COMMENTS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM OKE_K_HEADERS_SECURE_V