VIEW: OKS.OKS_CON_HEADERS_INT_ALL#

Source

View Text - Preformatted

select CONTRACT_ID CONTRACT_ID, CONTRACT_NUMBER CONTRACT_NUMBER, CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER, BATCH_NUMBER BATCH_NUMBER, CONTRACT_AMOUNT CONTRACT_AMOUNT, ORDER_HEADER_ID ORDER_HEADER_ID, SHORT_DESCRIPTION SHORT_DESCRIPTION, KNOWN_AS KNOWN_AS, START_DATE START_DATE, END_DATE END_DATE, CONTRACT_CATEGORY_CODE CONTRACT_CATEGORY_CODE, STATUS_CODE STATUS_CODE, 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, CONTEXT CONTEXT, ORG_ID ORG_ID, INV_ORGANIZATION_ID INV_ORGANIZATION_ID, CUSTOMER_ID CUSTOMER_ID, THIRD_PARTY_ID THIRD_PARTY_ID, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, SALESPERSON_ID SALESPERSON_ID, AGREEMENT_ID AGREEMENT_ID, PRICE_LIST_ID PRICE_LIST_ID, INVOICING_RULE_ID INVOICING_RULE_ID, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, PAYMENT_TERMS_ID PAYMENT_TERMS_ID, CURRENCY_CODE CURRENCY_CODE, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE, CONVERSION_RATE CONVERSION_RATE, CONVERSION_DATE CONVERSION_DATE, PRE_PAYMENT_REQUIRED PRE_PAYMENT_REQUIRED, PO_REQUIRED PO_REQUIRED, PO_NUMBER PO_NUMBER, BILLING_TXN_TYPE_ID BILLING_TXN_TYPE_ID, AR_INTERFACE_YN AR_INTERFACE_YN, HOLD_BILLING_YN HOLD_BILLING_YN, SUMMARY_INVOICE_YN SUMMARY_INVOICE_YN, TAX_EXEMPT_STATUS TAX_EXEMPT_STATUS, TAX_EXEMPT_NUM TAX_EXEMPT_NUM, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, RENEWAL_TYPE RENEWAL_TYPE, RENEW_UPTO_DATE RENEW_UPTO_DATE, RENEWAL_PRICING_METHOD RENEWAL_PRICING_METHOD, RENEWAL_PRICE_LIST_ID RENEWAL_PRICE_LIST_ID, RENEWAL_MARKUP RENEWAL_MARKUP, RENEWAL_PO_REQUIRED_YN RENEWAL_PO_REQUIRED_YN, RENEWAL_PO_NUMBER RENEWAL_PO_NUMBER, RENEWAL_ESTIMATED_PERCENT RENEWAL_ESTIMATED_PERCENT, RENEWAL_DURATION RENEWAL_DURATION, RENEWAL_PERIOD_UOM RENEWAL_PERIOD_UOM, DATE_APPROVED DATE_APPROVED, DATE_SIGNED DATE_SIGNED, DATE_CANCELED DATE_CANCELED, DATE_TERMINATED DATE_TERMINATED, DATE_RENEWED DATE_RENEWED, QA_CHECK_ID QA_CHECK_ID, TEMPLATE_YN TEMPLATE_YN, CONTRACT_GROUP_ID CONTRACT_GROUP_ID, APPROVAL_WF_PROCESS_ID APPROVAL_WF_PROCESS_ID, RENEWAL_WF_PROCESS_ID RENEWAL_WF_PROCESS_ID, TERMINATE_WF_PROCESS_ID TERMINATE_WF_PROCESS_ID, CREDIT_CARD_NUMBER CREDIT_CARD_NUMBER, CREDIT_CARD_EXP_DATE CREDIT_CARD_EXP_DATE, COMMENTS COMMENTS, INTERFACED_STATUS_FLAG INTERFACED_STATUS_FLAG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, BILLING_PROFILE_ID BILLING_PROFILE_ID, REQUEST_ID REQUEST_ID from "OKS"."OKS_CON_HEADERS_INT_ALL"

View Text - HTML Formatted

SELECT CONTRACT_ID CONTRACT_ID
, CONTRACT_NUMBER CONTRACT_NUMBER
, CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, BATCH_NUMBER BATCH_NUMBER
, CONTRACT_AMOUNT CONTRACT_AMOUNT
, ORDER_HEADER_ID ORDER_HEADER_ID
, SHORT_DESCRIPTION SHORT_DESCRIPTION
, KNOWN_AS KNOWN_AS
, START_DATE START_DATE
, END_DATE END_DATE
, CONTRACT_CATEGORY_CODE CONTRACT_CATEGORY_CODE
, STATUS_CODE STATUS_CODE
, 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
, CONTEXT CONTEXT
, ORG_ID ORG_ID
, INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, CUSTOMER_ID CUSTOMER_ID
, THIRD_PARTY_ID THIRD_PARTY_ID
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, SALESPERSON_ID SALESPERSON_ID
, AGREEMENT_ID AGREEMENT_ID
, PRICE_LIST_ID PRICE_LIST_ID
, INVOICING_RULE_ID INVOICING_RULE_ID
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, PAYMENT_TERMS_ID PAYMENT_TERMS_ID
, CURRENCY_CODE CURRENCY_CODE
, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_DATE CONVERSION_DATE
, PRE_PAYMENT_REQUIRED PRE_PAYMENT_REQUIRED
, PO_REQUIRED PO_REQUIRED
, PO_NUMBER PO_NUMBER
, BILLING_TXN_TYPE_ID BILLING_TXN_TYPE_ID
, AR_INTERFACE_YN AR_INTERFACE_YN
, HOLD_BILLING_YN HOLD_BILLING_YN
, SUMMARY_INVOICE_YN SUMMARY_INVOICE_YN
, TAX_EXEMPT_STATUS TAX_EXEMPT_STATUS
, TAX_EXEMPT_NUM TAX_EXEMPT_NUM
, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, RENEWAL_TYPE RENEWAL_TYPE
, RENEW_UPTO_DATE RENEW_UPTO_DATE
, RENEWAL_PRICING_METHOD RENEWAL_PRICING_METHOD
, RENEWAL_PRICE_LIST_ID RENEWAL_PRICE_LIST_ID
, RENEWAL_MARKUP RENEWAL_MARKUP
, RENEWAL_PO_REQUIRED_YN RENEWAL_PO_REQUIRED_YN
, RENEWAL_PO_NUMBER RENEWAL_PO_NUMBER
, RENEWAL_ESTIMATED_PERCENT RENEWAL_ESTIMATED_PERCENT
, RENEWAL_DURATION RENEWAL_DURATION
, RENEWAL_PERIOD_UOM RENEWAL_PERIOD_UOM
, DATE_APPROVED DATE_APPROVED
, DATE_SIGNED DATE_SIGNED
, DATE_CANCELED DATE_CANCELED
, DATE_TERMINATED DATE_TERMINATED
, DATE_RENEWED DATE_RENEWED
, QA_CHECK_ID QA_CHECK_ID
, TEMPLATE_YN TEMPLATE_YN
, CONTRACT_GROUP_ID CONTRACT_GROUP_ID
, APPROVAL_WF_PROCESS_ID APPROVAL_WF_PROCESS_ID
, RENEWAL_WF_PROCESS_ID RENEWAL_WF_PROCESS_ID
, TERMINATE_WF_PROCESS_ID TERMINATE_WF_PROCESS_ID
, CREDIT_CARD_NUMBER CREDIT_CARD_NUMBER
, CREDIT_CARD_EXP_DATE CREDIT_CARD_EXP_DATE
, COMMENTS COMMENTS
, INTERFACED_STATUS_FLAG INTERFACED_STATUS_FLAG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BILLING_PROFILE_ID BILLING_PROFILE_ID
, REQUEST_ID REQUEST_ID
FROM "OKS"."OKS_CON_HEADERS_INT_ALL"