VIEW: APPS.OKE_K_HEADERS_FWDN_V

Source

View Text - Preformatted

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 , DECODE (TYPE_CLASS_CODE, 'DO', BOA_NUMBER || '/'|| K_NUMBER, 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 ,DEFAULT_TASK_ID ,DEFAULT_TASK_NUMBER FROM OKE_K_HEADERS_SECURE_V

View Text - HTML Formatted

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
, DECODE (TYPE_CLASS_CODE
, 'DO'
, BOA_NUMBER || '/'|| K_NUMBER
, 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
, DEFAULT_TASK_ID
, DEFAULT_TASK_NUMBER
FROM OKE_K_HEADERS_SECURE_V