VIEW: OSM.AS_QUOTES_ALL#

Source

View Text - Preformatted

select QUOTE_ID QUOTE_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID, PRICE_LIST_ID PRICE_LIST_ID, QUOTE_STATUS QUOTE_STATUS, CUSTOMER_ID CUSTOMER_ID, ADDRESS_ID ADDRESS_ID, QUOTE_NAME QUOTE_NAME, QUOTE_NUMBER QUOTE_NUMBER, QUOTE_VERSION QUOTE_VERSION, CURRENCY_CODE CURRENCY_CODE, TOTAL_QUOTE_PRICE TOTAL_QUOTE_PRICE, CONTACT_ID CONTACT_ID, DESCRIPTION DESCRIPTION, ORIGINAL_QUOTE_ID ORIGINAL_QUOTE_ID, QUOTE_START_DATE QUOTE_START_DATE, QUOTE_END_DATE QUOTE_END_DATE, QUOTE_LETTER_ID QUOTE_LETTER_ID, LEAD_ID LEAD_ID, PROMOTION_ID PROMOTION_ID, PURGE_ALLOWED_FLAG PURGE_ALLOWED_FLAG, ORDER_DATE ORDER_DATE, ORDER_TYPE_ID ORDER_TYPE_ID, HEADER_ID HEADER_ID, TAX_EXEMPT_NUM TAX_EXEMPT_NUM, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, TOTAL_LIST_PRICE TOTAL_LIST_PRICE, TOTAL_DISCOUNT_AMOUNT TOTAL_DISCOUNT_AMOUNT, TOTAL_DISCOUNT_PERCENT TOTAL_DISCOUNT_PERCENT, DISCOUNT_MTHD_CODE DISCOUNT_MTHD_CODE, DISCOUNT_ID DISCOUNT_ID, TOTAL_TAX TOTAL_TAX, APPROVAL_PERSON_ID APPROVAL_PERSON_ID, APPROVAL_FLAG APPROVAL_FLAG, APPROVAL_DATE APPROVAL_DATE, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, INVOICE_TO_SITE_USE_ID INVOICE_TO_SITE_USE_ID, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, INVOICING_RULE_ID INVOICING_RULE_ID, AGREEMENT_ID AGREEMENT_ID, PAYMENT_TERM_ID PAYMENT_TERM_ID, PURCHASE_ORDER_NUM PURCHASE_ORDER_NUM, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, SHIP_METHOD_CODE SHIP_METHOD_CODE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, FOB_CODE FOB_CODE, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_TYPE_CODE EXCHANGE_TYPE_CODE, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE, PAYMENT_AMOUNT PAYMENT_AMOUNT, CHECK_NUMBER CHECK_NUMBER, CREDIT_CARD_CODE CREDIT_CARD_CODE, CREDIT_CARD_HOLDER_NAME CREDIT_CARD_HOLDER_NAME, CREDIT_CARD_NUMBER CREDIT_CARD_NUMBER, CREDIT_CARD_EXPIRATION_DATE CREDIT_CARD_EXPIRATION_DATE, CREDIT_CARD_APPROVAL_CODE CREDIT_CARD_APPROVAL_CODE, 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, SALES_CHANNEL_CODE SALES_CHANNEL_CODE, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG, ORG_ID ORG_ID, NEED_BY_DATE NEED_BY_DATE, SHIPPING_COST SHIPPING_COST from "OSM"."AS_QUOTES_ALL"

View Text - HTML Formatted

SELECT QUOTE_ID QUOTE_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID
, PRICE_LIST_ID PRICE_LIST_ID
, QUOTE_STATUS QUOTE_STATUS
, CUSTOMER_ID CUSTOMER_ID
, ADDRESS_ID ADDRESS_ID
, QUOTE_NAME QUOTE_NAME
, QUOTE_NUMBER QUOTE_NUMBER
, QUOTE_VERSION QUOTE_VERSION
, CURRENCY_CODE CURRENCY_CODE
, TOTAL_QUOTE_PRICE TOTAL_QUOTE_PRICE
, CONTACT_ID CONTACT_ID
, DESCRIPTION DESCRIPTION
, ORIGINAL_QUOTE_ID ORIGINAL_QUOTE_ID
, QUOTE_START_DATE QUOTE_START_DATE
, QUOTE_END_DATE QUOTE_END_DATE
, QUOTE_LETTER_ID QUOTE_LETTER_ID
, LEAD_ID LEAD_ID
, PROMOTION_ID PROMOTION_ID
, PURGE_ALLOWED_FLAG PURGE_ALLOWED_FLAG
, ORDER_DATE ORDER_DATE
, ORDER_TYPE_ID ORDER_TYPE_ID
, HEADER_ID HEADER_ID
, TAX_EXEMPT_NUM TAX_EXEMPT_NUM
, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, TOTAL_LIST_PRICE TOTAL_LIST_PRICE
, TOTAL_DISCOUNT_AMOUNT TOTAL_DISCOUNT_AMOUNT
, TOTAL_DISCOUNT_PERCENT TOTAL_DISCOUNT_PERCENT
, DISCOUNT_MTHD_CODE DISCOUNT_MTHD_CODE
, DISCOUNT_ID DISCOUNT_ID
, TOTAL_TAX TOTAL_TAX
, APPROVAL_PERSON_ID APPROVAL_PERSON_ID
, APPROVAL_FLAG APPROVAL_FLAG
, APPROVAL_DATE APPROVAL_DATE
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, INVOICE_TO_SITE_USE_ID INVOICE_TO_SITE_USE_ID
, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, INVOICING_RULE_ID INVOICING_RULE_ID
, AGREEMENT_ID AGREEMENT_ID
, PAYMENT_TERM_ID PAYMENT_TERM_ID
, PURCHASE_ORDER_NUM PURCHASE_ORDER_NUM
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, FOB_CODE FOB_CODE
, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_TYPE_CODE EXCHANGE_TYPE_CODE
, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE
, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, CHECK_NUMBER CHECK_NUMBER
, CREDIT_CARD_CODE CREDIT_CARD_CODE
, CREDIT_CARD_HOLDER_NAME CREDIT_CARD_HOLDER_NAME
, CREDIT_CARD_NUMBER CREDIT_CARD_NUMBER
, CREDIT_CARD_EXPIRATION_DATE CREDIT_CARD_EXPIRATION_DATE
, CREDIT_CARD_APPROVAL_CODE CREDIT_CARD_APPROVAL_CODE
, 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
, SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, ORG_ID ORG_ID
, NEED_BY_DATE NEED_BY_DATE
, SHIPPING_COST SHIPPING_COST
FROM "OSM"."AS_QUOTES_ALL"