VIEW: CS.CS_ESTIMATES#

Source

View Text - Preformatted

select ESTIMATE_ID ESTIMATE_ID, ESTIMATE_BUSINESS_GROUP_ID ESTIMATE_BUSINESS_GROUP_ID, BUSINESS_PROCESS_ID BUSINESS_PROCESS_ID, ORDER_TYPE_ID ORDER_TYPE_ID, AGREEMENT_ID AGREEMENT_ID, CONTRACT_ID CONTRACT_ID, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID, CONTRACT_NUMBER CONTRACT_NUMBER, COVERAGE_ID COVERAGE_ID, COVERAGE_TXN_GROUP_ID COVERAGE_TXN_GROUP_ID, SOURCE_CODE SOURCE_CODE, SOURCE_ID SOURCE_ID, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, CUSTOMER_ID CUSTOMER_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REPAIR_LINE_ID REPAIR_LINE_ID, ESTIMATE_NUMBER ESTIMATE_NUMBER, DIAGNOSIS_ID DIAGNOSIS_ID, DIAGNOSIS_DATE DIAGNOSIS_DATE, DIAGNOSED_BY_ID DIAGNOSED_BY_ID, COMMENTS COMMENTS, CP_SERVICE_ID CP_SERVICE_ID, SERVICE_INVENTORY_ITEM_ID SERVICE_INVENTORY_ITEM_ID, PRICE_LIST_ID PRICE_LIST_ID, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE, CONVERSION_RATE CONVERSION_RATE, CONVERSION_DATE CONVERSION_DATE, PURCHASE_ORDER_NUM PURCHASE_ORDER_NUM, DISCOUNT_ID DISCOUNT_ID, JOB_COMPLETION_DATE JOB_COMPLETION_DATE, PROMISED_DELIVERY_DATE PROMISED_DELIVERY_DATE, APPROVAL_FLAG APPROVAL_FLAG, CUSTOMER_CONTACT_ID CUSTOMER_CONTACT_ID, CUSTOMER_CONTACT_DATE CUSTOMER_CONTACT_DATE, REJECT_REASON_CODE REJECT_REASON_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 from "CS"."CS_ESTIMATES"

View Text - HTML Formatted

SELECT ESTIMATE_ID ESTIMATE_ID
, ESTIMATE_BUSINESS_GROUP_ID ESTIMATE_BUSINESS_GROUP_ID
, BUSINESS_PROCESS_ID BUSINESS_PROCESS_ID
, ORDER_TYPE_ID ORDER_TYPE_ID
, AGREEMENT_ID AGREEMENT_ID
, CONTRACT_ID CONTRACT_ID
, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID
, CONTRACT_NUMBER CONTRACT_NUMBER
, COVERAGE_ID COVERAGE_ID
, COVERAGE_TXN_GROUP_ID COVERAGE_TXN_GROUP_ID
, SOURCE_CODE SOURCE_CODE
, SOURCE_ID SOURCE_ID
, BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, CUSTOMER_ID CUSTOMER_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REPAIR_LINE_ID REPAIR_LINE_ID
, ESTIMATE_NUMBER ESTIMATE_NUMBER
, DIAGNOSIS_ID DIAGNOSIS_ID
, DIAGNOSIS_DATE DIAGNOSIS_DATE
, DIAGNOSED_BY_ID DIAGNOSED_BY_ID
, COMMENTS COMMENTS
, CP_SERVICE_ID CP_SERVICE_ID
, SERVICE_INVENTORY_ITEM_ID SERVICE_INVENTORY_ITEM_ID
, PRICE_LIST_ID PRICE_LIST_ID
, CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_DATE CONVERSION_DATE
, PURCHASE_ORDER_NUM PURCHASE_ORDER_NUM
, DISCOUNT_ID DISCOUNT_ID
, JOB_COMPLETION_DATE JOB_COMPLETION_DATE
, PROMISED_DELIVERY_DATE PROMISED_DELIVERY_DATE
, APPROVAL_FLAG APPROVAL_FLAG
, CUSTOMER_CONTACT_ID CUSTOMER_CONTACT_ID
, CUSTOMER_CONTACT_DATE CUSTOMER_CONTACT_DATE
, REJECT_REASON_CODE REJECT_REASON_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
FROM "CS"."CS_ESTIMATES"