VIEW: OKC.OKC_K_HEADERS_ALL_B#

Source

View Text - Preformatted

select ID ID, CONTRACT_NUMBER CONTRACT_NUMBER, AUTHORING_ORG_ID AUTHORING_ORG_ID, CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER, CHR_ID_RESPONSE CHR_ID_RESPONSE, CHR_ID_AWARD CHR_ID_AWARD, CHR_ID_RENEWED CHR_ID_RENEWED, INV_ORGANIZATION_ID INV_ORGANIZATION_ID, STS_CODE STS_CODE, QCL_ID QCL_ID, SCS_CODE SCS_CODE, TRN_CODE TRN_CODE, CURRENCY_CODE CURRENCY_CODE, ARCHIVED_YN ARCHIVED_YN, DELETED_YN DELETED_YN, TEMPLATE_YN TEMPLATE_YN, CHR_TYPE CHR_TYPE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CUST_PO_NUMBER_REQ_YN CUST_PO_NUMBER_REQ_YN, PRE_PAY_REQ_YN PRE_PAY_REQ_YN, CUST_PO_NUMBER CUST_PO_NUMBER, DPAS_RATING DPAS_RATING, TEMPLATE_USED TEMPLATE_USED, DATE_APPROVED DATE_APPROVED, DATETIME_CANCELLED DATETIME_CANCELLED, AUTO_RENEW_DAYS AUTO_RENEW_DAYS, DATE_ISSUED DATE_ISSUED, DATETIME_RESPONDED DATETIME_RESPONDED, RFP_TYPE RFP_TYPE, KEEP_ON_MAIL_LIST KEEP_ON_MAIL_LIST, SET_ASIDE_PERCENT SET_ASIDE_PERCENT, RESPONSE_COPIES_REQ RESPONSE_COPIES_REQ, DATE_CLOSE_PROJECTED DATE_CLOSE_PROJECTED, DATETIME_PROPOSED DATETIME_PROPOSED, DATE_SIGNED DATE_SIGNED, DATE_TERMINATED DATE_TERMINATED, DATE_RENEWED DATE_RENEWED, START_DATE START_DATE, END_DATE END_DATE, BUY_OR_SELL BUY_OR_SELL, ISSUE_OR_RECEIVE ISSUE_OR_RECEIVE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ESTIMATED_AMOUNT ESTIMATED_AMOUNT, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, LAST_UPDATE_DATE LAST_UPDATE_DATE, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, SECURITY_GROUP_ID SECURITY_GROUP_ID, CHR_ID_RENEWED_TO CHR_ID_RENEWED_TO, ESTIMATED_AMOUNT_RENEWED ESTIMATED_AMOUNT_RENEWED, CURRENCY_CODE_RENEWED CURRENCY_CODE_RENEWED, UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF, UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID, APPLICATION_ID APPLICATION_ID, RESOLVED_UNTIL RESOLVED_UNTIL, ORIG_SYSTEM_SOURCE_CODE ORIG_SYSTEM_SOURCE_CODE, ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1, ORIG_SYSTEM_REFERENCE1 ORIG_SYSTEM_REFERENCE1, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, PRICE_LIST_ID PRICE_LIST_ID, PRICING_DATE PRICING_DATE, TOTAL_LINE_LIST_PRICE TOTAL_LINE_LIST_PRICE, SIGN_BY_DATE SIGN_BY_DATE, USER_ESTIMATED_AMOUNT USER_ESTIMATED_AMOUNT, GOVERNING_CONTRACT_YN GOVERNING_CONTRACT_YN, DOCUMENT_ID DOCUMENT_ID, CONVERSION_TYPE CONVERSION_TYPE, CONVERSION_RATE CONVERSION_RATE, CONVERSION_RATE_DATE CONVERSION_RATE_DATE, CONVERSION_EURO_RATE CONVERSION_EURO_RATE, CUST_ACCT_ID CUST_ACCT_ID, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, INV_RULE_ID INV_RULE_ID, RENEWAL_TYPE_CODE RENEWAL_TYPE_CODE, RENEWAL_NOTIFY_TO RENEWAL_NOTIFY_TO, RENEWAL_END_DATE RENEWAL_END_DATE, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, PAYMENT_TERM_ID PAYMENT_TERM_ID, APPROVAL_TYPE APPROVAL_TYPE, TERM_CANCEL_SOURCE TERM_CANCEL_SOURCE, PAYMENT_INSTRUCTION_TYPE PAYMENT_INSTRUCTION_TYPE, ORG_ID ORG_ID, CANCELLED_AMOUNT CANCELLED_AMOUNT, BILLED_AT_SOURCE BILLED_AT_SOURCE from "OKC"."OKC_K_HEADERS_ALL_B"

View Text - HTML Formatted

SELECT ID ID
, CONTRACT_NUMBER CONTRACT_NUMBER
, AUTHORING_ORG_ID AUTHORING_ORG_ID
, CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, CHR_ID_RESPONSE CHR_ID_RESPONSE
, CHR_ID_AWARD CHR_ID_AWARD
, CHR_ID_RENEWED CHR_ID_RENEWED
, INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, STS_CODE STS_CODE
, QCL_ID QCL_ID
, SCS_CODE SCS_CODE
, TRN_CODE TRN_CODE
, CURRENCY_CODE CURRENCY_CODE
, ARCHIVED_YN ARCHIVED_YN
, DELETED_YN DELETED_YN
, TEMPLATE_YN TEMPLATE_YN
, CHR_TYPE CHR_TYPE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CUST_PO_NUMBER_REQ_YN CUST_PO_NUMBER_REQ_YN
, PRE_PAY_REQ_YN PRE_PAY_REQ_YN
, CUST_PO_NUMBER CUST_PO_NUMBER
, DPAS_RATING DPAS_RATING
, TEMPLATE_USED TEMPLATE_USED
, DATE_APPROVED DATE_APPROVED
, DATETIME_CANCELLED DATETIME_CANCELLED
, AUTO_RENEW_DAYS AUTO_RENEW_DAYS
, DATE_ISSUED DATE_ISSUED
, DATETIME_RESPONDED DATETIME_RESPONDED
, RFP_TYPE RFP_TYPE
, KEEP_ON_MAIL_LIST KEEP_ON_MAIL_LIST
, SET_ASIDE_PERCENT SET_ASIDE_PERCENT
, RESPONSE_COPIES_REQ RESPONSE_COPIES_REQ
, DATE_CLOSE_PROJECTED DATE_CLOSE_PROJECTED
, DATETIME_PROPOSED DATETIME_PROPOSED
, DATE_SIGNED DATE_SIGNED
, DATE_TERMINATED DATE_TERMINATED
, DATE_RENEWED DATE_RENEWED
, START_DATE START_DATE
, END_DATE END_DATE
, BUY_OR_SELL BUY_OR_SELL
, ISSUE_OR_RECEIVE ISSUE_OR_RECEIVE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CHR_ID_RENEWED_TO CHR_ID_RENEWED_TO
, ESTIMATED_AMOUNT_RENEWED ESTIMATED_AMOUNT_RENEWED
, CURRENCY_CODE_RENEWED CURRENCY_CODE_RENEWED
, UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF
, UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID
, APPLICATION_ID APPLICATION_ID
, RESOLVED_UNTIL RESOLVED_UNTIL
, ORIG_SYSTEM_SOURCE_CODE ORIG_SYSTEM_SOURCE_CODE
, ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1
, ORIG_SYSTEM_REFERENCE1 ORIG_SYSTEM_REFERENCE1
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, PRICE_LIST_ID PRICE_LIST_ID
, PRICING_DATE PRICING_DATE
, TOTAL_LINE_LIST_PRICE TOTAL_LINE_LIST_PRICE
, SIGN_BY_DATE SIGN_BY_DATE
, USER_ESTIMATED_AMOUNT USER_ESTIMATED_AMOUNT
, GOVERNING_CONTRACT_YN GOVERNING_CONTRACT_YN
, DOCUMENT_ID DOCUMENT_ID
, CONVERSION_TYPE CONVERSION_TYPE
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_RATE_DATE CONVERSION_RATE_DATE
, CONVERSION_EURO_RATE CONVERSION_EURO_RATE
, CUST_ACCT_ID CUST_ACCT_ID
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, INV_RULE_ID INV_RULE_ID
, RENEWAL_TYPE_CODE RENEWAL_TYPE_CODE
, RENEWAL_NOTIFY_TO RENEWAL_NOTIFY_TO
, RENEWAL_END_DATE RENEWAL_END_DATE
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, PAYMENT_TERM_ID PAYMENT_TERM_ID
, APPROVAL_TYPE APPROVAL_TYPE
, TERM_CANCEL_SOURCE TERM_CANCEL_SOURCE
, PAYMENT_INSTRUCTION_TYPE PAYMENT_INSTRUCTION_TYPE
, ORG_ID ORG_ID
, CANCELLED_AMOUNT CANCELLED_AMOUNT
, BILLED_AT_SOURCE BILLED_AT_SOURCE
FROM "OKC"."OKC_K_HEADERS_ALL_B"