VIEW: OKS.OKS_CON_LINES_INT_ALL#

Source

View Text - Preformatted

select CONTRACT_LINE_ID CONTRACT_LINE_ID, CONTRACT_ID CONTRACT_ID, CONTRACT_LINE_NUMBER CONTRACT_LINE_NUMBER, CONTRACT_LINE_TYPE CONTRACT_LINE_TYPE, SERVICE_INVENTORY_ITEM_ID SERVICE_INVENTORY_ITEM_ID, SERVICE_MANUFACTURING_ORG_ID SERVICE_MANUFACTURING_ORG_ID, CONTRACT_LINE_REF CONTRACT_LINE_REF, ORDER_HEADER_ID ORDER_HEADER_ID, ORDER_LINE_ID ORDER_LINE_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, CUST_BILL_TO_SITE_USE_ID CUST_BILL_TO_SITE_USE_ID, CUST_SHIP_TO_SITE_USE_ID CUST_SHIP_TO_SITE_USE_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, 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, BILL_TO_CONTACT_ID BILL_TO_CONTACT_ID, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, LINE_STATUS_CODE LINE_STATUS_CODE, START_DATE START_DATE, END_DATE END_DATE, RENEWAL_TYPE RENEWAL_TYPE, INVOICE_TEXT INVOICE_TEXT, COVERAGE_ID COVERAGE_ID, COVERAGE_TEMPLATE_ID COVERAGE_TEMPLATE_ID, EXCEPT_COVERAGE_ID EXCEPT_COVERAGE_ID, PRICE_LIST_ID PRICE_LIST_ID, PRICE_UNIT PRICE_UNIT, PRICE_NEGOTIATED PRICE_NEGOTIATED, PRICE_UNIT_PERCENT PRICE_UNIT_PERCENT, CURRENCY_CODE CURRENCY_CODE, CONVERSION_TYPE CONVERSION_TYPE, CONVERSION_RATE CONVERSION_RATE, CONVERSION_DATE CONVERSION_DATE, INVOICE_PRINT_FLAG INVOICE_PRINT_FLAG, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, INVOICING_RULE_ID INVOICING_RULE_ID, PAYMENT_TERMS_ID PAYMENT_TERMS_ID, SUMMARY_INVOICE_YN SUMMARY_INVOICE_YN, RENEWAL_PO_NUMBER RENEWAL_PO_NUMBER, AR_INTERFACE_YN AR_INTERFACE_YN, HOLD_BILLING_YN HOLD_BILLING_YN, BILLING_TXN_TYPE_ID BILLING_TXN_TYPE_ID, TAX_STATUS TAX_STATUS, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER, TAX_CODE TAX_CODE, TAX_EXEMPT_REASON TAX_EXEMPT_REASON, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, AUTHORING_ORG_ID AUTHORING_ORG_ID, INTERFACED_STATUS_FLAG INTERFACED_STATUS_FLAG, MERGE_ID MERGE_ID from "OKS"."OKS_CON_LINES_INT_ALL"

View Text - HTML Formatted

SELECT CONTRACT_LINE_ID CONTRACT_LINE_ID
, CONTRACT_ID CONTRACT_ID
, CONTRACT_LINE_NUMBER CONTRACT_LINE_NUMBER
, CONTRACT_LINE_TYPE CONTRACT_LINE_TYPE
, SERVICE_INVENTORY_ITEM_ID SERVICE_INVENTORY_ITEM_ID
, SERVICE_MANUFACTURING_ORG_ID SERVICE_MANUFACTURING_ORG_ID
, CONTRACT_LINE_REF CONTRACT_LINE_REF
, ORDER_HEADER_ID ORDER_HEADER_ID
, ORDER_LINE_ID ORDER_LINE_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, CUST_BILL_TO_SITE_USE_ID CUST_BILL_TO_SITE_USE_ID
, CUST_SHIP_TO_SITE_USE_ID CUST_SHIP_TO_SITE_USE_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, 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
, BILL_TO_CONTACT_ID BILL_TO_CONTACT_ID
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, LINE_STATUS_CODE LINE_STATUS_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, RENEWAL_TYPE RENEWAL_TYPE
, INVOICE_TEXT INVOICE_TEXT
, COVERAGE_ID COVERAGE_ID
, COVERAGE_TEMPLATE_ID COVERAGE_TEMPLATE_ID
, EXCEPT_COVERAGE_ID EXCEPT_COVERAGE_ID
, PRICE_LIST_ID PRICE_LIST_ID
, PRICE_UNIT PRICE_UNIT
, PRICE_NEGOTIATED PRICE_NEGOTIATED
, PRICE_UNIT_PERCENT PRICE_UNIT_PERCENT
, CURRENCY_CODE CURRENCY_CODE
, CONVERSION_TYPE CONVERSION_TYPE
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_DATE CONVERSION_DATE
, INVOICE_PRINT_FLAG INVOICE_PRINT_FLAG
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, INVOICING_RULE_ID INVOICING_RULE_ID
, PAYMENT_TERMS_ID PAYMENT_TERMS_ID
, SUMMARY_INVOICE_YN SUMMARY_INVOICE_YN
, RENEWAL_PO_NUMBER RENEWAL_PO_NUMBER
, AR_INTERFACE_YN AR_INTERFACE_YN
, HOLD_BILLING_YN HOLD_BILLING_YN
, BILLING_TXN_TYPE_ID BILLING_TXN_TYPE_ID
, TAX_STATUS TAX_STATUS
, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, TAX_CODE TAX_CODE
, TAX_EXEMPT_REASON TAX_EXEMPT_REASON
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AUTHORING_ORG_ID AUTHORING_ORG_ID
, INTERFACED_STATUS_FLAG INTERFACED_STATUS_FLAG
, MERGE_ID MERGE_ID
FROM "OKS"."OKS_CON_LINES_INT_ALL"